BUG #1094: date_part('week') bug - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      1094
Logged by:          xterm

Email address:      xterm@linuxnews.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)