Dear Friends,
I am using Postgres 7.3.4 on Redhat linux
In one of my requirement, I am getting a cursor as input parameter.
I am trying to process the records inside this cursor and i am not able to do it. (Some thing like opening and fetching a cursor in SQL Server)
My approach is as follows.
fn_xyz(refcursor,int4) returns record
Declare
data ALIAS $1;
mview RECORD;
FOR mview IN FETCH ALL IN data
LOOP
//Process the records.
END LOOP;
Is this possible. Please shed some light.
Thanks
Kumar