Actually standard SQL does specify a MERGE command (which lets you implement an ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		acarl005 on Dec 30, 2022 \| parent \| context \| favorite \| on: PRQL: a simple, powerful, pipelined SQL replacemen... Actually standard SQL does specify a MERGE command (which lets you implement an upsert) and it's implemented in Postgres

password4321 on Dec 30, 2022 [–]

MERGE debuted in PostgreSQL 15 fairly recently, and has some caveats.

https://news.ycombinator.com/item?id=33236780

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