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

From: Gugu Rama <gulsumramazanoglu(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Can the result sets produced in SQL procedures be left open for the use of the calling program?
Date: 2017-06-01 21:15:12
Message-ID: CAG2jv3fNBBa00SeuhUXwd+3TftEPSWkKMEU-eTY-10jfgHahmg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Adrian Klaver 2017-06-01 21:24:36 Re: Can the result sets produced in SQL procedures be left open for the use of the calling program?
Previous Message Achilleas Mantzios 2017-06-01 08:38:47 Re: Inconsistent/wrong behavior of pg_trigger_depth when used with DEFERRED CONSTRAINTS