Horton

Re: index scan with functional indexes

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: pg@fastcrypt.com
Cc: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2004-01-27T18:28:05Z
Lists: pgsql-hackers 
Dave Cramer <pg@fastcrypt.com> writes:
> Tried, all the suggestions

Mph.  It works for me... what PG version are you using exactly,
and are you certain you've selected C locale?  (Do you get LIKE
optimization on plain indexes?)

			regards, tom lane