From: | jprem <jprem(at)srmsoft(dot)co(dot)in> |
---|---|
To: | pgman <pgman(at)candle(dot)pha(dot)pa(dot)us>, postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | help -- cursor inside a function |
Date: | 2000-07-03 06:56:51 |
Message-ID: | 39603931.6C0069BF@srmsoft.co.in |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hello ,
i have a procedure as below.
-------------------------------------------------------------------------------------------------------------
create function retrec(integer) returns integer
as
'declare
uid alias for $1;
begin
declare retrec_cur cursor for select * from jd_user_master where
um_user_id>uid;
if found then
fetch 1 from retrec_cur;
move next from retrec_cur;
return 1;
end if;
end;'
language 'plpgsql';
-------------------------------------------------------------------------------------------------------------------------
this gets created , but while running it i get the error below,
-------------------------------------------------------------------------------------------------------------------
NOTICE: plpgsql: ERROR during compile of retrec near line 5
ERROR: parse error at or near "cursor"
--------------------------------------------------------------------------------------------------------------------------
why this is so ? can anyone help me out ? thanx in advance.
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Rowell | 2000-07-03 08:09:43 | Primary key question |
Previous Message | Philip Warner | 2000-07-03 01:07:43 | Re: disk backups |