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 [EMAIL PROTECTED]
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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
