The following bug has been logged online:
Bug reference: 1094
Logged by: xterm
Email address: xterm(at)linuxnews(dot)pl
PostgreSQL version: 7.3.4
Operating system: RH Fedora
Description: date_part('week') bug
Details:
Some late dates give in some years wrong
date_part('week')
examples:
select date_part('week', '2003-12-30'::date);
date_part
-----------
1
(1 row)
select date_part('week', '1997-12-29'::date);
date_part
-----------
1
(1 row)
but:
select date_part('week', '1998-12-31'::date);
date_part
-----------
53
(1 row)