Re: [BUGS] pg 9.1.1 - ERROR: could not find pathkey item to sort

2011-09-26 Thread Tom Lane
I wrote: > bricklen writes: >> Is this a bug, > Yes. Thanks for the test case, will look. Fixed, patch is at http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=1679e9feddc94bd7372a6829db92868e55ef7177 regards, tom lane -- Sent via pgsql-bugs mailing lis

Re: [BUGS] pg 9.1.1 - ERROR: could not find pathkey item to sort

2011-09-26 Thread Tom Lane
bricklen writes: > Is this a bug, Yes. Thanks for the test case, will look. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] pg 9.1.1 - ERROR: could not find pathkey item to sort

2011-09-26 Thread bricklen
Is this a bug, or due to the way I am using the RANK() function in the following query? The error is triggered when I use (sum(y) / sum(x)) in the ORDER BY of the RANK() function. Simple test case: create table t (a int, b int, x numeric, y integer ); insert into t select g,round(mod(g,4)), roun