Skip site navigation (1) Skip section navigation (2)

date overflows

From: Kris Jurka <books(at)ejurka(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: date overflows
Date: 2005-12-04 00:53:23
Message-ID: Pine.BSO.4.61.0512031947460.21763@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-patches
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)


Responses

pgsql-bugs by date

Next:From: Michael FuhrDate: 2005-12-04 01:06:01
Subject: Re: date overflows
Previous:From: Dirk PirschelDate: 2005-12-03 21:24:35
Subject: Re: BUG #2092: No answer to bug reports 1975 and 2055

pgsql-patches by date

Next:From: Michael FuhrDate: 2005-12-04 01:06:01
Subject: Re: date overflows
Previous:From: Bruno Wolff IIIDate: 2005-12-03 21:30:00
Subject: Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group