Postgres Pro
Downloads
Home   >   mailing lists

Re: UPDATE Syntax Check - Mailing list pgsql-general

From Rich Shepard
Subject Re: UPDATE Syntax Check
Date
Msg-id alpine.LNX.2.00.1206121542290.5399@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: UPDATE Syntax Check  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
Tree view 
On Wed, 13 Jun 2012, Thomas Kellerer wrote:

> No it's not quite correct:
>
> UPDATE waterchem
>  SET waterchem.easting = s.easting
>      waterchem.northing = s.northing
> FROM sites AS s
> WHERE waterchem.site = s.name;

Thomas,

   I wondered about this syntax, and doing each column separately.

Thanks for the correction,

Rich

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: UPDATE Syntax Check
Next
From: Rich Shepard
Date:
Subject: Re: UPDATE Syntax Check