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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
