diff options
Diffstat (limited to 'contrib/noupdate/README.noup')
| -rw-r--r-- | contrib/noupdate/README.noup | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/contrib/noupdate/README.noup b/contrib/noupdate/README.noup new file mode 100644 index 0000000000..1c773dc778 --- /dev/null +++ b/contrib/noupdate/README.noup @@ -0,0 +1,20 @@ + + +noupdate +~~~~~~~~ + + - trigger to prevent updates on single columns. + + +Example: +~~~~~~~ + +CREATE TABLE TEST ( COL1 INT, COL2 INT, COL3 INT ); + +CREATE TRIGGER BT BEFORE UPDATE ON TEST FOR EACH ROW + EXECUTE PROCEDURE + noup ('COL1'); + +-- Now Try +INSERT INTO TEST VALUES (10,20,30); +UPDATE TEST SET COL1 = 5; |
