for row in select loop question

From: Michael Davis <michael(dot)davis(at)prevuenet(dot)com>
To: hackers(at)postgreSQL(dot)org
Subject: for row in select loop question
Date: 1999-03-03 22:12:54
Message-ID: 93C04F1F5173D211A27900105AA8FCFC145221@lambic.prevuenet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The following function does not work:

CREATE FUNCTION InstallPermissions(varchar, varchar) RETURNS int2 AS '
DECLARE
options ALIAS FOR $1;
username ALIAS FOR $2;
BEGIN
FOR row IN select * from pg_tables LOOP
REVOKE ALL ON row.tablename FROM username;
GRANT options on row.tablename TO username;
END LOOP;
return 0;
END; ' LANGUAGE 'plpgsql';

"select InstallPermissions('test1', 'test2);" returns an error at "select".
Any suggestions on how to eliminate the error?

Thanks, Michael

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 1999-03-03 22:24:26 Tom Lane's fixes in v6.4.3
Previous Message Michael Davis 1999-03-03 19:50:12 parser enhancement request for 6.5