You can do upserts as a single atomic statement using the WITH statement: https://gist.github.com/paul/855efdecaaa2ec4deec7 https://gist.github.com/paul/855efd

You can do upserts as a single atomic statement using the WITH statement: https://gist.github.com/paul/855efdecaaa2ec4deec7 https://gist.github.com/paul/855efdecaaa2ec4deec7 You can also use it to perform a "find or insert" as a single atomic action: https://gist.github.com/paul/75ec84d131e36492b17b https://gist.github.com/paul/75ec84d131e36492b17b