| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Pelle Johansson" <pelle(at)morth(dot)org> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #3431: age() gets the days wrong |
| Date: | 2007-07-06 17:27:13 |
| Message-ID: | 6662.1183742833@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers pgsql-patches |
"Pelle Johansson" <pelle(at)morth(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rainer Bauer | 2007-07-06 19:55:10 | Re: BUG #3427: Autovacuum crashed server |
| Previous Message | Magnus Hagander | 2007-07-06 16:45:54 | Re: BUG #3427: Autovacuum crashed server |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2007-07-06 17:32:27 | Re: usleep feature for pgbench |
| Previous Message | Michael Glaesemann | 2007-07-06 17:24:58 | Re: script binaries renaming |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2007-07-06 19:04:27 | Re: Still recommending daily vacuum... |
| Previous Message | Michael Glaesemann | 2007-07-06 17:24:58 | Re: script binaries renaming |