Re: Index not used, performance problem - Mailing list pgsql-performance

On Sat, Mar 29, 2003 at 09:47:51PM +0800, Christopher Kings-Lynne wrote:
> the form 'FOO%', which is what you are doing.  However, I believe that
> PostgreSQL cannot do this if your database encoding is anything other than
> 'C'.  So, if you are using an Austrian encoding, it might not be able to

That is, you need to have had the LOCALE set to 'C' when you did
initdb.  It's not enough to change it afterwards.

A
--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110