BUG #3851: suggestion - support for stored procedures

Поиск
Список
Период
Сортировка
От Lunter
Тема BUG #3851: suggestion - support for stored procedures
Дата
Msg-id 200801050105.m0515SIv051798@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #3851: suggestion - support for stored procedures  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Список pgsql-bugs
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]

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: BUG #3850: Incompatibility among pg_dump / pg_restore.
Следующее
От: "Pavel Stehule"
Дата:
Сообщение: Re: BUG #3851: suggestion - support for stored procedures