date overflows
I'm seeing some date input overflows here. I tested on CVS HEAD
without --enable-integer-datetimes and 7.4.9 and 8.0.4 with
--enable-integer-datetimes, so it appears to have been around for a
while:
jurka=# select '111123456-01-01'::date;
date
---------------
5290466-07-05
(1 row)
jurka=# select '14824-01-01 BC'::date;
date
----------------
11744398-01-21
(1 row)
On Sat, Dec 03, 2005 at 07:53:23PM -0500, Kris Jurka wrote:
I'm seeing some date input overflows here.
Yep, I noticed this a few days ago while looking at another problem.
I probably should have started a new thread.
http://archives.postgresql.org/pgsql-hackers/2005-11/msg01563.php
--
Michael Fuhr
On Sat, 3 Dec 2005, Michael Fuhr wrote:
On Sat, Dec 03, 2005 at 07:53:23PM -0500, Kris Jurka wrote:
I'm seeing some date input overflows here.
Yep, I noticed this a few days ago while looking at another problem.
I probably should have started a new thread.
This seems to fix it.
Kris Jurka