PERFORM bug with FOUND?

Поиск
Список
Период
Сортировка
От david@fetter.org (David Fetter)
Тема PERFORM bug with FOUND?
Дата
Msg-id G-KdnQUw2qLnFiOiXTWc-w@speakeasy.net
обсуждение исходный текст
Ответы Re: PERFORM bug with FOUND?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Kind people,

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's going on here?

The hack in question...

CREATE OR REPLACE FUNCTION in_group (text, text) RETURNS BOOLEAN AS '
DECLARE
    the_user  ALIAS FOR $1;
    the_group ALIAS FOR $2;
    dummy text; -- SELECT INTO dummy because PERFORM always returns true.
                -- Is this a bug?
BEGIN
    SELECT INTO dummy u.usename
    FROM
      pg_user u
    , pg_group g
    WHERE
        u.usename = the_user
    AND g.groname = the_group
    AND u.usesysid = ANY (g.grolist);

    IF FOUND
    THEN
        RETURN true;
    ELSE
        RETURN false;
    END IF;
END;
' LANGUAGE 'plpgsql' STRICT IMMUTABLE;

TIA for any hints, tips or pointers :)

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

If you don't vote, don't bitch.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Notes about behaviour of SIMILAR TO operator
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PERFORM bug with FOUND?