[HACKERS] Optimizer bug??

[Ismail Kizir]

ï Hi everybody, 1 .... EXPLAIN SELECT COUNT(*) AS c FROM articletbl WHERE       ((mydate BETWEEN '2004-04-24' AND '2004-05-24' ) ) 2 .... EXPLAIN SELECT COUNT(*) AS c FROM articletbl WHERE       ((mydate = '2004-04-24') ) (I ran VACUUM ANALYZE before running those) mydate is an indexed date column. The optimizer optimizes the second query but, it doesn't optimize the first one and decides to make a "sequential scan". Is this a bug? Or may someone explain me the reason? Thanks in advance. Ismail Kizir