like.c File Reference

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

Include dependency graph for like.c:

Go to the source code of this file.

Macros
#define	LIKE_TRUE   1
#define	LIKE_FALSE   0
#define	LIKE_ABORT   (-1)
#define	NextByte(p, plen)   ((p)++, (plen)--)
#define	CHAREQ(p1, p2)   wchareq((p1), (p2))
#define	NextChar(p, plen)    do { int __l = pg_mblen(p); (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, p2)   (*(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(t)   SB_lower_char((unsigned char) (t), locale, locale_is_c)
#define	NextChar(p, plen)   NextByte((p), (plen))
#define	MatchText   SB_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, bool locale_is_c)
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, bool locale_is_c)
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, bool locale_is_c)
static int	SB_IMatchText (const char *t, int tlen, const char *p, int plen, pg_locale_t locale, bool locale_is_c)
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, const char *p2)
static char	SB_lower_char (unsigned char c, pg_locale_t locale, bool locale_is_c)
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,
			p2
	)		wchareq((p1), (p2))

Definition at line 126 of file like.c.

CHAREQ [2/2]

#define CHAREQ	(		p1,
			p2
	)		(*(p1) == *(p2))

Definition at line 126 of file like.c.

CopyAdvChar [1/2]

#define CopyAdvChar	(		dst,
			src,
			srclen
	)

Value:

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

Definition at line 128 of file like.c.

CopyAdvChar [2/2]

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

Definition at line 128 of file like.c.

do_like_escape [1/2]

#define do_like_escape   MB_do_like_escape

Definition at line 131 of file like.c.

do_like_escape [2/2]

#define do_like_escape   SB_do_like_escape

Definition at line 131 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

(

t

)

SB_lower_char((unsigned char) (t), locale, locale_is_c)

Definition at line 136 of file like.c.

MatchText [1/4]

#define MatchText   MB_MatchText

Definition at line 146 of file like.c.

MatchText [2/4]

#define MatchText   SB_MatchText

Definition at line 146 of file like.c.

MatchText [3/4]

#define MatchText   SB_IMatchText

Definition at line 146 of file like.c.

MatchText [4/4]

#define MatchText   UTF8_MatchText

Definition at line 146 of file like.c.

NextByte

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

Definition at line 107 of file like.c.

NextChar [1/4]

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

Definition at line 144 of file like.c.

NextChar [2/4]

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

Definition at line 144 of file like.c.

NextChar [3/4]

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

Definition at line 144 of file like.c.

NextChar [4/4]

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

Definition at line 144 of file like.c.

Function Documentation

bytealike()

Datum bytealike

(

PG_FUNCTION_ARGS

)

Definition at line 326 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, true) == LIKE_TRUE);
 
    PG_RETURN_BOOL(result);
}

References LIKE_TRUE, PG_GETARG_BYTEA_PP, PG_RETURN_BOOL, SB_MatchText(), generate_unaccent_rules::str, VARDATA_ANY, and VARSIZE_ANY_EXHDR.

byteanlike()

Datum byteanlike

(

PG_FUNCTION_ARGS

)

Definition at line 347 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, true) != LIKE_TRUE);
 
    PG_RETURN_BOOL(result);
}

References LIKE_TRUE, PG_GETARG_BYTEA_PP, PG_RETURN_BOOL, SB_MatchText(), generate_unaccent_rules::str, VARDATA_ANY, and VARSIZE_ANY_EXHDR.

Generic_Text_IC_like()

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

inlinestatic

Definition at line 173 of file like.c.

{
    char       *s,
               *p;
    int         slen,
                plen;
    pg_locale_t locale = 0;
    bool        locale_is_c = false;
 
    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.")));
    }
 
    if (lc_ctype_is_c(collation))
        locale_is_c = true;
    else
        locale = pg_newlocale_from_collation(collation);
 
    if (!pg_locale_deterministic(locale))
        ereport(ERROR,
                (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                 errmsg("nondeterministic collations are not supported for ILIKE")));
 
    /*
     * For efficiency reasons, in the single byte case we don't call lower()
     * on the pattern and text, but instead call SB_lower_char on each
     * character.  In the multi-byte case we don't have much choice :-(. Also,
     * ICU does not support single-character case folding, so we go the long
     * way.
     */
 
    if (pg_database_encoding_max_length() > 1 || (locale && locale->provider == COLLPROVIDER_ICU))
    {
        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, true);
        else
            return MB_MatchText(s, slen, p, plen, 0, true);
    }
    else
    {
        p = VARDATA_ANY(pat);
        plen = VARSIZE_ANY_EXHDR(pat);
        s = VARDATA_ANY(str);
        slen = VARSIZE_ANY_EXHDR(str);
        return SB_IMatchText(s, slen, p, plen, locale, locale_is_c);
    }
}

References DatumGetTextPP, DirectFunctionCall1Coll(), ereport, errcode(), errhint(), errmsg(), ERROR, GetDatabaseEncoding(), lc_ctype_is_c(), locale, lower(), MB_MatchText(), OidIsValid, pg_database_encoding_max_length(), pg_locale_deterministic(), pg_newlocale_from_collation(), PG_UTF8, PointerGetDatum(), SB_IMatchText(), generate_unaccent_rules::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 152 of file like.c.

{
    if (collation && !lc_ctype_is_c(collation))
    {
        pg_locale_t locale = pg_newlocale_from_collation(collation);
 
        if (!pg_locale_deterministic(locale))
            ereport(ERROR,
                    (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                     errmsg("nondeterministic collations are not supported for LIKE")));
    }
 
    if (pg_database_encoding_max_length() == 1)
        return SB_MatchText(s, slen, p, plen, 0, true);
    else if (GetDatabaseEncoding() == PG_UTF8)
        return UTF8_MatchText(s, slen, p, plen, 0, true);
    else
        return MB_MatchText(s, slen, p, plen, 0, true);
}

References ereport, errcode(), errmsg(), ERROR, GetDatabaseEncoding(), lc_ctype_is_c(), locale, MB_MatchText(), pg_database_encoding_max_length(), pg_locale_deterministic(), 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 430 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 MB_do_like_escape(), pg_database_encoding_max_length(), PG_GETARG_TEXT_PP, PG_RETURN_TEXT_P, and SB_do_like_escape().

like_escape_bytea()

Datum like_escape_bytea

(

PG_FUNCTION_ARGS

)

Definition at line 449 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 PG_GETARG_BYTEA_PP, PG_RETURN_BYTEA_P, 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, bool  locale_is_c  )

static

Referenced by Generic_Text_IC_like(), and GenericMatchText().

nameiclike()

Datum nameiclike

(

PG_FUNCTION_ARGS

)

Definition at line 372 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, Generic_Text_IC_like(), LIKE_TRUE, name_text(), NameGetDatum(), PG_GET_COLLATION, PG_GETARG_NAME, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, and generate_unaccent_rules::str.

nameicnlike()

Datum nameicnlike

(

PG_FUNCTION_ARGS

)

Definition at line 387 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, Generic_Text_IC_like(), LIKE_TRUE, name_text(), NameGetDatum(), PG_GET_COLLATION, PG_GETARG_NAME, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, and generate_unaccent_rules::str.

namelike()

Datum namelike

(

PG_FUNCTION_ARGS

)

Definition at line 242 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 GenericMatchText(), LIKE_TRUE, NameStr, PG_GET_COLLATION, PG_GETARG_NAME, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, generate_unaccent_rules::str, VARDATA_ANY, and VARSIZE_ANY_EXHDR.

namenlike()

Datum namenlike

(

PG_FUNCTION_ARGS

)

Definition at line 263 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 GenericMatchText(), LIKE_TRUE, NameStr, PG_GET_COLLATION, PG_GETARG_NAME, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, generate_unaccent_rules::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_IMatchText()

static int SB_IMatchText ( const char *  t, int  tlen, const char *  p, int  plen, pg_locale_t  locale, bool  locale_is_c  )

static

Referenced by Generic_Text_IC_like().

SB_lower_char()

static char SB_lower_char ( unsigned char  c, pg_locale_t  locale, bool  locale_is_c  )

static

Definition at line 94 of file like.c.

{
    if (locale_is_c)
        return pg_ascii_tolower(c);
#ifdef HAVE_LOCALE_T
    else if (locale)
        return tolower_l(c, locale->info.lt);
#endif
    else
        return pg_tolower(c);
}

References locale, pg_ascii_tolower(), pg_tolower(), and tolower_l.

SB_MatchText()

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

static

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

texticlike()

Datum texticlike

(

PG_FUNCTION_ARGS

)

Definition at line 402 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 Generic_Text_IC_like(), LIKE_TRUE, PG_GET_COLLATION, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, and generate_unaccent_rules::str.

texticnlike()

Datum texticnlike

(

PG_FUNCTION_ARGS

)

Definition at line 414 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 Generic_Text_IC_like(), LIKE_TRUE, PG_GET_COLLATION, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, and generate_unaccent_rules::str.

textlike()

Datum textlike

(

PG_FUNCTION_ARGS

)

Definition at line 284 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 GenericMatchText(), LIKE_TRUE, PG_GET_COLLATION, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, generate_unaccent_rules::str, VARDATA_ANY, and VARSIZE_ANY_EXHDR.

textnlike()

Datum textnlike

(

PG_FUNCTION_ARGS

)

Definition at line 305 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 GenericMatchText(), LIKE_TRUE, PG_GET_COLLATION, PG_GETARG_TEXT_PP, PG_RETURN_BOOL, generate_unaccent_rules::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, bool  locale_is_c  )

static

Referenced by Generic_Text_IC_like(), and GenericMatchText().

wchareq()

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

inlinestatic

Definition at line 58 of file like.c.

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

References p2, and pg_mblen().