Received: from gadolinium.btinternet.com (gadolinium.btinternet.com [194.73.73.111]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f19L92x25304 for ; Fri, 9 Feb 2001 16:09:02 -0500 (EST) (envelope-from m.proctor@bigfoot.com) Received: from [213.122.230.78] (helo=localhost.localdomain) by gadolinium.btinternet.com with smtp (Exim 3.03 #83) id 14RKmn-0004TE-00; Fri, 09 Feb 2001 21:08:57 +0000 From: Reply-To: m.proctor@bigfoot.com To: Najm Hashmi , pgsql Subject: Re: What's wrong with this function Date: Fri, 9 Feb 2001 21:17:03 +0000 X-Mailer: KMail [version 1.1.99] Content-Type: text/plain; charset="us-ascii" References: <3A858290.270E2473@mondo-live.com> In-Reply-To: <3A858290.270E2473@mondo-live.com> MIME-Version: 1.0 Message-Id: <01020921170307.05071@localhost.localdomain> Content-Transfer-Encoding: 8bit X-Archive-Number: 200102/181 X-Sequence-Number: 1367 the select query returns the first row to rec. You can then access its values with: rec.field_name at END LOOP it jumps back to FOR checks to see if there any more rows and if so moves to the next row and repeats the loop. It also looks like your missing a LOOP keyword at the end of the FOR line. Here is an example that works. CREATE FUNCTION get_children (integer) RETURNS integer AS '     DECLARE         pnode_parent ALIAS FOR $1;         rec RECORD;     BEGIN         FOR rec IN SELECT * FROM  tree_adjacency_matrix WHERE node_parent = pnode_parent LOOP             INSERT INTO test (node1, node2) VALUES(stm.node_child, .rec.node_parent);         END LOOP;         RETURN 0;     END; 'LANGUAGE 'plpgsql' Mark On Saturday 10 February 2001 18:04, 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