I just know you can use implict cursor inside the plpgsql
e.g
declare
rec record;
begin
FOR rec IN select_clause LOOP statements
END LOOP;
end;
Jie LIANG
St Bernard Software
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
jliang@ipinc.com
www.ipinc.com
On Sat, 10 Feb 2001, Najm Hashmi wrote:
> Hi all,
> Here is a plpgsql function:
> flipr'#create function test_cur() returns text as'
> flipr'# declare
> flipr'# mycur cursor for select title from songs where song_id=10;
> flipr'# usr record;
> flipr'# results text;
> flipr'# begin
> flipr'# open mycur;
> flipr'# fetch next from mycur into usr;
> flipr'# close mycur;
> flipr'# results:= usr.title;
> flipr'#
> flipr'# end;
> flipr'# ' language 'plpgsql';
> CREATE
> flipr=# select test_cur() as Title;
> NOTICE: plpgsql: ERROR during compile of test_cur near line 2
> ERROR: parse error at or near "cursor"
>
> What I am doing wrong?
> Thanks in advance for your help.
> Regards, Najm
>
>