loop Through Query Results : Record

From: DAVANNE Eric - NTR <EDavanne(at)nanterre(dot)sema(dot)slb(dot)com>
To: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: loop Through Query Results : Record
Date: 2004-03-25 14:51:59
Message-ID: 0D740BCE2280D411A1E00001029E60180475FF8B@NTRMES04
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,
I'm trying to loop Through Query Results
For example :
- I have a table with few user to create .
create table userToCreate(name varchar )

- I create a function :
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';

I don't understand why i get this error :
An error has occured in pdAdmin II:frmSQLInput.cmdExecute_Click:
Number : -2147467259
Description ERROR: parser error at or near "record"

Does someone can help me ?

thank's

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message joseph speigle 2004-03-25 15:00:08 Re: loop Through Query Results : Record
Previous Message David P. Lurie 2004-03-25 08:11:04 Re: configure script failure with SCO 5.0.7