I've gone through the books I have and searched the web but can't find
an answer to this question.
Is it possible to have a plpgsql function return a result set (rows)? If
so what do I declare the return type as?
I know it sounds silly but the reason would be that I have these
extremely long queries that I hate typing. I'd love to just create a
function, do a "SELECT myfunc(1,2,3,4,5,6,7)" and have the function spew
out the result set (rows). So far I can only find example on how to get
PL/PGSQL to return a single value.
Can this be done in PL/PGSQL?
Any pointers to reference material greatly appreciated!
Jc