aboutsummaryrefslogtreecommitdiffstats
path: root/notes/projects/radius/sql/ippool-schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'notes/projects/radius/sql/ippool-schema.sql')
-rw-r--r--notes/projects/radius/sql/ippool-schema.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/notes/projects/radius/sql/ippool-schema.sql b/notes/projects/radius/sql/ippool-schema.sql
index d64dfd5..7348ca3 100644
--- a/notes/projects/radius/sql/ippool-schema.sql
+++ b/notes/projects/radius/sql/ippool-schema.sql
@@ -328,7 +328,9 @@ BEGIN
328 END IF; 328 END IF;
329 329
330 -- update timestamp 330 -- update timestamp
331 IF ( ( OLD.nasId != NEW.nasId ) OR ( OLD.username != NEW.username ) ) THEN 331 -- RAISE EXCEPTION 'Old.nasId = %; NEW.nasId = %;', OLD.nasId, NEW.nasId;
332 IF ( ( OLD.nasId IS DISTINCT FROM NEW.nasId ) OR
333 ( OLD.username IS DISTINCT FROM NEW.username ) ) THEN
332 NEW.modified := current_timestamp; 334 NEW.modified := current_timestamp;
333 END IF; 335 END IF;
334 336