| 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: | Whole Thread | Raw Message | 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]
| 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. |