Small bug report ...

From: Siim Valgeväli <siim(dot)valgevali(at)ttu(dot)ee>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Small bug report ...
Date: 2001-10-06 07:48:08
Message-ID: 001801c14e3b$3dcfa560$462111ac@radiolinja.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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
siim(dot)valgevali(at)ttu(dot)ee

Browse pgsql-bugs by date

  From Date Subject
Next Message John Summerfield 2001-10-06 12:24:35 Problem building from CVS
Previous Message John Summerfield 2001-10-05 23:56:38 Re: Long options for psql in 7.1.3