Hello!
I found a small mistake from age() function.
The query is for example: SELECT age('1980-05-08');
and expected output should be "21 years 4 months 29 days 01:00"
but PostgreSQL version
"PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc 2.96"
gave this result:
"21 years 4 mons 29 01:00"
It should be "21 years 4 MONTHS 29 DAYS 01:00"
-----
Some more examples:
INPUT: "select age('1982-06-15');" OUTPUT: "21 years 4 mons 29 01:00"
INPUT: "select age('2001-09-05');" OUTPUT: "1 mon 1 00:00" etc.
I am sorry, but I really don't know mabye on PostgreSQL version 7.0.3 it works properly.
But aniway, PostgreSQL is my favourite!!
---
best regards,
Siim Valgeväli
Estonia
