"Nicholas Vinen" <[EMAIL PROTECTED]> writes: > This is definitely not right:
> rt3=# SELECT date_trunc('week', timestamp with time zone '2005-01-02
> 00:00:00-7');
> date_trunc
> ------------------------
> 2006-01-02 00:00:00-08
> (1 row)
Already fixed in 8.0.2.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
