Re: Regexps and Indices. - Mailing list pgsql-general

From Tom Lane
Subject Re: Regexps and Indices.
Date
Msg-id 26275.1051107418@sss.pgh.pa.us
Whole thread Raw
In response to Re: Regexps and Indices.  (Brian Piatkus <Brian@fulcrum.plus.com>)
Responses Re: Regexps and Indices.  (Brian Piatkus <Brian@fulcrum.plus.com>)
List pgsql-general
Brian Piatkus <Brian@fulcrum.plus.com> writes:
> It turns out to be more than possible. Locale is set by default to en_GB.
> Am I right in assuming that I need only to set LANG=C ? and should I also do
> this for the environment of the running postmaster ?

You need to re-do initdb with LANG=C in its environment.  Pain in the
neck, I know.

            regards, tom lane


pgsql-general by date:

Previous
From: Ken Williams
Date:
Subject: Re: Left Join Not Using Index?
Next
From: Tom Lane
Date:
Subject: Re: Can I Benefit from and Index Here?