Postgres Pro
Downloads
Home   >   mailing lists

Re: DELETE ... USING LATERAL - Mailing list pgsql-general

From Michael Lewis
Subject Re: DELETE ... USING LATERAL
Date
Msg-id CAHOFxGrtOqV_CdyZktPSFHKnom3jscF_YTGdZRmmQ_7weARJQw@mail.gmail.com
Whole thread Raw
In response to DELETE ... USING LATERAL  (Nikhil Benesch <nikhil.benesch@gmail.com>)
Responses Re: DELETE ... USING LATERAL
List pgsql-general
Tree view
On Mon, Oct 4, 2021, 10:30 AM Nikhil Benesch <nikhil.benesch@gmail.com> wrote:
you can't reuse the FROM table name in the USING clause:

    # 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?

pgsql-general by date:

Previous
From: Nikhil Benesch
Date:
Subject: Re: DELETE ... USING LATERAL
Next
From: Tom Lane
Date:
Subject: Re: DELETE ... USING LATERAL