#include "postgres.h"
#include <ctype.h>
#include "catalog/pg_collation.h"
#include "mb/pg_wchar.h"
#include "miscadmin.h"
#include "utils/fmgrprotos.h"
#include "utils/pg_locale.h"
#include "varatt.h"
#include "like_match.c"

Include dependency graph for like.c:

Macros
#define	LIKE_TRUE 1

#define	LIKE_FALSE 0

#define	LIKE_ABORT (-1)

#define	NextByte(p, plen) ((p)++, (plen)--)

#define	CHAREQ(p1, p1len, p2, p2len) wchareq((p1), (p1len), (p2), (p2len))

#define	NextChar(p, plen) do { int __l = pg_mblen_with_len((p), (plen)); (p) +=__l; (plen) -=__l; } while (0)

#define	CopyAdvChar(dst, src, srclen)

#define	MatchText MB_MatchText

#define	do_like_escape MB_do_like_escape

#define	CHAREQ(p1, p1len, p2, p2len) ((p1) == (p2))

#define	NextChar(p, plen) NextByte((p), (plen))

#define	CopyAdvChar(dst, src, srclen) ((dst)++ = (src)++, (srclen)--)

#define	MatchText SB_MatchText

#define	do_like_escape SB_do_like_escape

#define	MATCH_LOWER

#define	NextChar(p, plen) NextByte((p), (plen))

#define	MatchText C_IMatchText

#define	NextChar(p, plen) do { (p)++; (plen)--; } while ((plen) > 0 && (*(p) & 0xC0) == 0x80 )

#define	MatchText UTF8_MatchText

Functions
static int	SB_MatchText (const char t, int tlen, const char p, int plen, pg_locale_t locale)

static text *	SB_do_like_escape (text pat, text esc)

static int	MB_MatchText (const char t, int tlen, const char p, int plen, pg_locale_t locale)

static text *	MB_do_like_escape (text pat, text esc)

static int	UTF8_MatchText (const char t, int tlen, const char p, int plen, pg_locale_t locale)

static int	C_IMatchText (const char t, int tlen, const char p, int plen, pg_locale_t locale)

static int	GenericMatchText (const char s, int slen, const char p, int plen, Oid collation)

static int	Generic_Text_IC_like (text str, text pat, Oid collation)

static int	wchareq (const char p1, int p1len, const char p2, int p2len)

Datum	namelike (PG_FUNCTION_ARGS)

Datum	namenlike (PG_FUNCTION_ARGS)

Datum	textlike (PG_FUNCTION_ARGS)

Datum	textnlike (PG_FUNCTION_ARGS)

Datum	bytealike (PG_FUNCTION_ARGS)

Datum	byteanlike (PG_FUNCTION_ARGS)

Datum	nameiclike (PG_FUNCTION_ARGS)

Datum	nameicnlike (PG_FUNCTION_ARGS)

Datum	texticlike (PG_FUNCTION_ARGS)

Datum	texticnlike (PG_FUNCTION_ARGS)

Datum	like_escape (PG_FUNCTION_ARGS)

Datum	like_escape_bytea (PG_FUNCTION_ARGS)

Macro Definition Documentation

◆ CHAREQ [1/2]

#define CHAREQ	(	p1,
		p1len,
		p2,
		p2len
	)	wchareq((p1), (p1len), (p2), (p2len))

Definition at line 96 of file like.c.

◆ CHAREQ [2/2]

#define CHAREQ	(	p1,
		p1len,
		p2,
		p2len
	)	((p1) == (p2))

Definition at line 96 of file like.c.

◆ CopyAdvChar [1/2]

#define CopyAdvChar	(	dst,
		src,
		srclen
	)

Value:

    do { int __l = pg_mblen_with_len((src), (srclen)); \
         (srclen) -= __l; \
		 while (__l-- > 0) \
             *(dst)++ = *(src)++; \
       } while (0)

Definition at line 99 of file like.c.

       { int __l = pg_mblen_with_len((src), (srclen)); \
         (srclen) -= __l; \
		 while (__l-- > 0) \
             *(dst)++ = *(src)++; \
       } while (0)

◆ CopyAdvChar [2/2]

#define CopyAdvChar	(	dst,
		src,
		srclen
	)	((dst)++ = (src)++, (srclen)--)

Definition at line 99 of file like.c.

       { int __l = pg_mblen_with_len((src), (srclen)); \
         (srclen) -= __l; \
		 while (__l-- > 0) \
             *(dst)++ = *(src)++; \
       } while (0)

◆ do_like_escape [1/2]

#define do_like_escape MB_do_like_escape

Definition at line 107 of file like.c.

◆ do_like_escape [2/2]

#define do_like_escape SB_do_like_escape

Definition at line 107 of file like.c.

◆ LIKE_ABORT

#define LIKE_ABORT (-1)

Definition at line 32 of file like.c.

◆ LIKE_FALSE

#define LIKE_FALSE 0

Definition at line 31 of file like.c.

◆ LIKE_TRUE

#define LIKE_TRUE 1

Definition at line 30 of file like.c.

◆ MATCH_LOWER

#define MATCH_LOWER

Definition at line 122 of file like.c.

◆ MatchText [1/4]

#define MatchText MB_MatchText

Definition at line 106 of file like.c.

◆ MatchText [2/4]

#define MatchText SB_MatchText

Definition at line 106 of file like.c.

◆ MatchText [3/4]

#define MatchText C_IMatchText

Definition at line 106 of file like.c.

◆ MatchText [4/4]

#define MatchText UTF8_MatchText

Definition at line 106 of file like.c.

◆ NextByte

#define NextByte	(	p,
		plen
	)	((p)++, (plen)--)

Definition at line 93 of file like.c.

◆ NextChar [1/4]

#define NextChar	(	p,
		plen
	)	do { int __l = pg_mblen_with_len((p), (plen)); (p) +=__l; (plen) -=__l; } while (0)

Definition at line 97 of file like.c.

98 { int __l = pg_mblen_with_len((p), (plen)); (p) +=__l; (plen) -=__l; } while (0)

◆ NextChar [2/4]

#define NextChar	(	p,
		plen
	)	NextByte((p), (plen))

Definition at line 97 of file like.c.

98 { int __l = pg_mblen_with_len((p), (plen)); (p) +=__l; (plen) -=__l; } while (0)

◆ NextChar [3/4]

#define NextChar	(	p,
		plen
	)	NextByte((p), (plen))

Definition at line 97 of file like.c.

98 { int __l = pg_mblen_with_len((p), (plen)); (p) +=__l; (plen) -=__l; } while (0)

◆ NextChar [4/4]

#define NextChar	(	p,
		plen
	)	do { (p)++; (plen)--; } while ((plen) > 0 && (*(p) & 0xC0) == 0x80 )

Definition at line 97 of file like.c.

98 { int __l = pg_mblen_with_len((p), (plen)); (p) +=__l; (plen) -=__l; } while (0)

Function Documentation

◆ bytealike()

Datum bytealike ( PG_FUNCTION_ARGS )

Definition at line 318 of file like.c.

{
    bytea      *str = PG_GETARG_BYTEA_PP(0);
    bytea      *pat = PG_GETARG_BYTEA_PP(1);
    bool        result;
    char       *s,
               *p;
    int         slen,
                plen;
 
    s = VARDATA_ANY(str);
    slen = VARSIZE_ANY_EXHDR(str);
    p = VARDATA_ANY(pat);
    plen = VARSIZE_ANY_EXHDR(pat);
 
    result = (SB_MatchText(s, slen, p, plen, 0) == LIKE_TRUE);
 
    PG_RETURN_BOOL(result);
}

References fb(), LIKE_TRUE, PG_GETARG_BYTEA_PP, PG_RETURN_BOOL, result, SB_MatchText(), str, VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

◆ byteanlike()

Datum byteanlike ( PG_FUNCTION_ARGS )

Definition at line 339 of file like.c.

{
    bytea      *str = PG_GETARG_BYTEA_PP(0);
    bytea      *pat = PG_GETARG_BYTEA_PP(1);
    bool        result;
    char       *s,
               *p;
    int         slen,
                plen;
 
    s = VARDATA_ANY(str);
    slen = VARSIZE_ANY_EXHDR(str);
    p = VARDATA_ANY(pat);
    plen = VARSIZE_ANY_EXHDR(pat);
 
    result = (SB_MatchText(s, slen, p, plen, 0) != LIKE_TRUE);
 
    PG_RETURN_BOOL(result);
}

References fb(), LIKE_TRUE, PG_GETARG_BYTEA_PP, PG_RETURN_BOOL, result, SB_MatchText(), str, VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

◆ C_IMatchText()

static int C_IMatchText	(	const char *	t,
		int	tlen,
		const char *	p,
		int	plen,
		pg_locale_t	locale
	)

static

Referenced by Generic_Text_IC_like().

◆ Generic_Text_IC_like()

static int Generic_Text_IC_like	(	text *	str,
		text *	pat,
		Oid	collation
	)

inlinestatic

Definition at line 165 of file like.c.

{
    char       *s,
               *p;
    int         slen,
                plen;
    pg_locale_t locale;
 
    if (!OidIsValid(collation))
    {
        /*
         * This typically means that the parser could not resolve a conflict
         * of implicit collations, so report it that way.
         */
        ereport(ERROR,
                (errcode(ERRCODE_INDETERMINATE_COLLATION),
                 errmsg("could not determine which collation to use for ILIKE"),
                 errhint("Use the COLLATE clause to set the collation explicitly.")));
    }
 
    locale = pg_newlocale_from_collation(collation);
 
    if (!locale->deterministic)
        ereport(ERROR,
                (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                 errmsg("nondeterministic collations are not supported for ILIKE")));
 
    /*
     * For efficiency reasons, in the C locale we don't call lower() on the
     * pattern and text, but instead lowercase each character lazily. This
     * only works for single-byte encodings, otherwise "_" may incorrectly
     * match an incomplete byte sequence.
     *
     * XXX: use casefolding instead?
     */
 
    if (locale->ctype_is_c && pg_database_encoding_max_length() == 1)
    {
        p = VARDATA_ANY(pat);
        plen = VARSIZE_ANY_EXHDR(pat);
        s = VARDATA_ANY(str);
        slen = VARSIZE_ANY_EXHDR(str);
        return C_IMatchText(s, slen, p, plen, locale);
    }
    else
    {
        pat = DatumGetTextPP(DirectFunctionCall1Coll(lower, collation,
                                                     PointerGetDatum(pat)));
        p = VARDATA_ANY(pat);
        plen = VARSIZE_ANY_EXHDR(pat);
        str = DatumGetTextPP(DirectFunctionCall1Coll(lower, collation,
                                                     PointerGetDatum(str)));
        s = VARDATA_ANY(str);
        slen = VARSIZE_ANY_EXHDR(str);
 
        if (GetDatabaseEncoding() == PG_UTF8)
            return UTF8_MatchText(s, slen, p, plen, 0);
        else if (pg_database_encoding_max_length() > 1)
            return MB_MatchText(s, slen, p, plen, 0);
        else
            return SB_MatchText(s, slen, p, plen, 0);
    }
}

References C_IMatchText(), pg_locale_struct::ctype_is_c, DatumGetTextPP, pg_locale_struct::deterministic, DirectFunctionCall1Coll(), ereport, errcode(), errhint(), errmsg, ERROR, fb(), GetDatabaseEncoding(), lower(), MB_MatchText(), OidIsValid, pg_database_encoding_max_length(), pg_newlocale_from_collation(), PG_UTF8, PointerGetDatum, SB_MatchText(), str, UTF8_MatchText(), VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

Referenced by nameiclike(), nameicnlike(), texticlike(), and texticnlike().

◆ GenericMatchText()

static int GenericMatchText	(	const char *	s,
		int	slen,
		const char *	p,
		int	plen,
		Oid	collation
	)

inlinestatic

Definition at line 138 of file like.c.

{
    pg_locale_t locale;
 
    if (!OidIsValid(collation))
    {
        /*
         * This typically means that the parser could not resolve a conflict
         * of implicit collations, so report it that way.
         */
        ereport(ERROR,
                (errcode(ERRCODE_INDETERMINATE_COLLATION),
                 errmsg("could not determine which collation to use for LIKE"),
                 errhint("Use the COLLATE clause to set the collation explicitly.")));
    }
 
    locale = pg_newlocale_from_collation(collation);
 
    if (pg_database_encoding_max_length() == 1)
        return SB_MatchText(s, slen, p, plen, locale);
    else if (GetDatabaseEncoding() == PG_UTF8)
        return UTF8_MatchText(s, slen, p, plen, locale);
    else
        return MB_MatchText(s, slen, p, plen, locale);
}

References ereport, errcode(), errhint(), errmsg, ERROR, fb(), GetDatabaseEncoding(), MB_MatchText(), OidIsValid, pg_database_encoding_max_length(), pg_newlocale_from_collation(), PG_UTF8, SB_MatchText(), and UTF8_MatchText().

Referenced by namelike(), namenlike(), textlike(), and textnlike().

◆ like_escape()

Datum like_escape ( PG_FUNCTION_ARGS )

Definition at line 422 of file like.c.

{
    text       *pat = PG_GETARG_TEXT_PP(0);
    text       *esc = PG_GETARG_TEXT_PP(1);
    text       *result;
 
    if (pg_database_encoding_max_length() == 1)
        result = SB_do_like_escape(pat, esc);
    else
        result = MB_do_like_escape(pat, esc);
 
    PG_RETURN_TEXT_P(result);
}

References fb(), MB_do_like_escape(), pg_database_encoding_max_length(), PG_GETARG_TEXT_PP, PG_RETURN_TEXT_P, result, and SB_do_like_escape().

◆ like_escape_bytea()

Datum like_escape_bytea ( PG_FUNCTION_ARGS )

Definition at line 441 of file like.c.

{
    bytea      *pat = PG_GETARG_BYTEA_PP(0);
    bytea      *esc = PG_GETARG_BYTEA_PP(1);
    bytea      *result = SB_do_like_escape((text *) pat, (text *) esc);
 
    PG_RETURN_BYTEA_P((bytea *) result);
}

References fb(), PG_GETARG_BYTEA_PP, PG_RETURN_BYTEA_P, result, and SB_do_like_escape().

◆ MB_do_like_escape()

static text * MB_do_like_escape	(	text *	pat,
		text *	esc
	)

static

Referenced by like_escape().

◆ MB_MatchText()

static int MB_MatchText	(	const char *	t,
		int	tlen,
		const char *	p,
		int	plen,
		pg_locale_t	locale
	)

static

Referenced by Generic_Text_IC_like(), and GenericMatchText().

◆ nameiclike()

Datum nameiclike ( PG_FUNCTION_ARGS )

Definition at line 364 of file like.c.

{
    Name        str = PG_GETARG_NAME(0);
    text       *pat = PG_GETARG_TEXT_PP(1);
    bool        result;
    text       *strtext;
 
    strtext = DatumGetTextPP(DirectFunctionCall1(name_text,
                                                 NameGetDatum(str)));
    result = (Generic_Text_IC_like(strtext, pat, PG_GET_COLLATION()) == LIKE_TRUE);
 
    PG_RETURN_BOOL(result);
}

References DatumGetTextPP, DirectFunctionCall1, fb(), Generic_Text_IC_like(), LIKE_TRUE, name_text(), NameGetDatum(), PG_GET_COLLATION, PG_GETARG_NAME, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, result, and str.

◆ nameicnlike()

Datum nameicnlike ( PG_FUNCTION_ARGS )

Definition at line 379 of file like.c.

{
    Name        str = PG_GETARG_NAME(0);
    text       *pat = PG_GETARG_TEXT_PP(1);
    bool        result;
    text       *strtext;
 
    strtext = DatumGetTextPP(DirectFunctionCall1(name_text,
                                                 NameGetDatum(str)));
    result = (Generic_Text_IC_like(strtext, pat, PG_GET_COLLATION()) != LIKE_TRUE);
 
    PG_RETURN_BOOL(result);
}

References DatumGetTextPP, DirectFunctionCall1, fb(), Generic_Text_IC_like(), LIKE_TRUE, name_text(), NameGetDatum(), PG_GET_COLLATION, PG_GETARG_NAME, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, result, and str.

◆ namelike()

Datum namelike ( PG_FUNCTION_ARGS )

Definition at line 234 of file like.c.

{
    Name        str = PG_GETARG_NAME(0);
    text       *pat = PG_GETARG_TEXT_PP(1);
    bool        result;
    char       *s,
               *p;
    int         slen,
                plen;
 
    s = NameStr(*str);
    slen = strlen(s);
    p = VARDATA_ANY(pat);
    plen = VARSIZE_ANY_EXHDR(pat);
 
    result = (GenericMatchText(s, slen, p, plen, PG_GET_COLLATION()) == LIKE_TRUE);
 
    PG_RETURN_BOOL(result);
}

References fb(), GenericMatchText(), LIKE_TRUE, NameStr, PG_GET_COLLATION, PG_GETARG_NAME, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, result, str, VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

◆ namenlike()

Datum namenlike ( PG_FUNCTION_ARGS )

Definition at line 255 of file like.c.

{
    Name        str = PG_GETARG_NAME(0);
    text       *pat = PG_GETARG_TEXT_PP(1);
    bool        result;
    char       *s,
               *p;
    int         slen,
                plen;
 
    s = NameStr(*str);
    slen = strlen(s);
    p = VARDATA_ANY(pat);
    plen = VARSIZE_ANY_EXHDR(pat);
 
    result = (GenericMatchText(s, slen, p, plen, PG_GET_COLLATION()) != LIKE_TRUE);
 
    PG_RETURN_BOOL(result);
}

References fb(), GenericMatchText(), LIKE_TRUE, NameStr, PG_GET_COLLATION, PG_GETARG_NAME, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, result, str, VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

◆ SB_do_like_escape()

static text * SB_do_like_escape	(	text *	pat,
		text *	esc
	)

static

Referenced by like_escape(), and like_escape_bytea().

◆ SB_MatchText()

static int SB_MatchText	(	const char *	t,
		int	tlen,
		const char *	p,
		int	plen,
		pg_locale_t	locale
	)

static

Referenced by bytealike(), byteanlike(), Generic_Text_IC_like(), and GenericMatchText().

◆ texticlike()

Datum texticlike ( PG_FUNCTION_ARGS )

Definition at line 394 of file like.c.

{
    text       *str = PG_GETARG_TEXT_PP(0);
    text       *pat = PG_GETARG_TEXT_PP(1);
    bool        result;
 
    result = (Generic_Text_IC_like(str, pat, PG_GET_COLLATION()) == LIKE_TRUE);
 
    PG_RETURN_BOOL(result);
}

References fb(), Generic_Text_IC_like(), LIKE_TRUE, PG_GET_COLLATION, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, result, and str.

◆ texticnlike()

Datum texticnlike ( PG_FUNCTION_ARGS )

Definition at line 406 of file like.c.

{
    text       *str = PG_GETARG_TEXT_PP(0);
    text       *pat = PG_GETARG_TEXT_PP(1);
    bool        result;
 
    result = (Generic_Text_IC_like(str, pat, PG_GET_COLLATION()) != LIKE_TRUE);
 
    PG_RETURN_BOOL(result);
}

References fb(), Generic_Text_IC_like(), LIKE_TRUE, PG_GET_COLLATION, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, result, and str.

◆ textlike()

Datum textlike ( PG_FUNCTION_ARGS )

Definition at line 276 of file like.c.

{
    text       *str = PG_GETARG_TEXT_PP(0);
    text       *pat = PG_GETARG_TEXT_PP(1);
    bool        result;
    char       *s,
               *p;
    int         slen,
                plen;
 
    s = VARDATA_ANY(str);
    slen = VARSIZE_ANY_EXHDR(str);
    p = VARDATA_ANY(pat);
    plen = VARSIZE_ANY_EXHDR(pat);
 
    result = (GenericMatchText(s, slen, p, plen, PG_GET_COLLATION()) == LIKE_TRUE);
 
    PG_RETURN_BOOL(result);
}

References fb(), GenericMatchText(), LIKE_TRUE, PG_GET_COLLATION, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, result, str, VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

◆ textnlike()

Datum textnlike ( PG_FUNCTION_ARGS )

Definition at line 297 of file like.c.

{
    text       *str = PG_GETARG_TEXT_PP(0);
    text       *pat = PG_GETARG_TEXT_PP(1);
    bool        result;
    char       *s,
               *p;
    int         slen,
                plen;
 
    s = VARDATA_ANY(str);
    slen = VARSIZE_ANY_EXHDR(str);
    p = VARDATA_ANY(pat);
    plen = VARSIZE_ANY_EXHDR(pat);
 
    result = (GenericMatchText(s, slen, p, plen, PG_GET_COLLATION()) != LIKE_TRUE);
 
    PG_RETURN_BOOL(result);
}

References fb(), GenericMatchText(), LIKE_TRUE, PG_GET_COLLATION, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, result, str, VARDATA_ANY(), and VARSIZE_ANY_EXHDR().

◆ UTF8_MatchText()

static int UTF8_MatchText	(	const char *	t,
		int	tlen,
		const char *	p,
		int	plen,
		pg_locale_t	locale
	)

static

Referenced by Generic_Text_IC_like(), and GenericMatchText().

◆ wchareq()

static int wchareq	(	const char *	p1,
		int	p1len,
		const char *	p2,
		int	p2len
	)

inlinestatic

Definition at line 58 of file like.c.

{
    int         p1clen;
 
    /* Optimization:  quickly compare the first byte. */
    if (*p1 != *p2)
        return 0;
 
    p1clen = pg_mblen_with_len(p1, p1len);
    if (pg_mblen_with_len(p2, p2len) != p1clen)
        return 0;
 
    /* They are the same length */
    while (p1clen--)
    {
        if (*p1++ != *p2++)
            return 0;
    }
    return 1;
}

References fb(), and pg_mblen_with_len().

Macros

Functions

Macro Definition Documentation

◆ CHAREQ [1/2]

◆ CHAREQ [2/2]

◆ CopyAdvChar [1/2]

◆ CopyAdvChar [2/2]

◆ do_like_escape [1/2]

◆ do_like_escape [2/2]

◆ LIKE_ABORT

◆ LIKE_FALSE

◆ LIKE_TRUE

◆ MATCH_LOWER

◆ MatchText [1/4]

◆ MatchText [2/4]

◆ MatchText [3/4]

◆ MatchText [4/4]

◆ NextByte

◆ NextChar [1/4]

◆ NextChar [2/4]

◆ NextChar [3/4]

◆ NextChar [4/4]

Function Documentation

◆ bytealike()

◆ byteanlike()

◆ C_IMatchText()

◆ Generic_Text_IC_like()

◆ GenericMatchText()

◆ like_escape()

◆ like_escape_bytea()

◆ MB_do_like_escape()

◆ MB_MatchText()

◆ nameiclike()

◆ nameicnlike()

◆ namelike()

◆ namenlike()

◆ SB_do_like_escape()

◆ SB_MatchText()

◆ texticlike()

◆ texticnlike()

◆ textlike()

◆ textnlike()

◆ UTF8_MatchText()

◆ wchareq()