Chris wrote:
> Postgresql 8.0
>
> select date_trunc('week',TO_DATE('2005-01-01','yyyy-mm-dd'))
Upgrade to 8.0.4. This bug is fixed there.
alvherre=# select date_trunc('week',TO_DATE('2005-01-01','yyyy-mm-dd'));
date_trunc
------------------------
2004-12-27 00:00:00-03
(1 fila)
alvherre=# select version();
version
---------------------------------------------------------------------------------------------------------------
PostgreSQL 8.0.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.2
20050806 (prerelease) (Debian 4.0.1-4)
(1 fila)
alvherre=#
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
