Postgres Pro
Downloads
Home   >   mailing lists

Re: DISTINCT MAX() results mismatch on 8.2 and 8.3 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: DISTINCT MAX() results mismatch on 8.2 and 8.3
Date
Msg-id 1381.1206592718@sss.pgh.pa.us
Whole thread Raw
In response to DISTINCT MAX() results mismatch on 8.2 and 8.3  (Taiki Yamaguchi <yamaguchi@sraoss.co.jp>)
List pgsql-bugs
Tree view 
Taiki Yamaguchi <yamaguchi@sraoss.co.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

pgsql-bugs by date:

Previous
From: "Nahum Castro"
Date:
Subject: BUG #4065: Error on psql windows client
Next
From: "javier redolfi"
Date:
Subject: BUG #4066: error