Re: timestamp_part() bug? - Mailing list pgsql-hackers

From domingo@dad-it.com (Domingo Alvarez Duarte)
Subject Re: timestamp_part() bug?
Date
Msg-id 70a76315.0203051322.4aa84369@posting.google.com
Whole thread Raw
In response to Re: timestamp_part() bug?  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers
There is a problem with epoch as well that was not in the 7.1.3


7.1.3# select extract(epoch from '00:00:34'::time), now();
7.1.3# 34  2002-03-05 22:13:16 +01

7.2# select extract(epoch from '00:00:34'::time), now();
7.2# 3634  2002-03-05 22:13:16 +01

7.2# select extract(epoch from '00:00:34'::time without time zone), now();
7.2# 3634  2002-03-05 22:13:16 +01

Is that a bug or I didn't understand the new date/time types ?


pgsql-hackers by date:

Previous
From: "Robert E. Bruccoleri"
Date:
Subject: Re: bad performance on irix
Next
From: Bruce Momjian
Date:
Subject: Re: Lightweight locking primitive