Re: UPDATE Syntax Check

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: UPDATE Syntax Check
Date: 2012-06-12 22:43:26
Message-ID: alpine.LNX.2.00.1206121542290.5399@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2012-06-12 22:50:03 Re: UPDATE Syntax Check
Previous Message Thomas Kellerer 2012-06-12 22:20:53 Re: UPDATE Syntax Check