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