Howie wrote:
>
...[other stuff]...
>
> ircbot=> select now(),'now'::datetime,now()::datetime;
> now |?column?|datetime
> --++
> 1999-12-27 04:25:35-05|Mon Dec 27 04:25:35 1999 EST|Mo
On Sun, 26 Dec 1999, Mike Mascari wrote:
> Howie wrote:
>
> > will this function/index problem be fixed in 7.x ?
> >
> > ircbot=> explain select * from logins where dttime = NOW();
> [SNIP]
> emptoris=> explain select * from sales where saledate = 'now'::datetime;
> NOTICE: QUERY PLAN:
>
> Ind
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 Sca
