[SQL] Can the result sets produced in SQL procedures be left open for theuse of the calling program?

Поиск
Список
Период
Сортировка
От Gugu Rama
Тема [SQL] Can the result sets produced in SQL procedures be left open for theuse of the calling program?
Дата
Msg-id CAG2jv3fNBBa00SeuhUXwd+3TftEPSWkKMEU-eTY-10jfgHahmg@mail.gmail.com
обсуждение исходный текст
Ответы Re: [SQL] Can the result sets produced in SQL procedures be left openfor the use of the calling program?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-sql
Дерево обсуждения
Hi, 

May i ask, if I write an hll program and make a call to an sql procedure, will the result set which is produced in the sql procedure be available for the calling program, after the sql prodecure ends? 

Example:

HLL program body (which undertakes frontend tasks, gets input from the user)
.
.
.
Call to an SQL procedure (all due backend stuff, which creates a result set depending on the input from the user)
.
.
.
HLL program body (sends the data in the result set to the screen)


Thank you..

Gulsum

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

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: Re: [SQL] Inconsistent/wrong behavior of pg_trigger_depth when usedwith DEFERRED CONSTRAINTS
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: [SQL] Can the result sets produced in SQL procedures be left openfor the use of the calling program?