"Tashuhito Kasahara" <[EMAIL PROTECTED]> writes:
> test=# EXPLAIN SELECT * FROM test WHERE t < '2008-05-14
> 23:55:00'::text::timestamp;
> QUERY PLAN
> ----------------------------------------------------------------------------
> Seq Scan on test (cost=0.00..2209.00 rows=32133 width=12) <- too little
> number of the estimates
> Filter: (t < ('2008-05-14 23:55:00'::text)::timestamp without time zone)
> (2 rows)
Hmm ... as of 8.3 this will generate a CoerceViaIO node, and it looks
like I forgot to teach eval_const_expressions how to simplify those.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
