Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 8150A476400
	for <pgsql-sql@postgresql.org>; Thu,  2 Jan 2003 01:16:29 -0500 (EST)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by postgresql.org (Postfix) with ESMTP id 88EA8476391
	for <pgsql-sql@postgresql.org>; Thu,  2 Jan 2003 01:16:28 -0500 (EST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h026GNd0017936;
	Thu, 2 Jan 2003 01:16:23 -0500 (EST)
To: Minghann Ho <mho@mcs.vuw.ac.nz>
Cc: pgsql-sql@postgresql.org
Subject: Re: bug? 
In-reply-to: <200301021736.23383.mho@mcs.vuw.ac.nz> 
References: <200301021736.23383.mho@mcs.vuw.ac.nz>
Comments: In-reply-to Minghann Ho <mho@mcs.vuw.ac.nz>
	message dated "Thu, 02 Jan 2003 17:36:23 +1300"
Date: Thu, 02 Jan 2003 01:16:23 -0500
Message-ID: <17935.1041488183@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/14
X-Sequence-Number: 10879

Minghann Ho <mho@mcs.vuw.ac.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