| From: | aanisimov(at)inbox(dot)ru |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #7722: extract(epoch from age(...)) appears to be broken |
| Date: | 2012-12-02 18:28:19 |
| Message-ID: | E1TfEH5-0004JE-Qt@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-docs |
The following bug has been logged on the website:
Bug reference: 7722
Logged by: Artem Anisimov
Email address: aanisimov(at)inbox(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-12-02 21:02:49 | Re: PITR potentially broken in 9.2 |
| Previous Message | Tom Lane | 2012-12-02 17:44:11 | Re: BUG #7710: Xid epoch is not updated properly during checkpoint |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2012-12-03 06:05:57 | Re: BUG #7722: extract(epoch from age(...)) appears to be broken |
| Previous Message | Dagfinn Ilmari Mannsåker | 2012-11-28 13:03:51 | [PATCH] Fix return type documentation for path(polygon) function |