summaryrefslogtreecommitdiff
path: root/src/db/rest/comment/api_comment_insert.sql
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--src/db/rest/comment/api_comment_insert.sql (renamed from db/rest/comment/api_comment_insert.sql)4
1 files changed, 3 insertions, 1 deletions
diff --git a/db/rest/comment/api_comment_insert.sql b/src/db/rest/comment/api_comment_insert.sql
index 878e194..990beef 100644
--- a/db/rest/comment/api_comment_insert.sql
+++ b/src/db/rest/comment/api_comment_insert.sql
@@ -34,7 +34,9 @@ BEGIN
_user_id,
NEW.post_id,
NEW.content
- );
+ )
+ RETURNING id
+ INTO NEW.id;
RETURN NEW;
END