returning rows from a function - Mailing list pgsql-general

I am new to Postgres and have a rather straightforward question. Is it possible, and if so, what is the syntax for returning a recordset from a function?

I have tried

CREATE FUNCTION selectUserProperties(text) RETURNS RECORD

and

CREATE FUNCTION selectUserProperties(text) RETURNS SETOF varchar

Neither of which seems to work. The rest of the function is…

CREATE FUNCTION selectUserProperties (text) RETURNS RECORD

AS '

BEGIN

            SELECT            key,

                                    value

            FROM               user_properties

            WHERE            username = $1;

END;

' LANGUAGE 'plpgsql';

Both key and value in this example are varchar columns.

Thanks for your help.

__________________

Nikheel Dhekne

NetAid | Developer

http://www.netaid.org