Date: Wed, 19 Oct 2011 13:32:32 +0200 (CEST)
From: Andreas Kretschmer <andreas@a-kretschmer.de>
To: =?UTF-8?Q?=22Brice_Andr=C3=A9=22?= <brice@famille-andre.be>,
	pgsql-sql@postgresql.org
Message-ID: 
 <682203673.92.1319023952704.JavaMail.open-xchange@oxweb01.ims-firmen.de>
In-Reply-To: 
 <CAOBG12mCa-07QW==228ieiosV_TKWK8wAowAhW+kXSkyVkfY9Q@mail.gmail.com>
References: 
 <CAOBG12mCa-07QW==228ieiosV_TKWK8wAowAhW+kXSkyVkfY9Q@mail.gmail.com>
Subject: Re: Problem with DROP ROLE
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Importance: Medium

You can't do that in THAT way, but you can use dynamic SQL:
=C2=A0
test=3D# select * from drop_role ;
=C2=A0=C2=A0 t
--------
=C2=A0foobar
(1 row)

test=3D*# do $$ declare r text; begin for r in select t from drop_role loop
execute 'drop role ' || quote_ident(r) || ';'; end loop; end; $$language
plpgsql;
=C2=A0
DO=C2=A0

=C2=A0
=C2=A0

"Brice Andr=C3=A9" <brice@famille-andre.be> hat am 19. Oktober 2011 um 12:1=
1
geschrieben:


> Hello everyone,
>=20
> I would want to implement an SQL query where I would be able to suppress =
all
> information from a registered user. I am currenlty able to suppress every=
thing
> except the user role. The name of the role is present in a table and so, =
I
> would want to perform something like this :
> DROP ROLE (SELECT ...)
> but this is not considered as valid, as DROP ROLE is expecting a name and=
 not
> a text field. So, I tried the following, but with no success :
> DROP ROLE CAST((SELECT...) AS name)
>=20
> So, does someone knows how to handle this problem ?
>=20
> Regards,
> Brice
>