BUG #7722: extract(epoch from age(...)) appears to be broken - Mailing list pgsql-bugs

From aanisimov@inbox.ru
Subject BUG #7722: extract(epoch from age(...)) appears to be broken
Date
Msg-id E1TfEH5-0004JE-Qt@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #7722: extract(epoch from age(...)) appears to be broken
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      7722
Logged by:          Artem Anisimov
Email address:      aanisimov@inbox.ru
PostgreSQL version: 9.2.1
Operating system:   Slackware Linux 14.0/amd64
Description:        =


The following to queries give the same result (first arguments to age()
differ in the day number only, second arguments are identical):

select extract(epoch from age('2012-11-23 16:41:31', '2012-10-23
15:56:10'));

and

select extract(epoch from age('2012-11-22 16:41:31', '2012-10-23
15:56:10'));

The problem can also be reproduced in pgsql 9.1.4 of Fedora 17.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: PITR potentially broken in 9.2
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #7722: extract(epoch from age(...)) appears to be broken