The following bug has been logged online:
Bug reference: 3851
Logged by: Lunter
Email address: [EMAIL PROTECTED]
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
[EMAIL PROTECTED] INT]
AS
BEGIN
SELECT * FROM Table1 WHERE id = @var;
SELECT * FROM Table2;
SELECT * FROM Table3;
END
---
EXEC/CALL procedure_name [EMAIL PROTECTED] = 10]
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
