Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Right. We allow leap seconds for any date/time. Are you saying we
> should only allow them for certain dates/times?
No, his point is the funny roundoff behavior.
regression=# select timestamp '2005-09-23 23:59:59.999999';
timestamp
----------------------------
2005-09-23 23:59:59.999999
(1 row)
regression=# select timestamp '2005-09-23 23:59:59.9999999';
timestamp
------------------------
2005-09-23 23:59:60.00
(1 row)
regression=# select timestamp '2005-09-23 23:59:59.99999999';
timestamp
---------------------
2005-09-24 00:00:00
(1 row)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
