Re: ILIKE and indexes

On 3/19/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Not if you have an index on lower(col) which one supposes you'd have
> anyway for such an application.  Or are you running an ancient PG
> release?

Yes, you're right. Looking at my history I can't find what my error
was - I analyzed the table several times to be sure. As I was playing
with the production db and a 8.2.3 db, perhaps I missed a command on
one of the db server.

Anyway, the estimates are accurate now.

Thanks for your help.

--
Guillaume