Re: BUG #3431: age() gets the days wrong - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3431: age() gets the days wrong
Date
Msg-id 6662.1183742833@sss.pgh.pa.us
Whole thread Raw
In response to BUG #3431: age() gets the days wrong  ("Pelle Johansson" <pelle@morth.org>)
List pgsql-bugs
"Pelle Johansson" <pelle@morth.org> writes:
> The age() function seem to work by first counting months until less than a
> month remains to to the second argument, then counting days left. This
> doesn't give the correct result, as shown by this example:

age() isn't intended to give the same result as minus, so I'm not
convinced that this behavior is wrong.  I'm more worried about what
applications we might break by changing it --- age() has always worked
the way it does now.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: BUG #3427: Autovacuum crashed server
Next
From: Rainer Bauer
Date:
Subject: Re: BUG #3427: Autovacuum crashed server