On Fri, Mar 09, 2007 at 16:44:57 -0300,
Jorge Godoy <jgodoy@gmail.com> wrote:
> Bruno Wolff III <bruno@wolff.to> writes:
>
> > On Fri, Mar 09, 2007 at 14:59:35 -0300,
> > Jorge Godoy <jgodoy@gmail.com> wrote:
> >> It is not hard to calculate, as you can see... but it would be nice if
> >> "date_trunc('week', date)" could do that directly. Even if it became
> >> "date_trunc('week', date, 4)" or "date_trunc('week', date, 'Wednesday')" it
> >> would be nice... :-) And that is what I was trying to ask ;-)
> >
> > Use date_trunc('week', current_day + 1) and date_trunc('dow', current_day + 1)
> > to have a one day offset from the standard first day of the week.
>
>
> I believe there's more than that... Probably the "+1" should be outside the
> date_trunc, anyway. It might help, but I still see the need to to do
> calculations... Specially if it was Tuesday today...
No, it has to be inside the function so that the modular arithmetic is
applied to it.