On Thu, May 26, 2011 at 1:40 PM, Rick Genter <rick.gen...@gmail.com> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
