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])

Reply via email to