Postgres Pro
Downloads
Home   >   mailing lists

Re: question about age() - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: question about age()
Date
Msg-id 20130829193025.GM3531@hermes.hilbert.loc
Whole thread Raw
In response to question about age()  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-general
Tree view 
On Thu, Aug 29, 2013 at 09:11:07PM +0200, Andreas Kretschmer wrote:

> test=*# select * from birthday where age(birthday) != age (current_date-1, birthday);
>  id | birthday
> ----+----------
> (0 rows)
>
> '3 years' != '2 years 11 mons 30 days', but i got 0 rows, why?

What does

    select age(birthday) = age (current_date-1, birthday) from birthday;

say ?
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: question about age()
Next
From: Rob Sargent
Date:
Subject: Re: question about age()