Materialize Documentation
s
Join the Community github/materialize

EXECUTE

New in v0.9.7.

EXECUTE plans and executes prepared statements. Since prepared statements only last the duration of a session, the statement must have been prepared during the current session.

If the PREPARE statement specified some parameters, you must pass values compatible with those parameters to EXECUTE.

Syntax

EXECUTE name ( parameter_value , )
Field Use
name The name of the prepared statement to execute.
parameter The actual value of a parameter to the prepared statement.

Example

EXECUTE a ('a', 'b', 1 + 2)