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