The following SELECT are errors?! tpcr=# select extract (week from date '2000-01-01'); date_part ----------- 52 (1 row)
tpcr=# select extract (week from date '2000-01-02'); date_part ----------- 52 (1 row) Please check ... thanks Hans ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html