Re: loop Through Query Results : Record

DAVANNE Eric - NTR <EDavanne(at)nanterre(dot)sema(dot)slb(dot)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