Re: BUG #1563: wrong week returnded by date_trunc('week',

From: Robert Creager <Robert_Creager(at)LogicalChaos(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PGBugs <pgsql-bugs(at)postgresql(dot)org>, PGBugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #1563: wrong week returnded by date_trunc('week',
Date: 2005-03-29 04:15:43
Message-ID: 20050328211543.408519ec@thunder.logicalchaos.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-patches

When grilled further on (Sun, 27 Mar 2005 02:26:02 -0500),
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> confessed:

>
> We need to change the function APIs so that date2isoweek passes back
> some indication of which year it thought the week belongs to, and then
> isoweek2date must use that instead of the original year number.
>
> Each of these functions is used in several places, so the change is not
> quite trivial, but still not a big deal. Who wants to fix it?
>

I'll take a look at it next weekend (4/2 or 4/3) if it's still not done.

Cheers,
Rob

--
20:43:32 up 14:07, 9 users, load average: 3.15, 2.76, 2.00
Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Dirk Raetzel 2005-03-29 05:43:53 Re: [BUGS] BUG #1563: wrong week returnded by date_trunc('week',
Previous Message Tom Lane 2005-03-29 03:18:41 Re: Background writer process terminating

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2005-03-29 04:18:05 Re: [WIP] shared row locks
Previous Message Alvaro Herrera 2005-03-29 04:06:43 [WIP] shared row locks