Re: Can LIKE use indexes or not? - Mailing list pgsql-general

From David Garamond
Subject Re: Can LIKE use indexes or not?
Date
Msg-id 40222C2F.6040906@zara.6.isreserved.com
Whole thread Raw
In response to Re: Can LIKE use indexes or not?  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Richard Huxton wrote:
> On Thursday 05 February 2004 10:25, David Garamond wrote:
>
> Glad to see your problem is solved. Your locale/charset settings look a bit
> odd though:
>
>># These settings are initialized by initdb -- they may be changed
>>lc_messages = 'en_US.iso885915' #locale for system error message strings
>>lc_monetary = 'en_US.iso885915' #locale for monetary formatting
>>lc_numeric = 'en_US.iso885915'  #locale for number formatting
>>lc_time = 'en_US.iso885915'     #locale for time formatting
>
> US English with 8859-15 (Latin 9?) charset? Can I as what OS this is? It's
> just that it seems like an odd combination to me - or am I displaying my
> ignorance here?

It's Redhat 7.3 running under VMWare Workstation 4.0.* The host OS is
Windows 2000 + SP4. All software are pretty much left to their defaults.

* Of course, we use "real" Linux for production; this is just my home
machine.

--
dave


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: size of mailing lists?
Next
From: David Garamond
Date:
Subject: Re: size of mailing lists?