Re: [SQL] problem with automatic altering of groups

Matthias, > I don't understand why this function ist refused by postgresql with an parse error at the first $1 as ist every > other method I tryed to get postgres making an "alter group" with a variable. I'd be very happy if someone > could help... You can't substitute variables for objec

[SQL] problem with automatic altering of groups

Hello, is ist possible to write a function that alters the group of a given user like the following should do in my opinion (I'd like to use it in a rule): CREATE FUNCTION set_group (text, integer) RETURNS text AS ' ALTER GROUP userlevel1 DROP USER $1; ALTER GROUP userlevel2 DROP U

[SQL] problem with automatic altering of groups

"Matthias Nagl" <[EMAIL PROTECTED]> schrieb am 20.08.03 23:09:03: Hello, is ist possible to write a function that alters the group of a given user like the following should do in my opinion (I'd like to use it in a rule): CREATE FUNCTION set_group (text, integer) RETURNS text AS '