Maybe a Bug, maybe bad SQL - Mailing list pgsql-sql

From Daryl Herzmann
Subject Maybe a Bug, maybe bad SQL
Date
Msg-id Pine.LNX.4.21.0103191341560.13102-100000@iitappc1.iitap.iastate.edu
Whole thread Raw
Responses Re: Maybe a Bug, maybe bad SQL
Re: Maybe a Bug, maybe bad SQL
List pgsql-sql
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 |   12000-04-01 |   12000-04-03 |   3
(3 rows)

Is this fixed in a newer version?  Am I doing something wrong?


TIA,Daryl Herzmann



pgsql-sql by date:

Previous
From: "Jae Hwang"
Date:
Subject: pltcl - returning row(s)
Next
From: Bruce Momjian
Date:
Subject: Re: Maybe a Bug, maybe bad SQL