Re: index scan with functional indexes - Mailing list pgsql-hackers

From Dave Cramer
Subject Re: index scan with functional indexes
Date
Msg-id 1075228737.1611.303.camel@localhost.localdomain
Whole thread Raw
In response to Re: index scan with functional indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: index scan with functional indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: index scan with functional indexes
Next
From: Tom Lane
Date:
Subject: Re: Extending SET SESSION AUTHORIZATION