Re: PL/pgSQL stored procedure returning multiple result sets (SELECTs)?

> CREATE PROCEDURE list_user_accounts(IN user_id INT)
>
>     BEGIN
>
>     -- Return first result set (single row)
>     SELECT * FROM users WHERE id = user_id;
>
>     -- Return second result set (zero or more rows)
>     SELECT * FROM accounts WHERE account_holder = user_id;
>
>     END;
>
>
> So, is it true that as of Postgresql 8.3 there is no way to have a
> pgpqsql function return multiple SELECTs?
>
>
> Vladimir Dzhuvinov
>
>
Have you considered returning XML instead? You should be able to get
what your looking for much easier with an XMLAGG.

Artacus