So to simplify, what I understand is 1. INSERT .. ON CONFLICT is an implementati... | Hacker News

Hacker News .hnnew | past | comments | ask | show | jobs | submit

morekozhambu on May 8, 2015 | parent | context | favorite | on: Postgres gets support for upsert

So to simplify, what I understand is

1. INSERT .. ON CONFLICT is an implementation UPSERT technique

2. MERGE is something meant to be different from UPSERT but has UPSERT feature?

jeltz on May 9, 2015 [–]

Basically true except for many implementations of MERGE not being concurrency safe, which means you would have to loop anyway on unique violation making it no better than the CTE based techniques that already exist in 9.4.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact