execute_if - full360/sneaql GitHub Wiki

Command: EXECUTE_IF

description:

execute a SQL statement if condition is true

parameters:

  • required - expression1
  • required - conditional_operator... = != >= =< > <
  • required - expression2

behavior:

  • evaluates provided condition. if condition is true, SQL statement is executed
  • stores (and overwrites) 'last_statement_rows_affected' variable, but this behavior may be inconsistent when running multiple SQL statements

examples:

 /*-execute_if :last_statement_rows_affected > 0-*/ 
 insert into public.test values (1);