Hi, I've got a financial MySQL database where the application accesses data through a layer of stored procedures. For various reasons I'm currently investigating my options to migrate to another SQL RDBMS. Postgresql seems to offer a few nice advantages over MySQL (e.g. stricter data integrity through checks and constraints, etc.) and I got quite excited about it. However, after consulting the docs and running a few tests, it looks like Postgresql misses a crucial feature which my application depends upon - returning multiple SELECT result sets from functions/stored procedures. To illustrate, I've got a number of MySQL stored procedures that look approximately like this: 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 -- Vladimir Dzhuvinov * www.valan.net * PGP key ID AC9A5C6C
Attachment:
signature.asc
Description: OpenPGP digital signature
