Re: BUG in date_part

[ Charset ISO-8859-1 unsupported, converting... ]
> Hello,
> I've discovered a bug in the date_part function. It returns 25 when
> doing select date_part('day','2000-03-26'::date);
> Anyway, this isn't happening if casting the date to timestamp
> select date_part('day','2000-03-26'::timestamp);

It is fixed in current sources:

test=> select date_part('day','2000-03-26'::date);
date_part
-----------
26
(1 row)

--
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