Re: age() function documentation

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

In response to

Browse pgsql-hackers by date

  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