Re: Maybe a Bug, maybe bad SQL

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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026