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