While Postgres docs are great (they usually are), I would love some more backgrond.
This looks it takes an entire column and upserts all of its rows into another column, on the same or another table.
Is that correct? Is this part of the SQL standard? Is this the same as MERGE in SQL Server and Oracle (which has no counterpart in MySQL)?
IIRC upsert in PG is different than in Mysql, MS or Oracle; is that the same here?
Are there any good resources for this?
Many great things to be part of PG 15. Congratulations
While Postgres docs are great (they usually are), I would love some more backgrond.
This looks it takes an entire column and upserts all of its rows into another column, on the same or another table.
Is that correct? Is this part of the SQL standard? Is this the same as MERGE in SQL Server and Oracle (which has no counterpart in MySQL)?
IIRC upsert in PG is different than in Mysql, MS or Oracle; is that the same here?
Are there any good resources for this?