Re: AW: [HACKERS] like and optimization

[Tom Lane]

Zeugswetter Andreas SB  <[EMAIL PROTECTED]> 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