diff options
Diffstat (limited to 'notes/projects/radius/sql/ippool-schema.sql')
| -rw-r--r-- | notes/projects/radius/sql/ippool-schema.sql | 4 |
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 | ||
