Re: age() function documentation

Поиск
Список
Период
Сортировка
От Alessio Bragadini
Тема Re: age() function documentation
Дата
Msg-id 3AD55B60.D158F0A6@albourne.com
обсуждение исходный текст
Ответ на Re: age() function documentation  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
Список pgsql-hackers
Thomas Lockhart wrote:

> The age() functions *preserve* the qualitative fields year and month. So
> you see the difference in results:

Why take away age()? I usually use it to check against INTERVALs? See:

village=> select age(date '1999-05-17', date '1957-06-13') > '40
years'::interval;?column?
----------t
(1 row)
village=> select date '1999-05-17' - date '1957-06-13' > '40
years'::interval;?column?
----------f
(1 row)

It's useful and I would like to have it this way.

-- 
Alessio F. Bragadini        alessio@albourne.com
APL Financial Services        http://village.albourne.com
Nicosia, Cyprus             phone: +357-2-755750

"It is more complicated than you think"    -- The Eighth Networking Truth from RFC 1925


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

Предыдущее
От: Zeugswetter Andreas SB
Дата:
Сообщение: AW: AW: AW: Truncation of char, varchar types
Следующее
От: Thomas Lockhart
Дата:
Сообщение: Re: AW: AW: AW: Truncation of char, varchar types