Re: age() vs. timestamp substraction

Поиск
Список
Период
Сортировка
От Martin Marques
Тема Re: age() vs. timestamp substraction
Дата
Msg-id c82791b724c34d828f27af409356eef7@bugs.unl.edu.ar
обсуждение исходный текст
Ответ на Re: age() vs. timestamp substraction  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
On Thu, 05 Oct 2006 14:37:24 -0400, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Martin Marques <martin@bugs.unl.edu.ar> writes:
>> I just found this problem with the age() function, which AFAIK should
>> give the same resulte as a subtraction of the argument from now(),
> 
> Where did you get that idea?  age's reference point is current_date (ie,
> midnight) not now().  There are also some differences in the calculation
> compared to a plain timestamp subtraction.

Ignore anything I said. Just realized it said current_date. :-(

Sorry.

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




В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: age() vs. timestamp substraction
Следующее
От: "Ezequias Rodrigues da Rocha"
Дата:
Сообщение: On Rollback my sequency does not back the initial value