Thread: Regarding Mutiple cursor returning in PostGres

Regarding Mutiple cursor returning in PostGres

From
"Sangaran"
Date:
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