> 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
