On 3/19/07, Tom Lane <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
