Tom Lane <tgl (AT) sss (DOT) pgh.pa.us> wrote:
Tom,

Thanks for staying on top of this. This was 7.4 on Linux i686,
compiling from source with just the defaults except port. Here's a
working version.

CREATE OR REPLACE FUNCTION in_group (text, text) RETURNS BOOLEAN AS '
BEGIN
PERFORM u.usename
FROM
pg_user u
, pg_group g
WHERE
u.usename = $1
AND g.groname = $2
AND u.usesysid = ANY (g.grolist);

RETURN FOUND;
END;
' LANGUAGE 'plpgsql' STRICT IMMUTABLE;

BTW, I'd like to lobby for an example in the docs of how to do a
PERFORM instead of a SELECT, 'cause that syntax wasn't right away
obvious.

Cheers,
D
--
David Fetter david (AT) fetter (DOT) org http://fetter.org/
phone: +1 510 893 6100 cell: +1 415 235 3778

All for ourselves, and nothing for other people, seems, in every age
of the world, to have been the vile maxim of the masters of mankind.
Adam Smith,
An Inquiry Into the Nature and Causes of the Wealth of Nations

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings