On Nov 5, 2004, at 5:14 PM, Michael Glaesemann wrote:
On Nov 5, 2004, at 4:16 PM, Antony Paul wrote:where today::date = '2004-11-05'; This is the only condition in the query. There is a btree index on the column today. Is there any way to optimise it.I'm sure others out there have better ideas, but you might want to try where current_date = date '2004-11-05'
Ach! just re-read that. today is one of your columns! Try where today::date = date '2004-11-05'
