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