Minghann Ho <mho(at)mcs(dot)vuw(dot)ac(dot)nz> writes:
> The following SELECT are errors?!
No, they're not. PG follows the ISO definition of week numbers:
Monday is the first day of the week, and the first week of a year
is the first one containing a Thursday.
regards, tom lane