The following bug has been logged online:
Bug reference: 1699
Logged by: Guillaume Beaudoin
Email address: guillaume(dot)beaudoin(at)bdeb(dot)qc(dot)ca
PostgreSQL version: 7.4.8
Operating system: Debian GNU/Linux
Description: Invalid timestamps with timezone and interger timestamps
Details:
SET TIME ZONE INTERVAL '-05:00' HOUR TO MINUTE;
SELECT NOW();
will report something like:
now
--------------------------------------
1979-06-06 09:42:49.854158-227814:06
(1 row)
Please check http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=311533 for
more informations about this.
Regards,