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

Поиск
Список
Период
Сортировка
От Jackson, DeJuan
Тема RE: [GENERAL] question about looping through records in plpgsql
Дата
Msg-id F10BB1FAF801D111829B0060971D839F6DF558@cpsmail
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Michael Davis
Дата:
Сообщение: question about looping through records in plpgsql
Следующее
От: Luis Dolz
Дата:
Сообщение: RV: Problems with Visual Fox