diff options
| author | Kapil Viren Ahuja <kvahuja@users.noreply.github.com> | 2017-02-27 14:28:42 +0530 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-02-27 14:28:42 +0530 |
| commit | 96916f5f501a6392deae6174bbb687fe10c0f400 (patch) | |
| tree | 5f9780b6f477443ee71c3990a429cb6b8f96c5dd | |
| parent | d86d631fb669f927b8652ae204607f8a11509b50 (diff) | |
| parent | 07dd572a1f61cb5feb3af84c20945a2b0d9b2f84 (diff) | |
| download | apigrabber-96916f5f501a6392deae6174bbb687fe10c0f400.tar.gz apigrabber-96916f5f501a6392deae6174bbb687fe10c0f400.zip | |
Merge pull request #43 from vainglorygame/fix-participant-links
fix participants not being linked into roster
| -rw-r--r-- | insert.sql | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -39,7 +39,7 @@ 'data', rosters.data - 'relationships', 'relations', TO_JSONB(ARRAY( SELECT * FROM linked_participants - WHERE rosters.data->'relationships'->'participants'->'data' @> JSONB_BUILD_ARRAY(JSONB_BUILD_OBJECT('id', linked_participants.data->>'id', 'type', linked_participants.data->>'type')) + WHERE rosters.data->'relationships'->'participants'->'data' @> JSONB_BUILD_ARRAY(JSONB_BUILD_OBJECT('id', linked_participants.data->'data'->>'id', 'type', linked_participants.data->'data'->>'type')) )) ) AS data FROM rosters |