Re: UPDATE Syntax Check - Mailing list pgsql-general

On Wed, 13 Jun 2012, Thomas Kellerer wrote:

> UPDATE waterchem
>  SET waterchem.easting = s.easting
>      waterchem.northing = s.northing
> FROM sites AS s
> WHERE waterchem.site = s.name;

Thomas,

   For the record, running this pushed me to the correct syntax:

   UPDATE waterchem
     SET easting = s.easting
         northing = s.northing
   FROM sites AS s
   WHERE waterchem.site = s.name;

   The target does not want the table name repeated; postgres looks for a
column named 'waterchem.easting'.

Regards,

Rich