dbTalk Databases Forums  

[BUGS] date overflows

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] date overflows in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Kris Jurka
 
Posts: n/a

Default [BUGS] date overflows - 12-03-2005 , 06:50 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

Reply With Quote
  #2  
Old   
Michael Fuhr
 
Posts: n/a

Default Re: [BUGS] date overflows - 12-03-2005 , 07:06 PM






On Sat, Dec 03, 2005 at 07:53:23PM -0500, Kris Jurka wrote:
Quote:
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...1/msg01563.php

--
Michael Fuhr

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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.