Re: DELETE ... USING LATERAL

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Nikhil Benesch <nikhil(dot)benesch(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: DELETE ... USING LATERAL
Date: 2021-10-04 19:03:15
Message-ID: CAHOFxGrtOqV_CdyZktPSFHKnom3jscF_YTGdZRmmQ_7weARJQw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Oct 4, 2021, 10:30 AM Nikhil Benesch <nikhil(dot)benesch(at)gmail(dot)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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2021-10-04 19:21:18 Re: DELETE ... USING LATERAL
Previous Message Nikhil Benesch 2021-10-04 18:36:16 Re: DELETE ... USING LATERAL