[GENERAL] Ranking values within a query (pseudo-ROWNUM) **fixed**

2004-06-24 Thread Jeff Boes
Gah, I'm dreadfully sorry. The original functions were cut-and-pasted from a "\df+" window, which meant they lost their quoted-ness, which means if you try to cut and paste from my message to a SQL prompt, you'll be sorely disappointed. Below are the edited versions. create table rank_of_values

[GENERAL] Ranking values within a query (pseudo-ROWNUM)

2004-06-24 Thread Jeff Boes
I hope this helps someone else ... I had struggled some time ago with attempts to get a rank of values query to work, but then I gave up and set it aside. I had another reason to attack it, and in between then and now I learned how to return "setof" values from a function, as well as how to con