A function which returns all rolname from pg_roles. - Mailing list pgsql-general

From Karen Hill
Subject A function which returns all rolname from pg_roles.
Date
Msg-id 1152584858.269723.115320@h48g2000cwc.googlegroups.com
Whole thread Raw
Responses Re: A function which returns all rolname from pg_roles.
Re: A function which returns all rolname from pg_roles.
List pgsql-general
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;


regards,


pgsql-general by date:

Previous
From: "Alex Turner"
Date:
Subject: Re: Notes on converting from MySQL 5.0.x to PostgreSQL
Next
From: Tom Lane
Date:
Subject: Re: US Telephone Number Type