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 19:26:43
Message-ID: 29352.1206646003@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:
> yamaguti=# select distinct max(j) from t1;
> ERROR: could not find pathkey item to sort

Fixed in HEAD and 8.3. Thanks for the report!

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Ronald Kuczek 2008-03-27 19:40:19 Re: BUG #4068: Failed to compile 8.3.1
Previous Message Zdenek Kotala 2008-03-27 19:26:32 Re: BUG #4068: Failed to compile 8.3.1