Postgres Pro
Downloads
Home   >   mailing lists

Re: Use ctid in where clause in update from statement - Mailing list pgsql-general

From Achilleas Mantzios
Subject Re: Use ctid in where clause in update from statement
Date
Msg-id 73fbdc2d-36cc-a96a-5019-f7c78876ed8d@matrix.gatewaynet.com
Whole thread Raw
In response to Use ctid in where clause in update from statement  (Dirk Mika <Dirk.Mika@mikatiming.de>)
Responses Re: Use ctid in where clause in update from statement
List pgsql-general
Tree view
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"

 

BR

Dirk

 

--
Dirk Mika
Software Developer



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
Attachment

pgsql-general by date:

Previous
From: Dirk Mika
Date:
Subject: Use ctid in where clause in update from statement
Next
From: Thomas Kellerer
Date:
Subject: Re: Use ctid in where clause in update from statement