Postgres Pro
Downloads
Home   >   mailing lists

Re: UPDATE the field of a table with fields from another table - Mailing list pgsql-novice

From Tom Lane
Subject Re: UPDATE the field of a table with fields from another table
Date
Msg-id 25907.1160945217@sss.pgh.pa.us
Whole thread Raw
In response to UPDATE the field of a table with fields from another table  (Balvie <ener@ibb.nl>)
Responses Re: UPDATE the field of a table with fields from another  (Balvie <ener@ibb.nl>)
List pgsql-novice
Tree view 
Balvie <ener@ibb.nl> writes:
> UPDATE b1_naam
>    SET telnr = t.telnr
>    FROM b1_telco as t
>    WHERE
>      b1_naam.relcode = b1_telco.relcode AND
                         ^^^^^^^^ should be t
>      b1_naam.naam like 'Bakke%';

Less-obsolete versions of Postgres would have warned you about this,
or even reported it as an error.

            regards, tom lane

pgsql-novice by date:

Previous
From: Balvie
Date:
Subject: UPDATE the field of a table with fields from another table
Next
From: Rafael Orta
Date:
Subject: -- Problem loading plperlu --