Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TfNal-0003mA-Om for pgsql-bugs@arkaria.postgresql.org; Mon, 03 Dec 2012 04:25:15 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TfNak-0000EN-75 for pgsql-bugs@arkaria.postgresql.org; Mon, 03 Dec 2012 04:25:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TfEHB-0008IH-Et for pgsql-bugs@postgresql.org; Sun, 02 Dec 2012 18:28:25 +0000 Received: from mahout.postgresql.org ([98.129.198.123]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TfEH8-0005JV-Pt for pgsql-bugs@postgresql.org; Sun, 02 Dec 2012 18:28:25 +0000 Received: from [204.145.124.246] (helo=wrigleys.postgresql.org) by mahout.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TfEH6-0004ZY-T8 for pgsql-bugs@postgresql.org; Sun, 02 Dec 2012 18:28:21 +0000 Received: from www-data by wrigleys.postgresql.org with local (Exim 4.72) (envelope-from ) id 1TfEH5-0004JE-Qt for pgsql-bugs@postgresql.org; Sun, 02 Dec 2012 18:28:19 +0000 Date: Sun, 02 Dec 2012 18:28:19 +0000 Message-Id: Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Subject: BUG #7722: extract(epoch from age(...)) appears to be broken To: pgsql-bugs@postgresql.org From: aanisimov@inbox.ru X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-bugs Precedence: bulk Sender: pgsql-bugs-owner@postgresql.org 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:=20=20=20=20=20=20=20=20 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. --=20 Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs