Have you tried defining what the variable "row" is.
Just a thought,
-DEJ
> -----Original Message-----
> From: Michael Davis [mailto:michael.davis@prevuenet.com]
> Sent: Thursday, March 04, 1999 3:18 PM
> To: pgsql-general@postgreSQL.org
> Subject: [GENERAL] question about looping through records in plpgsql
>
>
> Here is a function that loops through membership records. I
> have tried many
> different variations of this but have not been able to make
> this work. Has
> any one been able to get something similar to this working?
> Is there any
> additional documentation on plpgsql? Is there a another
> language that would
> be better for something like this?
>
> CREATE FUNCTION test(varchar, varchar) RETURNS int2 AS '
> DECLARE
> options ALIAS FOR $1;
> username ALIAS FOR $2;
> mid int4;
> BEGIN
> FOR row IN select * from membership LOOP
> statements;
> END LOOP;
> return 0;
> END; ' LANGUAGE 'plpgsql';
>
>
> Thanks, Michael
>