Re: Use ctid in where clause in update from statement

Поиск
Список
Период
Сортировка
От Achilleas Mantzios
Тема Re: Use ctid in where clause in update from statement
Дата
Msg-id 73fbdc2d-36cc-a96a-5019-f7c78876ed8d@matrix.gatewaynet.com
обсуждение исходный текст
Ответ на Use ctid in where clause in update from statement  (Dirk Mika <Dirk.Mika@mikatiming.de>)
Ответы Re: Use ctid in where clause in update from statement  (Dirk Mika <Dirk.Mika@mikatiming.de>)
Список pgsql-general
Дерево обсуждения
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
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Dirk Mika
Дата:
Сообщение: Use ctid in where clause in update from statement
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: Use ctid in where clause in update from statement