Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group