Re: Possible solution for LIKE optimization - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Possible solution for LIKE optimization
Date
Msg-id Pine.LNX.4.30.0108062140470.680-100000@peter.localdomain
Whole thread Raw
In response to Re: Possible solution for LIKE optimization  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Possible solution for LIKE optimization
List pgsql-hackers
Tom Lane writes:

> On the other hand, LIKE *is* multibyte aware.  So the hypothetical
> non-locale-aware comparison operators would need to be aware of
> multibyte character sets even though not aware of locale.  And the
> "add one" operator that we postulated for the LIKE index optimization
> needs to be able to increment a multibyte character.

Both of these are not hard if you know how strcmp operates.  It would also
be irrelevant whether "add one" to a multibyte character yields another
valid multibyte character.  strcmp doesn't care.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Possible solution for LIKE optimization
Next
From: Tom Lane
Date:
Subject: Re: Re: AW: Re: OID wraparound: summary and proposal