On 8/29/13, Andreas Kretschmer <akretsch...@spamfence.net> wrote: > is there a bug in age()? > > test=*# select *, age(birthday), age (current_date-1, birthday) from > birthday ; > id | birthday | age | age > ----+------------+---------+------------------------- > 1 | 2010-08-29 | 3 years | 2 years 11 mons 30 days > (1 row) > > Time: 0,322 ms > 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? > > > I'm using 9.2.4.
What is the content of the field 'birthday''? My guess is there's a null value for the field, in which case you are comparing two nulls. -- Mike Nolan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
