• Bruce Momjian's avatar
    Update DELETE FROM: · f7667e4c
    Bruce Momjian authored
    < * Allow DELETE to handle table aliases for self-joins
    > * Allow an alias to be provided for the target table in UPDATE/DELETE
    276,279c276,282
    <   There is no way to create a table alias for the deleted table for use
    <   in the DELETE WHERE clause.  The agreed approach is to allow a USING
    <   clause to specify additional tables.  UPDATE already has an optional
    <   FROM clause for this purpose.
    >   This is not SQL-spec but many DBMSs allow it.
    >
    > * Allow additional tables to be specified in DELETE for joins
    >
    >   UPDATE already allows this (UPDATE...FROM) but we need similar
    >   functionality in DELETE.  It's been agreed that the keyword should
    >   be USING, to avoid anything as confusing as DELETE FROM a FROM b.
    f7667e4c
TODO 30.5 KB