m...@bloodnok.com writes: > I have a query in which I want to use the result of a window function to > isolate the most relevant results. While I was trying to develop and test > the query, I discovered what looks like a bug in the results of the rank() > function. This has been tried with the same results on 9.1.9 and 9.2.4
Well, you didn't provide enough information for somebody else to reproduce the problem, but just looking at this I see no particular reason to think there's a bug. In the first case, the "where ao.org_id = 20150" clause filters rows before the rank() is taken, whereas in the second case it filters after the rank() function. I think the larger rank values indicate that there are other rows with different org_id but the same item_id, which you won't see in the final output in either case --- but in the second query, the rank() function does see them. 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