Re: BUG #6391: insert does not insert correct value

"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
> John Udick <John(dot)Udick(at)zionsbancorp(dot)com> wrote:
>> "PostgreSQL 8.2.15 (Greenplum Database 4.1.1.5 build 1) on
>> x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled
>> on Sep 20 2011 11:09:08"

> Yeah, I don't know how much the community lists can help with that
> implementation. It seems there is a bug in that version, but it
> might not be present in the community version.

The provided example works for me on PG 8.2.23:

regression=# select * from t order by 1;
id | d1 | d2
----+------------+------------
1 | 2012-01-11 | 2012-01-11
2 | 2012-01-11 | 2012-01-11
3 | 2012-01-11 | 2012-01-11
(3 rows)

and it does not remind me of any known/fixed bug in community 8.2.x.
So I'd have to say this is a Greenplum bug.

regards, tom lane