maxk(at)yelp(dot)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