Hi All,
Can any help me in writing a stored procedure in which it returns multiple cursors. Is it possible in PostGres ?.
I need the way like this
BEGIN
OPEN CURSOR c1
select * from table1 where column1>expression;
OPEN CURSOR c2
select * from table2 where column2>expression;
RETURN c1,c2;
END
Is this possible?
Pls reply if any solution.
regards,
-sangaran