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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general