age() vs. timestamp substraction - Mailing list pgsql-sql

From Martin Marques
Subject age() vs. timestamp substraction
Date
Msg-id cbcf271add3140fe7cff8d45f31af585@bugs.unl.edu.ar
Whole thread Raw
Responses Re: age() vs. timestamp substraction  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
I just found this problem with the age() function, which AFAIK should give the same resulte as a subtraction of the
argumentfrom now(), but it doesn't.
 


prueba=> SELECT (now() - tc.last_cron),age(tc.last_cron),tc.intervalo FROM tareas_cron tc ;             ?column?
      |              age              | intervalo
 
-------------------------------------+-------------------------------+-----------@ 1 day 15 hours 13 mins 12.06 secs |
@23 hours 59 mins 58.47 secs | @ 1 day@ 15 hours 13 mins 12.06 secs       | @ 1.52 secs ago               | @ 30 mins@
15hours 13 mins 12.08 secs       | @ 1.50 secs ago               | @ 10 mins
 

prueba=> SELECT version();                                       version
----------------------------------------------------------------------------------------PostgreSQL 8.1.3 on
i486-pc-linux-gnu,compiled by GCC cc (GCC) 4.0.3 (Debian 4.0.3-1)
 

Any ideas on why?

I starting to change my queries so they don't have the age() function anymore.

--
---------------------------------------------------------
Lic. Martín Marqués         |   SELECT 'mmarques' || 
Centro de Telemática        |       '@' || 'unl.edu.ar';
Universidad Nacional        |   DBA, Programador,    del Litoral             |   Administrador
---------------------------------------------------------




pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: timestamp subtraction (was Re: formatting intervals with to_char)
Next
From: Andrew Sullivan
Date:
Subject: Re: Assigning a timestamp without timezone to a timestamp