Re: age() function documentation - Mailing list pgsql-hackers

From Alessio Bragadini
Subject Re: age() function documentation
Date
Msg-id 3AD55B60.D158F0A6@albourne.com
Whole thread Raw
In response to Re: age() function documentation  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
List 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 by date:

Previous
From: Zeugswetter Andreas SB
Date:
Subject: AW: AW: AW: Truncation of char, varchar types
Next
From: Thomas Lockhart
Date:
Subject: Re: AW: AW: AW: Truncation of char, varchar types