select
age(
'2009-06-23 18:36:05.064066+02' ,
'2009-05-12 18:36:05.064066+02') ;
Result: "1 mon 11 days"
select justify_interval('1000 hours');
Result: "1 mon 11 days 16:00:00"
select
age(
'2009-06-23 18:36:05.064066+02' ,
'2009-05-12 18:36:05.064066+02')
> interval '1000 hours'
;
Result: false
And that's correct, 1 month and 11 days is less than 1 month, 11 days
and 16 hours, it's not more. This is the actual comparison:
select interval '1 mon 11 day' > interval '1 mon 11 day 16 hour';
I don't see a problem nor a bug.
Regards,
Frank
Op 25 jun 2009, om 11:28 heeft pamel...@companeo.com het volgende
geschreven:
The following bug has been logged online:
Bug reference: 4878
Logged by:
Email address: pamel...@companeo.com
PostgreSQL version: 8.2.4, 8.3.6
Operating system: linux
Description: function age() give a wrong interval
Details:
age() report a wrong interval in some case
example
intervall between the 2 dates is 1008 hours
select age('2009-06-23 18:36:05.064066+02' ,'"2009-05-12
18:36:05.064066
+02"') > interval '1000 hours';
result is false instead of true.
There is a 24 hours error in the age() results
regards
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
