PostgreSQL Bugs - date overflows

Author

date overflows

Kris Jurka

2005-12-03, 8:24 pm

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)

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Michael Fuhr

2005-12-03, 8:24 pm

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/pgsq...11/msg01563.php

--
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Sponsored Links