summaryrefslogtreecommitdiff
path: root/db/rest/util/_api_get_user_id.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db/rest/util/_api_get_user_id.sql')
-rw-r--r--db/rest/util/_api_get_user_id.sql11
1 files changed, 0 insertions, 11 deletions
diff --git a/db/rest/util/_api_get_user_id.sql b/db/rest/util/_api_get_user_id.sql
deleted file mode 100644
index 23eb160..0000000
--- a/db/rest/util/_api_get_user_id.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-CREATE FUNCTION _api.get_user_id()
-RETURNS INTEGER
-LANGUAGE plpgsql VOLATILE
-AS $BODY$
-BEGIN
- RETURN CURRENT_SETTING(
- 'request.jwt.claims',
- TRUE
- )::JSON->>'user_id';
-END
-$BODY$;