summaryrefslogtreecommitdiff
path: root/contrib/noupdate/README.noup
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/noupdate/README.noup')
-rw-r--r--contrib/noupdate/README.noup20
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;