NexusDB Guide > SQL Reference > Predicates

NexusDB V3 Manual

Inserting Predicate

Testing if a trigger event is INSERT.

Syntax

<inserting predicate> ::= INSERTING

Notes

§	The INSERTING predicate can only be specified in the body of a trigger definition to check the trigger event.

§	The predicate evaluates to TRUE if the trigger was activated by an INSERT operation on the table, else to FALSE.

Examples

1)	The following example shows how the INSERT predicate is used in the WHEN clause of a triggered action:

WHEN ( INSERTING )

triggered SQL statements

2)	The following example shows how the INSERT predicate is used in a triggered SQL statement:

IF INSERTING THEN ... END IF;

Conformance

NexusDB extensions

INSERTING predicate

nexus_logo