| From: | Артем Анисимов <aanisimov(at)inbox(dot)ru> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #7722: extract(epoch from age(...)) appears to be broken |
| Date: | 2012-12-04 05:16:14 |
| Message-ID: | 2042272.iJfXXT9BJj@vault13 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-docs |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Duggirala, Manikanth (TCS) | 2012-12-04 09:38:11 | PostgreSQL v8.1.11 compatibility with OS 2008 R2 |
| Previous Message | Bruce Momjian | 2012-12-04 02:17:00 | Re: BUG #7722: extract(epoch from age(...)) appears to be broken |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francisco Olarte (M) | 2012-12-04 19:18:31 | Re: BUG #7722: extract(epoch from age(...)) appears to be broken |
| Previous Message | Bruce Momjian | 2012-12-04 02:17:00 | Re: BUG #7722: extract(epoch from age(...)) appears to be broken |