1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
12
TITLE="PostgreSQL 9.3beta1 Documentation"
13
HREF="index.html"><LINK
16
HREF="sql-commands.html"><LINK
19
HREF="sql-end.html"><LINK
22
HREF="sql-explain.html"><LINK
25
HREF="stylesheet.css"><META
26
HTTP-EQUIV="Content-Type"
27
CONTENT="text/html; charset=ISO-8859-1"><META
29
CONTENT="2013-05-06T21:00:50"></HEAD
35
SUMMARY="Header navigation table"
47
>PostgreSQL 9.3beta1 Documentation</A
66
HREF="sql-commands.html"
81
HREF="sql-explain.html"
102
>EXECUTE -- execute a prepared statement</DIV
104
CLASS="REFSYNOPSISDIV"
135
> is used to execute a previously prepared
136
statement. Since prepared statements only exist for the duration of a
137
session, the prepared statement must have been created by a
141
> statement executed earlier in the
148
> statement that created the statement
149
specified some parameters, a compatible set of parameters must be
153
> statement, or else an
154
error is raised. Note that (unlike functions) prepared statements are
155
not overloaded based on the type or number of their parameters; the
156
name of a prepared statement must be unique within a database session.
159
> For more information on the creation and usage of prepared statements,
161
HREF="sql-prepare.html"
187
> The name of the prepared statement to execute.
199
> The actual value of a parameter to the prepared statement. This
200
must be an expression yielding a value that is compatible with
201
the data type of this parameter, as was determined when the
202
prepared statement was created.
216
> The command tag returned by <TT
220
is that of the prepared statement, and not <TT
234
> Examples are given in the <A
235
HREF="sql-prepare.html#SQL-PREPARE-EXAMPLES"
240
HREF="sql-prepare.html"
253
> The SQL standard includes an <TT
257
but it is only for use in embedded SQL. This version of the
261
> statement also uses a somewhat different
273
HREF="sql-deallocate.html"
276
HREF="sql-prepare.html"
284
SUMMARY="Footer navigation table"
313
HREF="sql-explain.html"
329
HREF="sql-commands.html"
b'\\ No newline at end of file'