When integer datetimes are in use, the legal range of the "date" type
actually exceeds that of the "timestamp" type. However, the cast from
date => timestamp fails to take this into account:

postgres=# select '01-01-5874896'::date::timestamp;
         timestamp          
----------------------------
 29355-07-05 15:41:44.48384
(1 row)

The cast works correctly with FP-based datetimes.

Should be simple to fix, but I won't have the free cycles to do it for a
little while, so if anyone wants to take a shot at it in the meanwhile,
they are more than welcome...

-Neil



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to