Robert Treat <xzilla@users.sourceforge.net> writes:
> AFAIR this is still the only way to do updates on joined tables, a feature
> that IIRC is in the sql spec (and certianly in other rdbms') that we do not
> support.
I think you're wrong on both counts --- we do support UPDATE FROM, and
it's not in the spec.
What we don't have is an equivalent syntax for DELETE, and you're right
that we probably ought to offer that before we deprecate add_missing_from.
regards, tom lane
