Thread: RE: [GENERAL] question about looping through records in plpgsql

RE: [GENERAL] question about looping through records in plpgsql

From
"Jackson, DeJuan"
Date:
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
>