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