Re: PERFORM bug with FOUND?

david@fetter.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