Re: Use ctid in where clause in update from statement

Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> · Mon, 1 Jul 2019 12:27:16 +0300



    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@xxxxxxxxxxxxx

                    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