Re: Can LIKE use indexes or not?

From: David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Can LIKE use indexes or not?
Date: 2004-02-05 11:42:39
Message-ID: 40222C2F.6040906@zara.6.isreserved.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Garamond 2004-02-05 11:50:21 Re: size of mailing lists?
Previous Message Richard Huxton 2004-02-05 11:20:27 Re: size of mailing lists?