diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-02-26 13:32:23 +0100 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-02-26 13:32:23 +0100 |
| commit | bdcc5add4e5114746b47c4d481e316b7ee3415e4 (patch) | |
| tree | 195290dc7b72be073b85310f2acfd8e387e1bf0f /insert.sql | |
| parent | 568ec9e3194c61b8e489b0ea6b9204c9297e07e8 (diff) | |
| parent | ce1f18227b3b8e3d087e2b920151d63d0061fe33 (diff) | |
| download | apigrabber-bdcc5add4e5114746b47c4d481e316b7ee3415e4.tar.gz apigrabber-bdcc5add4e5114746b47c4d481e316b7ee3415e4.zip | |
Merge branch 'pass-type' into develop
Diffstat (limited to 'insert.sql')
| -rw-r--r-- | insert.sql | 8 |
1 files changed, 4 insertions, 4 deletions
@@ -68,15 +68,15 @@ insert_matches AS ( INSERT INTO match SELECT * FROM linked_matches ON CONFLICT(id) DO NOTHING - RETURNING id -- TODO conflict shouldn't happen in prod + RETURNING type, id -- TODO conflict shouldn't happen in prod ), insert_players AS ( INSERT INTO player SELECT * FROM linked_players ON CONFLICT(id) DO UPDATE SET attributes=EXCLUDED.attributes WHERE (player.attributes->'stats'->>'played')::int < (EXCLUDED.attributes->'stats'->>'played')::int - RETURNING id + RETURNING type, id ) - SELECT * FROM insert_matches + SELECT type, id FROM insert_matches UNION - SELECT * FROM insert_players + SELECT type, id FROM insert_players |
