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 a4e43abb-0130-4116-69b9-dde644315383@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  (Dirk Mika <Dirk.Mika@mikatiming.de>)
List pgsql-general
Tree view
On 1/7/19 12:13 μ.μ., Dirk Mika wrote:

 

UPDATE test_large d

   SET grp = s.grp

  FROM (SELECT ctid, test_large.*

          FROM test_large

         WHERE grp = 1) s

 WHERE d.ctid = s.ctid;

 


Besides, what the above does is select for rows that have grp=1 and then set grp to the same value.

 

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: Daulat Ram
Date:
Subject: RE: Memory settings
Next
From: Dirk Mika
Date:
Subject: Re: Use ctid in where clause in update from statement