Richard Huxton <[EMAIL PROTECTED]> writes:
> That's because a quoted literal isn't necessarily a timestamp. Without
> context it could be anything, and in the context of comparing to a date
> the planner probably tries to make it a date.
I think the real point here is this:
regression=# select '2008-12-09 02:00:00'::date;
date
------------
2008-12-09
(1 row)
ie, when it does decide that a literal should be a date, it will happily
throw away any additional time-of-day fields that might be in there.
Had it raised an error, Stefano might have figured out his mistake
sooner.
ISTM we deliberately chose this behavior awhile back, but I wonder
whether it does more harm than good.
regards, tom lane
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
