Postgres Pro
Downloads
Home   >   mailing lists

BUG #6028: age() function output contracts "months", but not any other units. - Mailing list pgsql-bugs

From Martin A. Brooks
Subject BUG #6028: age() function output contracts "months", but not any other units.
Date
Msg-id 201105171435.p4HEZxNa071526@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #6028: age() function output contracts "months", but not any other units.
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      6028
Logged by:          Martin A. Brooks
Email address:      martin@antibodyMX.net
PostgreSQL version: 9.0.4
Operating system:   Debian/GNU Linux 6
Description:        age() function output contracts "months", but not any
other units.
Details:

Hi

postgres=# select age(now(),'1973-12-20'::timestamp);
                   age
-----------------------------------------
 37 years 4 mons 28 days 15:33:49.041831
(1 row)


Note "mons" and not "months".  And if "mons", why not "yrs" and "dys"?

Regards

Martin A. Brooks
http://antibodyMX.net/

pgsql-bugs by date:

Previous
From: Alex Hunsaker
Date:
Subject: Re: Plperl trigger variables no longer global
Next
From: "dhaval"
Date:
Subject: BUG #6027: OLE DB Provider not available