Re: Locale vs LIKE

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Stephen Denne" <Stephen(dot)Denne(at)datamail(dot)co(dot)nz>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Locale vs LIKE
Date: 2008-02-13 07:53:31
Message-ID: 871w7h9ts4.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


"Stephen Denne" <Stephen(dot)Denne(at)datamail(dot)co(dot)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!

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Smith 2008-02-13 08:41:50 Re: Patch review
Previous Message Tom Lane 2008-02-13 03:47:10 Re: REL8_3_STABLE branch created ...