On Thu, May 26, 2011 at 1:40 PM, Rick Genter <rick.genter@xxxxxxxxx> wrote: > > The UPDATE statement when multiple tables are involved always drives me nuts. > I think what you need to do is remove all of the "old." from the SET clause and use "triple." in the WHERE clause instead of "old." - and remove the old table alias from the UPDATE. This worked. Thanks very much -- Andy -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
