The following bug has been logged online:

Bug reference: 1650
Logged by: Nicholas Vinen
Email address: hb (AT) pg (DOT) x256.org
PostgreSQL version: 8.0.2
Operating system: Gentoo Linux
Description: Upgraded postgres, problem went away
Details:

8.0.2 is not marked as "stable" in gentoo but after I had the previous date
problem I installed it anyway. Now it does this:

rt3=# SELECT date_trunc('week', timestamp with time zone '2005-01-02
00:00:00-7');
date_trunc
------------------------
2004-12-27 00:00:00-08
(1 row)


That seems more correct. Thank you for fixing. You may close my previous bug
report(s).

Thank you Whoever fixed that saved me having to do it myself.

Nicholas

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)