Re: BUG #6303: ROW_NUMBER()

On 11/21/2011 06:42 PM, bricklen wrote:
> On Mon, Nov 21, 2011 at 8:40 AM, Alessandro Bellanda
> <a.bellanda@gmail.com>  wrote:
>>
>> The following bug has been logged online:
>>
>> Bug reference:      6303
>> Logged by:          Alessandro Bellanda
>> Email address:      a.bellanda@gmail.com
>> PostgreSQL version: 9.1.1
>> Operating system:   Linux CentOS release 5.5 64 bit
>> Description:        ROW_NUMBER()
>> Details:
>>
>> Case:
>>
>> ROW_NUMBER() OVER (ORDER BY CASE(SUM(expr1)>SUM(expr2),var1,var2))
>>
>> Error description:
>> could not find pathkey item to sort
>
> Tom Lane has already fixed this. See
> http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1679e9feddc94bd7372a6829db92868e55ef7177
>

and the fix will be included into postgres 9.1.2
(that should be announced on Monday Dec 5, with
  tarballs available from Thursday Dec 1)

Andrea