syntax for updating an aliased table - Mailing list pgsql-general

update triple old

                           set

                              old.obln = new.obln,  old.ointv = new.ointv,  old.otime = new.otime,  old.oflt = new.oflt,  old.ostr = new.ostr,  old.oint = new.oint,  old.oda = new.oda,  old.uasid = new.uasid

                           from triple_update as new

                          where (old.s = new.s and

                                 old.g = new.g) and

                                ( old.obln <> new.obln or  old.ointv <> new.ointv or  old.otime <> new.otime or  old.oflt <> new.oflt or  old.ostr <> new.ostr or  old.oint <> new.oint or  old.oda <> new.oda or  old.uasid <> new.uasid)