diff options
Diffstat (limited to '')
| -rw-r--r-- | src/db/rest/comment/api_comment_update.sql (renamed from db/rest/comment/api_comment_update.sql) | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/db/rest/comment/api_comment_update.sql b/src/db/rest/comment/api_comment_update.sql index d6b4aca..b8fc16d 100644 --- a/db/rest/comment/api_comment_update.sql +++ b/src/db/rest/comment/api_comment_update.sql @@ -27,8 +27,9 @@ BEGIN END IF; IF _changed THEN - UPDATE admin.comment - SET content = NEW.content + UPDATE admin.comment SET + content = NEW.content, + modified = clock_timestamp() WHERE id = OLD.id; END IF; |