David E. Wheeler wrote:
On Oct 13, 2008, at 11:13, Tom Lane wrote:
"David E. Wheeler" <[EMAIL PROTECTED]> writes:
Probably no problem, then. Do dates in PostgreSQL work for their
entire documented ranges on 32bit processors?
As long as the C compiler supports int64 ...
I was afraid you'd say that. See:
http://code.google.com/p/y2038/wiki/WhyBother
Especially the "64 bit CPU doesn't mean 2038 clean" section. Again,
maybe this doesn't apply to PostgreSQL; I'm just doing a bit of
diligence. :-)
Cheers,
David
PostgreSQL doesn't use the standard time_t and time functions for its
timestamp types. Therefore, any limitations in regards to 64-bit time_t
values on 32-bit platforms don't apply; other than the limitation Tom
spoke of ... no 64-bit int.
--
Andrew Chernow
eSilo, LLC
every bit counts
http://www.esilo.com/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers