EXECUTE#
Synopsis#
EXECUTE statement_name [ USING parameter1 [ , parameter2, ... ] ]
Description#
Executes a prepared statement with the name statement_name
. Parameter values
are defined in the USING
clause.
Examples#
Prepare and execute a query with no parameters:
PREPARE my_select1 FROM
SELECT name FROM nation;
EXECUTE my_select1;
Prepare and execute a query with two parameters:
PREPARE my_select2 FROM
SELECT name FROM nation WHERE regionkey = ? and nationkey < ?;
EXECUTE my_select2 USING 1, 3;
This is equivalent to:
SELECT name FROM nation WHERE regionkey = 1 AND nationkey < 3;