Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group