how to write correctly this update ? - Mailing list pgsql-general

From Pierre Couderc
Subject how to write correctly this update ?
Date
Msg-id 388af3c8-bfcf-8e38-4634-7ebda366f410@couderc.eu
Whole thread Raw
Responses Re: how to write correctly this update ?
List 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







pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Bulk inserts into two (related) tables
Next
From: Jeremy Finzel
Date:
Subject: Re: Bulk inserts into two (related) tables