On Mon, 13 Oct 2008 12:17:21 +0300 Vladimir Dzhuvinov <vd@xxxxxxxxx> wrote: > 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; I'd say returning multiple recordset is useful to save connections and transferred data. You can't get the same with a left join (users fields will be repeated over and over) and you can't get the same with 2 separated statements since they will need 2 connections. But from the client side, suppose it PHP... if the first statement return no record and the second one return 3 records, how can I know? What about functions like pg_num_fields? -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
