Re: index scan with functional indexes

Dave Cramer <pg@fastcrypt.com>

From: Dave Cramer <pg@fastcrypt.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2004-01-27T18:38:57Z
Lists: pgsql-hackers
I'm using 7.4.1, the db was initdb --locale='C'

and no I don't get them on plain indexes ????

Dave
On Tue, 2004-01-27 at 13:28, Tom Lane wrote:
> 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
> 
-- 
Dave Cramer
519 939 0336
ICQ # 1467551