possible bug on age() function (8.2.4 , 8.3.6)

From: "Philippe Amelant" <pamelant(at)companeo(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: possible bug on age() function (8.2.4 , 8.3.6)
Date: 2009-06-23 16:49:22
Message-ID: 1245775762.6161.26.camel@philippe-desktop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

here is a little test case for a problem we run into in our
developpement

Is it a bug or a setting problem ?

try
select (current_timestamp),(current_timestamp - interval '1008 hours');

report this value in age()

select age('2009-06-23 18:36:05.064066+02' ,'"2009-05-12 18:36:05.064066
+02"');

then use all in this :

SELECT EXTRACT(EPOCH FROM TIMESTAMP '2009-06-23 18:36:05.064066+02') -
EXTRACT(EPOCH FROM TIMESTAMP '"2009-05-12 18:36:05.064066+02"'),
EXTRACT(EPOCH FROM interval '1 mon 11 days');

Can I workaround this ?

Regards

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2009-06-23 17:31:59 Re: Replication
Previous Message Hartman, Matthew 2009-06-23 16:18:55 Re: Explaining functions.