Navigation:  NexusDB Guide > SQL Reference > Predicates >

Updating Predicate

Previous pageReturn to chapter overviewNext page

NexusDB V3 Manual

Updating Predicate

button_main button_prev button_next

NexusDB Manual V3 > SQL Reference > Predicates

Testing if a trigger event is UPDATE.

 

Syntax

 

<updating predicate> ::= UPDATING

 

 

Notes

 

§

The UPDATING 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 UPDATE operation on the table, else to FALSE.

 

 

Examples

 

1)

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

 

      WHEN ( UPDATING )

      triggered SQL statements

 

2)

The following example shows how the UPDATE predicate is used in a triggered SQL statement:

 

      IF UPDATING THEN ... END IF;

 

 


Conformance

 

NexusDB extensions

-

UPDATING predicate

 

© Nexus Database Systems Pty Ltd.

nexus_logo