From: | Alessio Bragadini <alessio(at)albourne(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: age() function documentation |
Date: | 2001-04-12 07:38:08 |
Message-ID: | 3AD55B60.D158F0A6@albourne.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)albourne(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Nathan Myers | 2001-04-12 07:53:56 | Re: Re: Hand written parsers |
Previous Message | Ian Lance Taylor | 2001-04-12 05:44:59 | Re: Re: Hand written parsers |