pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedanother little plsql.sgml patch for execute
2+ messages / 2 participants
[nested] [flat]
* another little plsql.sgml patch for execute
@ 2001-01-07 01:09 Robert B. Easter <reaster@comptechnews.com>
2001-01-09 15:26 ` Re: another little plsql.sgml patch for execute Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Robert B. Easter @ 2001-01-07 01:09 UTC (permalink / raw)
To: pgsql-docs
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>
* Re: another little plsql.sgml patch for execute
2001-01-07 01:09 another little plsql.sgml patch for execute Robert B. Easter <reaster@comptechnews.com>
@ 2001-01-09 15:26 ` Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Bruce Momjian @ 2001-01-09 15:26 UTC (permalink / raw)
To: Robert B. Easter <reaster@comptechnews.com>; +Cc: pgsql-docs
Applied. Thanks.
[ Charset ISO-8859-1 unsupported, converting... ]
> 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/ ------------
[ Attachment, skipping... ]
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-01-09 15:26 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-07 01:09 another little plsql.sgml patch for execute Robert B. Easter <reaster@comptechnews.com>
2001-01-09 15:26 ` Bruce Momjian <pgman@candle.pha.pa.us>
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