will this function/index problem be fixed in 7.x ?
ircbot=> explain select * from logins where dttime = NOW();
NOTICE: QUERY PLAN:
Seq Scan on logins (cost=33530.89 rows=71043 width=52)
EXPLAIN
ircbot=> explain select * from logins where dttime = NOW()::datetime;
NOTICE: QUERY PLAN:
Seq Scan on logins (cost=33530.89 rows=71043 width=52)
EXPLAIN
ircbot=> select now();
now
----------------------
1999-12-27 00:23:17-05
(1 row)
ircbot=> explain select * from logins where dttime='1999-12-27
00:23:17-05'::datetime;
NOTICE: QUERY PLAN:
Index Scan using logins_dttime_idx on logins (cost=2.54 rows=11 width=52)
EXPLAIN
( logins actually has 755,728 rows right now )
---
Howie <caffeine@toodarkpark.org> URL: http://www.toodarkpark.org
"I've learned that you cannot make someone love you.
All you can do is stalk them and hope they panic and give in."
