Re: Index not used with or condition - Mailing list pgsql-performance

Sorry I forgot to mention it. I am using 7.3.3.  I will try it in 8.0.0

rgds
Antony Paul



On Mon, 7 Feb 2005 12:46:05 +0100, Steinar H. Gunderson
<sgunderson@bigfoot.com> wrote:
> On Mon, Feb 07, 2005 at 04:44:07PM +0530, Antony Paul wrote:
> > On more investigation I found that index scan is not used if the query
> > have a function in it like lower() and an index exist for lower()
> > column.
>
> What version are you using? 8.0 had fixes for this situation.
>
> /* Steinar */
> --
> Homepage: http://www.sesse.net/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>