"Tashuhito Kasahara" <kasahara(dot)tatsuhito(at)oss(dot)ntt(dot)co(dot)jp> 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