Re: DISTINCT MAX() results mismatch on 8.2 and 8.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Taiki Yamaguchi <yamaguchi(at)sraoss(dot)co(dot)jp>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: DISTINCT MAX() results mismatch on 8.2 and 8.3
Date: 2008-03-27 04:38:38
Message-ID: 1381.1206592718@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Taiki Yamaguchi <yamaguchi(at)sraoss(dot)co(dot)jp> writes:
> If a column has a primary-key constraint, DISTINCT MAX() fails on 8.3.

> I know that the DISTINCT in this query has no meanings, but I wasn't
> certain that this was an intended behaviour or not (a bug). If it was a
> bug, would it be fixed in the future?

It's certainly a bug and should be fixed ... I'm too tired to look into
the cause right now, though.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message javier redolfi 2008-03-27 05:09:27 BUG #4066: error
Previous Message Nahum Castro 2008-03-27 03:08:43 BUG #4065: Error on psql windows client