| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Creager <Robert_Creager(at)LogicalChaos(dot)org>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: inverse of "day of year" |
| Date: | 2004-03-22 15:18:10 |
| Message-ID: | 20040322151810.GB2962@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Mon, Mar 22, 2004 at 10:14:40 -0300,
Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> wrote:
>
> Any thoughts on how this could affect date manipulation?
This is consistant with what I explained about the behavior when adding
a month results in a day in a month past the end of the new month.
What do you expect to have happen here?
> mydb=> select '29/2/2004'::date + ((2005 - date_part('year', now())::int) ||
> 'years')::interval;
> ?column?
> ---------------------
> 2005-02-28 00:00:00
>
> AFAIKS with other dates this works OK. :-)
The real issue with intervals is that how they work in unusual cases is
not documented. The behavior could change in a future version without
much fanfare.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dana Hudes | 2004-03-22 15:56:36 | Re: inverse of "day of year" |
| Previous Message | Bruno Wolff III | 2004-03-22 15:12:11 | Re: special integrity constraints |