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 <[EMAIL PROTECTED]>   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."


************

Reply via email to