At 04:00 PM 4/15/2003 -0500, David Zvekic wrote:

>1. deferred until the completion of the statement, which means that
>if the data becomes temporarily invalid during the execution of a single
>statement, but by the completion of the statement
>it corrects itself then the constraint is satisfied.

In fact, that is the way constraints are supposed to work. The
SQL standard considers UPDATE T1 SET A = 5 to be a single statement,
not on statement for each instance of T1.

Regards,


Ann