Re: BUG #13848: 2016 Week Number Error - Mailing list pgsql-bugs

maxk@yelp.com writes:
> SELECT EXTRACT(Week FROM current_date) = 1 instead of 2 Week numbers are all
> off

Not a bug.  See the manual's definition of this field:

: The number of the ISO 8601 week-numbering week of the year. By
: definition, ISO weeks start on Mondays and the first week of a year
: contains January 4 of that year. In other words, the first Thursday of a
: year is in week 1 of that year.

            regards, tom lane