EXECUTE() SQL Commands EXECUTE()
NAME
EXECUTE - execute a prepared statement
SYNOPSIS
EXECUTE name [ ( parameter [, ...] ) ]
DESCRIPTION
EXECUTE is used to execute a previously prepared statement. Since pre-
pared statements only exist for the duration of a session, the prepared
statement must have been created by a PREPARE statement executed ear-
lier in the current session.
If the PREPARE statement that created the statement specified some
parameters, a compatible set of parameters must be passed to the EXE-
CUTE statement, or else an error is raised. Note that (unlike func-
tions) prepared statements are not overloaded based on the type or num-
ber of their parameters; the name of a prepared statement must be
unique within a database session.
For more information on the creation and usage of prepared statements,
see PREPARE [prepare(l)].
PARAMETERS
name The name of the prepared statement to execute.
parameter
The actual value of a parameter to the prepared statement. This
must be an expression yielding a value that is compatible with
the data type of this parameter, as was determined when the pre-
pared statement was created.
OUTPUTS
The command tag returned by EXECUTE is that of the prepared statement,
and not EXECUTE.
EXAMPLES
Examples are given in the Examples [prepare(l)] section of the PREPARE
[prepare(l)] documentation.
COMPATIBILITY
The SQL standard includes an EXECUTE statement, but it is only for use
in embedded SQL. This version of the EXECUTE statement also uses a
somewhat different syntax.
SEE ALSO
DEALLOCATE [deallocate(l)], PREPARE [prepare(l)]
SQL - Language Statements 2008-09-19 EXECUTE()
postgresql 8.3.4 - Generated Sat Oct 4 06:23:36 CDT 2008