The following bug has been logged online:
Bug reference: 3851
Logged by: Lunter
Email address: lunter@interia.pl
PostgreSQL version: 9.0 ?
Operating system: any
Description: suggestion - support for stored procedures
Details:
Some database servers support stored procedures that return more than one
rowset (also known as a result set).
It is very usefull and it permit to full separate SQL statement from
scripting language code and make possible return more than one rowset on one
calling to database.
CREATE PROC procedure_name
[@var INT]
AS
BEGIN
SELECT * FROM Table1 WHERE id = @var;
SELECT * FROM Table2;
SELECT * FROM Table3;
END
---
EXEC/CALL procedure_name [@var = 10]
