Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 020064766C4 for ; Wed, 1 Jan 2003 23:36:26 -0500 (EST) Received: from kaukau.mcs.vuw.ac.nz (kaukau.mcs.vuw.ac.nz [130.195.5.20]) by postgresql.org (Postfix) with ESMTP id 2F97547666D for ; Wed, 1 Jan 2003 23:36:23 -0500 (EST) Received: from devon.mcs.vuw.ac.nz (devon.mcs.vuw.ac.nz [130.195.5.109]) by kaukau.mcs.vuw.ac.nz (8.12.6/8.12.6) with ESMTP id h024aQC6022812 (version=TLSv1/SSLv3 cipher=EDH-RSA-DES-CBC3-SHA bits=168 verify=NOT) for ; Thu, 2 Jan 2003 17:36:26 +1300 (NZDT) Received: from localhost (localhost [[UNIX: localhost]]) by devon.mcs.vuw.ac.nz (8.11.6/8.11.1) id h024aNO07205 for pgsql-sql@postgresql.org; Thu, 2 Jan 2003 17:36:23 +1300 (NZDT) Content-Type: text/plain; charset="us-ascii" From: Minghann Ho To: pgsql-sql@postgresql.org Subject: bug? Date: Thu, 2 Jan 2003 17:36:23 +1300 User-Agent: KMail/1.4.3 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200301021736.23383.mho@mcs.vuw.ac.nz> X-Scanned-By: MIMEDefang 2.24 (www . roaringpenguin . com / mimedefang) X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/11 X-Sequence-Number: 10876 The following SELECT are errors?! tpcr=# select extract (week from date '2000-01-01'); date_part ----------- 52 (1 row) tpcr=# select extract (week from date '2000-01-02'); date_part ----------- 52 (1 row) Please check ... thanks Hans