Re: A function which returns all rolname from pg_roles.

am  10.07.2006, um 19:27:38 -0700 mailte Karen Hill folgendes:
> How do I make this function work?  I am trying to get all the rolnames
> from pg_roles.
>
> CREATE OR REPLACE FUNCTION test() SETOF name AS $$
> DECLARE
> rrol  name;
> BEGIN
> SELECT rolname INTO rrol FROM pg_roles;
> RETURN setof rrol;
> END;
> $$ LANGUAGE plpgsql;

CREATE OR REPLACE FUNCTION get_all_roles() returns setof text as $$
declare
        rrol    record;
begin
        for rrol in select rolname from pg_roles loop
                return next rrol.rolname;
        end loop;
end;
$$ language plpgsql;


select * from get_all_roles();



HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===