BUG #3851: suggestion - support for stored procedures

From: "Lunter" <lunter(at)interia(dot)pl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3851: suggestion - support for stored procedures
Date: 2008-01-05 01:05:28
Message-ID: 200801050105.m0515SIv051798@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 3851
Logged by: Lunter
Email address: lunter(at)interia(dot)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
[(at)var INT]
AS
BEGIN
SELECT * FROM Table1 WHERE id = @var;
SELECT * FROM Table2;
SELECT * FROM Table3;
END

---

EXEC/CALL procedure_name [(at)var = 10]

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stefan Kaltenbrunner 2008-01-05 07:33:22 Re: BUG #3850: Incompatibility among pg_dump / pg_restore.
Previous Message Stefan Kaltenbrunner 2008-01-04 19:25:20 Re: BUG #3850: Incompatibility among pg_dump / pg_restore.