how to write correctly this update ?

From: Pierre Couderc <pierre(at)couderc(dot)eu>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: how to write correctly this update ?
Date: 2019-05-22 12:43:06
Message-ID: 388af3c8-bfcf-8e38-4634-7ebda366f410@couderc.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have tried many ways to update a table  :

UPDATE  personnes T1 SET T1.nom_naiss=T1.nom FROM  personnes T2,
personnes T3
WHERE  ....;

UPDATE  personnes T1 SET T1.nom_naiss=T1.nom FROM  personnes T1,
personnes T2, personnes T3
WHERE ..;

In my case , where clause is : WHERE T1.id=T2.id_mere AND
T2.id_pere=T3.id AND T1.nom != T3.nom;

Thanks.

PC

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeremy Finzel 2019-05-22 13:01:41 Re: Bulk inserts into two (related) tables
Previous Message Rich Shepard 2019-05-22 12:40:16 Re: Bulk inserts into two (related) tables