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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
