The following bug has been logged online: Bug reference: 1650 Logged by: Nicholas Vinen Email address: [EMAIL PROTECTED] 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 [EMAIL PROTECTED])