From: Robert B. Easter <reaster@comptechnews.com>
To: pgsql-docs@postgresql.org
Subject: another little plsql.sgml patch for execute
Date: Sat, 6 Jan 2001 20:09:07 -0500
Message-ID: <01010620090717.09559@comptechnews> (raw)
A patch for doc/src/sgml/plsql.sgml to add a little more info about PL/pgSQL
EXECUTE.
--
-------- Robert B. Easter reaster@comptechnews.com ---------
-- CompTechNews Message Board http://www.comptechnews.com/ --
-- CompTechServ Tech Services http://www.comptechserv.com/ --
---------- http://www.comptechnews.com/~reaster/ ------------
Attachments:plsql.sgml.patch (text/english, 1.9K) download
*** plsql.sgml Sat Jan 6 20:04:15 2001
--- plsql.sgml.modi Sat Jan 6 20:01:49 2001
***************
*** 488,505 ****
<listitem>
<cmdsynopsis>
<command>EXECUTE</command>
! <arg choice="req"><replaceable class="command">query</replaceable></arg>
</cmdsynopsis>
!
<para>
Unlike all other queries in PL/pgSQL, a
<replaceable>query</replaceable> run by an EXECUTE statement
is not prepared and saved just once during the life of the
server. Instead, the <replaceable>query</replaceable> is
! prepared each time the statement is run. This allows the
! <replaceable>query</replaceable> to be dynamically created
within the procedure to perform actions on variable tables and
fields.
</para>
<para>
--- 488,515 ----
<listitem>
<cmdsynopsis>
<command>EXECUTE</command>
! <arg choice="req"><replaceable class="command">query-string</replaceable></arg>
</cmdsynopsis>
!
! <para>
! where <replaceable>query-string</replaceable> is a string
! of type TEXT containing the <replaceable>query</replaceable> to be executed.
! </para>
!
<para>
Unlike all other queries in PL/pgSQL, a
<replaceable>query</replaceable> run by an EXECUTE statement
is not prepared and saved just once during the life of the
server. Instead, the <replaceable>query</replaceable> is
! prepared each time the statement is run. The
! <replaceable>query-string</replaceable> can be dynamically created
within the procedure to perform actions on variable tables and
fields.
+ </para>+ + <para>+ The results from SELECT queries are discarded by EXECUTE unless+ SELECT INTO is used to save the results into a table.
</para>
<para>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: reaster@comptechnews.com
Subject: Re: another little plsql.sgml patch for execute
In-Reply-To: <01010620090717.09559@comptechnews>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox