Postgres Pro
Downloads
Home   >   mailing lists

bug? - Mailing list pgsql-sql

From Minghann Ho
Subject bug?
Date
Msg-id 200301021736.23383.mho@mcs.vuw.ac.nz
Whole thread Raw
Responses Re: bug?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Andrew J. Kelly"
Date:
Subject: Re: Slow self-join on a 100 million record table
Next
From: Tom Lane
Date:
Subject: Re: empty arrays