david(at)fetter(dot)org (David Fetter) writes:
> I've written a little hack, here included, which is supposed to find
> whether a user is in a group. I'd intended to do a PERFORM instead of
> SELECT INTO, but PERFORM appears to set FOUND to true no matter what.
What version are you using? It seems to work per spec in 7.4.
regression=# create function foo(name) returns bool as '
regression'# begin
regression'# perform * from pg_user where usename = $1;
regression'# return found;
regression'# end' language plpgsql;
CREATE FUNCTION
regression=# select foo('postgres');
foo
-----
t
(1 row)
regression=# select foo('not');
foo
-----
f
(1 row)
regression=#
regards, tom lane