Re: AW: like and optimization - Mailing list pgsql-hackers

From Tom Lane
Subject Re: AW: like and optimization
Date
Msg-id 21256.980176687@sss.pgh.pa.us
Whole thread Raw
In response to AW: like and optimization  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
Responses Re: AW: like and optimization
List pgsql-hackers
Zeugswetter Andreas SB  <ZeugswetterA@wien.spardat.at> writes:
> Just to understand things correctly. Is the Like optimization disabled
> for all non-ASCII char sets, or (imho correctly) for non charset ordered 
> collations (LC_COLLATE) ?

Currently it's disabled whenever LC_COLLATE is neither C nor POSIX.
We can add other names to the "OK" list as we verify that they are safe
(see locale_is_like_safe() in src/backend/utils/adt/selfuncs.c).
        regards, tom lane


pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: [PATCHES] Small patch to replace 'idle' by 'trans' if transactionis still open
Next
From: The Hermit Hacker
Date:
Subject: Re: MySQL and BerkleyDB (fwd)