Dear Mr. Herrera and Mr. Momjian, thank you for your feedback and for explaining that age() better not be used.
On Monday 03 December 2012 03:05:57 Alvaro Herrera wrote: > The problem is that age() returns 30 days in one case, and "one month" in > the other; extract() then considers the month as equivalent to 30 days. > This is documented as such, see [1]. On Monday 03 December 2012 21:17:00 Bruce Momjian wrote: > Wow, that is a weird case. In the first test, we count the number of > days because it is less than a full month. In the second case, we call > it a full month, but then forget how long it is. Not sure how we could > improve this. Best regargs, Artem Anisimov. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
