EXECUTE

Synopsis

Use the EXECUTE statement to execute a previously prepared statement. This separation is a performance optimization because a prepared statement would be executed many times with different values while the syntax and semantics analysis and rewriting are done only once during PREPARE processing.

Syntax

• Grammar
• Diagram

execute_statement ::= EXECUTE name [ ( expression [ , ... ] ) ]

execute_statement

Semantics

name

Specify the name of the prepared statement to execute.

expression

Specify the expression. Each expression in EXECUTE must match with the corresponding data type from PREPARE.

Examples

• Create a sample table.

yugabyte=# CREATE TABLE sample(k1 int, k2 int, v1 int, v2 text, PRIMARY KEY (k1, k2));

• Prepare a simple insert.

yugabyte=# PREPARE ins (bigint, double precision, int, text) AS 
           INSERT INTO sample(k1, k2, v1, v2) VALUES ($1, $2, $3, $4);

• Execute the insert twice (with different parameters).

yugabyte=# EXECUTE ins(1, 2.0, 3, 'a');

yugabyte=# EXECUTE ins(2, 3.0, 4, 'b');

• Check the results.

yugabyte=# SELECT * FROM sample ORDER BY k1;

k1 | k2 | v1 | v2
----+----+----+----
1 |  2 |  3 | a
2 |  3 |  4 | b
(2 rows)

See also

• DEALLOCATE
• PREPARE