Received: from candle.pha.pa.us (candle.navpoint.com [162.33.245.46] (may be forged)) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2L4geH79808 for ; Tue, 20 Mar 2001 23:42:40 -0500 (EST) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id XAA20638; Tue, 20 Mar 2001 23:40:31 -0500 (EST) From: Bruce Momjian Message-Id: <200103210440.XAA20638@candle.pha.pa.us> Subject: Re: Maybe a Bug, maybe bad SQL In-Reply-To: "from Daryl Herzmann at Mar 19, 2001 01:46:10 pm" To: Daryl Herzmann Date: Tue, 20 Mar 2001 23:40:31 -0500 (EST) CC: pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL77 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200103/405 X-Sequence-Number: 2073 With 7.1beta, I get: day | day ------------+----- 2000-04-02 | 2 2000-04-01 | 1 2000-04-03 | 3 (3 rows) > HI, > I am running postgres version 7.0 and I do this... > > akrherz=# create table test (day date); > CREATE > akrherz=# insert into test values('2000_04_02'); > INSERT 13166281 1 > akrherz=# insert into test values('2000_04_01'); > INSERT 13166282 1 > akrherz=# insert into test values('2000_04_03'); > INSERT 13166283 1 > akrherz=# select day, date_part('day', day) AS day from test; > day | day > ------------+----- > 2000-04-02 | 1 > 2000-04-01 | 1 > 2000-04-03 | 3 > (3 rows) > > > Is this fixed in a newer version? Am I doing something wrong? > > > TIA, > Daryl Herzmann > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026