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
<[EMAIL PROTECTED]> 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 [EMAIL PROTECTED])
>

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to