Postgres Pro
Downloads
Home   >   mailing lists

Re: Locale vs LIKE - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: Locale vs LIKE
Date
Msg-id 871w7h9ts4.fsf@oxford.xeocode.com
Whole thread Raw
In response to Locale vs LIKE  ("Stephen Denne" <Stephen.Denne@datamail.co.nz>)
List pgsql-hackers
Tree view 
"Stephen Denne" <Stephen.Denne@datamail.co.nz> writes:

> i.e. Do I still have to either initdb --locale=C or explicitly use
> text_pattern_ops?

yes, if you want an index to be used

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support!

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: REL8_3_STABLE branch created ...
Next
From: Greg Smith
Date:
Subject: Re: Patch review