diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-02-26 16:14:55 +0100 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-02-26 16:14:55 +0100 |
| commit | 89de3ce8eaf0c3d5c41c5b7614a830cb3e6b488c (patch) | |
| tree | b5630a5cfee2a1a389fcda45fc9718e8505a41eb /insert.sql | |
| parent | ecfe701708795c2f35491dc64bd22421dc485992 (diff) | |
| download | apigrabber-89de3ce8eaf0c3d5c41c5b7614a830cb3e6b488c.tar.gz apigrabber-89de3ce8eaf0c3d5c41c5b7614a830cb3e6b488c.zip | |
fix players not being linked to participant
Diffstat (limited to 'insert.sql')
| -rw-r--r-- | insert.sql | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -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 |