4 ms·
> That would be great to have UPSERTS Indeed. Postgres has some amazing features, and yet something so basic has been missing for years. I can't wait for a sim
by pornel 13y ago
> That would be great to have UPSERTS
Indeed. Postgres has some amazing features, and yet something so basic has been missing for years. I can't wait for a simple UPSERT, especially that most workarounds work correctly only with 1-row inserts.
- einhverfr 13y agoIn 9.1 and higher, the writable cte's give you multi-row upserts. It isn't particularly simple though.