From: | Jie Liang <jliang(at)ipinc(dot)com> |
---|---|
To: | Najm Hashmi <najm(at)mondo-live(dot)com> |
Cc: | pgsql <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: What's wrong with this function |
Date: | 2001-02-09 18:26:46 |
Message-ID: | Pine.BSF.4.10.10102091025110.33254-100000@tidal.ipinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)ipinc(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Albert REINER | 2001-02-09 19:30:20 | Re: fetching the id of a new row |
Previous Message | Jie Liang | 2001-02-09 18:24:33 | Re: pgsql and cursor |