On 2009-06-24, Philippe Amelant <pamel...@companeo.com> wrote:
> Ok but if I work with hours or whatever the problem is still there
>
> 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"'))/3600,
> EXTRACT(EPOCH FROM interval '1008 hours')/3600, age('2009-06-23
> 18:36:05.064066+02' ,'"2009-05-12 18:36:05.064066+02"') > interval '1007
> hours';
>
> The third test should be true and not false 

The third test is comparing a double with an interval.
compare like with like.

 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"'))/3600,
 EXTRACT(EPOCH FROM interval '1008 hours')/3600, age('2009-06-23
 18:36:05.064066+02' ,'"2009-05-12 18:36:05.064066+02"')
 > EXTRACT(EPOCH FROM interval '1007 hours');



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to