Michael Lewis <mlewis@xxxxxxxxxxx> writes: > On Mon, Oct 4, 2021, 10:30 AM Nikhil Benesch <nikhil.benesch@xxxxxxxxx> > wrote: >> # delete from int_arrays using int_arrays; >> ERROR: table name "int_arrays" specified more than once >> Don't you need to use an alias for the table in the using clause? You could, but then you'd be creating a self-join on the target table (and would need to add suitable WHERE clauses to constrain that join). This might be the best near-term workaround, but it does seem ugly and inefficient. regards, tom lane
