| From: | Michael Glaesemann <grzm(at)seespotcode(dot)net> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Paesold <mpaesold(at)gmx(dot)at>, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] Interval aggregate regression failure (expected seems |
| Date: | 2006-09-03 22:52:29 |
| Message-ID: | 975A1879-9969-48F9-A2AC-8F90C7EE9C8C@seespotcode.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
On Sep 4, 2006, at 4:45 , Bruce Momjian wrote:
> Another question. Is this result correct?
>
> test=> select '999 months 999 days'::interval / 100;
> ?column?
> -------------------------
> 9 mons 38 days 40:33:36
> (1 row)
>
> Should that be:
>
> 9 mons 39 days 16:33:36
Yeah, I think it should be. I had been thinking of treating the month
and day component as having separate time contributions, but it makes
more sense to think of month as a collection of days first, integral
or no, and then cascade down the fractional portion of the combined
days component to time. I.e., 9.99 mon is 9 mon 29.7 days, rather
than 9 mon 29 days 60480 sec.
Michael Glaesemann
grzm seespotcode net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-09-03 23:00:29 | Re: pgstattuple extension for indexes |
| Previous Message | Gregory Stark | 2006-09-03 21:09:44 | Re: Concurrent connections in psql patch |