Created
October 10, 2019 10:32
-
-
Save JRaspass/9e7d19ec7bda4923f2e5d2186ab79beb to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| db=> truncate account; | |
| TRUNCATE TABLE | |
| db=> with add as (insert into account (oidc, sub) values ('google', 'foo') on conflict do nothing returning id) select * from add union select id from account where oidc = 'google' and sub = 'foo'; | |
| 11 | |
| db=> with add as (insert into account (oidc, sub) values ('google', 'foo') on conflict do nothing returning id) select * from add union select id from account where oidc = 'google' and sub = 'foo'; | |
| 11 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment