summaryrefslogtreecommitdiff
path: root/src/db/rest/user/api_user_insert.sql
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--src/db/rest/user/api_user_insert.sql (renamed from db/rest/user/api_user_insert.sql)4
1 files changed, 3 insertions, 1 deletions
diff --git a/db/rest/user/api_user_insert.sql b/src/db/rest/user/api_user_insert.sql
index 2297ecd..1a6ef7c 100644
--- a/db/rest/user/api_user_insert.sql
+++ b/src/db/rest/user/api_user_insert.sql
@@ -104,7 +104,9 @@ BEGIN
NEW.gender,
NEW.birth_date,
NEW.profile_bio
- );
+ )
+ RETURNING id
+ INTO NEW.id;
NEW.password := NULL;