summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--insert.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/insert.sql b/insert.sql
index 1212c8d..df18d80 100644
--- a/insert.sql
+++ b/insert.sql
@@ -35,7 +35,7 @@ linked_participants AS (
'data', participants.data-'relationships',
'relations', TO_JSONB(ARRAY(
SELECT * FROM linked_players
- WHERE participants.data->'relationships'->'player'->'data' = JSONB_BUILD_OBJECT('id', linked_players.data->>'id', 'type', linked_players.data->>'type')
+ WHERE participants.data->'relationships'->'player'->'data' = JSONB_BUILD_OBJECT('id', linked_players.data->'data'->>'id', 'type', linked_players.data->'data'->>'type')
))
) AS data
FROM participants