Re: AW: [HACKERS] like and optimization

2001-01-24 Thread Patrick Welche
On Mon, Jan 22, 2001 at 05:46:09PM -0500, Tom Lane wrote: ... Are there any BSD-license locale and/or timezone libraries that we might assimilate in this way? We could use an LGPL'd library if there is no other alternative, but I'd just as soon not open up the license issue. The "Citrus

Re: AW: [HACKERS] like and optimization

2001-01-24 Thread Patrick Welche
On Mon, Jan 22, 2001 at 03:09:03PM -0800, Nathan Myers wrote: ... Posix systems include a set of commands for dumping locales in a standard format, and building from them. Instead of shipping locales and code to operate on them, one might include a script to run these tools (where they

Re: AW: [HACKERS] like and optimization

2001-01-22 Thread 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

Re: AW: [HACKERS] like and optimization

2001-01-22 Thread Peter Eisentraut
Tom Lane writes: 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

Re: AW: [HACKERS] like and optimization

2001-01-22 Thread Hannu Krosing
Peter Eisentraut wrote: Tom Lane writes: 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

Re: AW: [HACKERS] like and optimization

2001-01-22 Thread Tom Lane
Hannu Krosing [EMAIL PROTECTED] writes: Is there any possibility to use, in a portable way, only our own locale definition files, without reimplementing all the sorts uppercases etc. ? AFAIK there is not --- the standard C library APIs do not specify how to represent this information. Thus,

Re: AW: [HACKERS] like and optimization

2001-01-22 Thread Nathan Myers
On Mon, Jan 22, 2001 at 05:46:09PM -0500, Tom Lane wrote: Hannu Krosing [EMAIL PROTECTED] writes: Is there any possibility to use, in a portable way, only our own locale definition files, without reimplementing all the sorts uppercases etc. ? The situation is not too much different for

Re: AW: [HACKERS] like and optimization

2001-01-22 Thread Tatsuo Ishii
And IIRC SQL9x prescribe support for multiple locales (or at least multiple collating sequences) within one database simultaneously. Sounds like SQL92/99 COLLATE things is the way we should go, IMHO. -- Tatsuo Ishii