Re: Regex select ~ with ^ not using index on char field or text; Locale bug? - Mailing list pgsql-general

Greg Maxwell  <gmaxwell@martin.fl.us> writes:
> On performing queries such as select * from table where name ~ '^NAME.*';
> the database fails to use the available Btree index where available, even
> when the database is told not to use the SEQ_SCAN optimization.

> PGsql was initlized and is started with the scripts in the RPM, so
> LC_ALL=C is set.  PSQL is also run with LC_ALL=C.

Are you *certain* the DB was initialized in locale C?  Try running
contrib/pg_controldata to be sure.

            regards, tom lane