(Why don't replies automatically go to the list?)
Sure enough, quoting the constants fixes the problem.
Is it a best practice to always quote constants?
> -Original Message-
> From: Doug Y [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 19, 2004 11:28 AM
> To: K
The following is from a database of several hundred million
rows of real data that has been VACUUM ANALYZEd.
Why isn't the index being used for a query that seems
tailor-made for it? The results (6,300 rows) take about ten minutes to retrieve
with a sequential scan.
A copy of this d
