Re: loop Through Query Results : Record - Mailing list pgsql-novice

DAVANNE Eric - NTR <EDavanne@nanterre.sema.slb.com> writes:
> create function createuser() return int2 AS'
> declare
>         username RECORD;
> begin
>   for username in select name from userToCreate loop
>      CREATE USER username.name;
>   end loop ;
> return 1;
> end
> ' LANGUAGE 'sql';

That function is written in plpgsql language, not sql language.

            regards, tom lane