On 1/7/19 12:13 μ.μ., Dirk Mika wrote:
Hello,
I come from the Oracle world and am trying to convert some queries to PostgreSQL syntax. One of these queries is a MERGE statement, which I converted into an UPDATE SET FROM WHERE construct. In the original query I use the pseudo column ROWID to match a source row with a target row.
This is a simplified version of such a query:
Postgresql supports upserts :
https://www.postgresql.org/docs/11/sql-insert.html "ON CONFLICT"
-- Dirk Mika Software Developer
|
![](/media/maillist_attaches/pgsql-general/2019/07/1/73fbdc2d-36cc-a96a-5019-f7c78876ed8d@matrix.gatewaynet.com/image001_d0a5cf51-5dd3-4ff5-b428-1016a6d95a0f.png)
mika:timing GmbH Strundepark - Kürtener Str. 11b 51465 Bergisch Gladbach Germany
|
fon +49 2202 2401-1197 dirk.mika@mikatiming.de www.mikatiming.de
|
AG Köln HRB 47509 * WEEE-Reg.-Nr. DE 90029884 Geschäftsführer: Harald Mika, Jörg Mika |
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt