On Thu, Sep 22, 2005 at 12:20:58PM +0200, A. Kretschmer wrote:
> am 22.09.2005, um 12:40:00 +0300 mailte pgsql-general@xxxxxxxxxxxxxxxx folgendes:
> > select date_trunc('week', '2005-01-01'::TIMESTAMP) returns '2006-01-02
> > 00:00:00'
>
> Which version?
This bug was fixed in 8.0.2:
http://archives.postgresql.org/pgsql-committers/2005-04/msg00008.php
A similar bug is fixed in CVS, so it'll be in 8.0.4:
http://archives.postgresql.org/pgsql-committers/2005-07/msg00144.php
--
Michael Fuhr
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
