"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> John Udick <John.Udick@zionsbancorp.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