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

"Kevin Grittner" <Kevin.Grittner@[EMAIL PROTECTED]
> writes:
>> yamaguti=# select distinct max(j) from t1;
>> ERROR:  could not find pathkey item to sort
 
> For the benefit of anyone searching the archives for the problem we
> just hit, this message also occurs in 8.3.1 and also occurs against
> the above test table for this statement:
 
> test=# select max(j) as "maxj" from t1 order by "maxj";
> ERROR:  could not find pathkey item to sort
 
> Neither statement causes the error when run against a build from
> REL8_3_STABLE from 35 minutes ago (2008-04-22 10:15 CDT).

Yeah, this was repaired here:
http://archives.postgresql.org/pgsql-committers/2008-03/msg00563.php

The fix will be in 8.3.2.

			regards, tom lane

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs