Re: BUG #13845: Incorrect week number

If I read and understand the documentation correctly, WW starts on the
first day of the year, therefore January 1 - 7 is week 01.

The following query seems to confirm this on 9.4, I'm looking for the week
number for day 7 of the year:

# # select to_char(day, 'YYYYWW') as week, to_char(day, 'IYYYIW') as
isoweek from generate_series('2008-01-07','2020-01-07', interval '1 year')
as series(day);
  week  | isoweek
--------+---------
 200801 | 200802
 200901 | 200902
 201001 | 201001
 201101 | 201101
 201201 | 201201
 201301 | 201302
 201401 | 201402
 201501 | 201502
 201601 | 201601
 201701 | 201701
 201801 | 201801
 201901 | 201902
 202001 | 202002
(13 rows)

According to wikipedia, the US weeks starts on a Sunday, it would already
have resulted in differences when using the WW format for weeks in the
past, as WW starts on day 1, whether it is Sunday or Wednesday.

regards,

Feike