BUG #1699: Invalid timestamps with timezone and interger timestamps - Mailing list pgsql-bugs

From Guillaume Beaudoin
Subject BUG #1699: Invalid timestamps with timezone and interger timestamps
Date
Msg-id 20050603114124.56CCAF0AC8@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #1699: Invalid timestamps with timezone and interger timestamps
List pgsql-bugs
The following bug has been logged online:

Bug reference:      1699
Logged by:          Guillaume Beaudoin
Email address:      guillaume.beaudoin@bdeb.qc.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,

pgsql-bugs by date:

Previous
From: "Michael"
Date:
Subject: BUG #1700: Error on Subselect with date in where condition
Next
From: Bahadur Singh
Date:
Subject: Re: BUG #1697: Select getting slower on continously updating data