Re: plpgsql FOR
Список
Период
Сортировка

От wieck@debis.com (Jan Wieck)
Тема Re: plpgsql FOR
Дата
Msg-id m12kDjf-0003knC@orion.SAPserv.Hamburg.dsh.de
обсуждение исходный текст
Ответ на plpgsql FOR
Ответы Re: plpgsql FOR
Список pgsql-general
Дерево обсуждения 
> Hello -
>    After reading the documentation several times, and looking at
> the archives, I'm very confused. The PL/pgSQL documentation states
> that :

    Looks like you're confused.

>
> [<<label>>]
> FOR record | row IN select_clause LOOP
>    statements
> END LOOP;
>
> is valid, and after having (probably mistakenly) thought that a
> record/row can be a single item, I wrote :
>
>   FOR lgid IN select gid from groups_acl where login = NEW.login LOOP
>     ...<do stuff with lgid>...

    Here  you  have the syntax right, but I assume "lgid" isn't a
    record or row type variable.

>
> This, of course, is a syntax error. After reading the archives, I've
> progressed to
>
> <snip>
> DECLARE
>   rec record;
> BEGIN
>   FOR select x into rec from groups_acl where login = NEW.login LOOP
>     ...<do stuff with rec.gid>...
> <snip>

    This time you messed up the syntax. Write it as

    FOR rec IN select * from groups_acl where login = NEW.login LOOP
        ...
    END LOOP;

> drop function post_account();
> drop trigger post_account on account;
> create function post_account () returns OPAQUE as '
>   DECLARE
>     rec record;
>     seq int;
>   BEGIN
>     FOR select x into rec from groups_acl where login = NEW.login LOOP
>       select nextval(''access_aid_seq'') into seq;
>       insert into access values(seq, NEW.acid);
>       insert into groups_access values(rec.gid, seq);
>     END LOOP;
>   END;
> ' LANGUAGE 'plpgsql';

    BTW

    seq := nextval(''access_aid_seq'');

    might look more readable.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#========================================= wieck@debis.com (Jan Wieck) #

В списке pgsql-general по дате отправления: