BTW:
Windows 2003 Server.
LOLL2=# SELECT version();
version
--------------------------------------------------------------------------------
PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
3.4.2 (mingw-special)
(1 row)
Regards :)
Daniel Schuchardt schrieb:
LOLL2=# SELECT to_char('2007-12-31'::DATE, 'YYYYIW');
to_char
---------
200701
(1 row)
2007-12-31 should be week 2008-01
regards,
Daniel.
---------------------------(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
