RE: [GENERAL] question about looping through records in plpgsql - Mailing list pgsql-general

From Jackson, DeJuan
Subject RE: [GENERAL] question about looping through records in plpgsql
Date
Msg-id F10BB1FAF801D111829B0060971D839F6DF558@cpsmail
Whole thread Raw
List pgsql-general
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
>

pgsql-general by date:

Previous
From: Michael Davis
Date:
Subject: question about looping through records in plpgsql
Next
From: Luis Dolz
Date:
Subject: RV: Problems with Visual Fox