Postgres Pro
Downloads
Home   >   mailing lists

[SQL] Can the result sets produced in SQL procedures be left open for theuse of the calling program? - Mailing list pgsql-sql

From Gugu Rama
Subject [SQL] Can the result sets produced in SQL procedures be left open for theuse of the calling program?
Date
Msg-id CAG2jv3fNBBa00SeuhUXwd+3TftEPSWkKMEU-eTY-10jfgHahmg@mail.gmail.com
Whole thread Raw
Responses 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>)
List pgsql-sql
Tree view
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 by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: [SQL] Inconsistent/wrong behavior of pg_trigger_depth when usedwith DEFERRED CONSTRAINTS
Next
From: Adrian Klaver
Date:
Subject: Re: [SQL] Can the result sets produced in SQL procedures be left openfor the use of the calling program?