| From: | Nikhil Benesch <nikhil(dot)benesch(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: DELETE ... USING LATERAL |
| Date: | 2021-10-04 18:36:16 |
| Message-ID: | CAPWqQZSDUzGHNY--S+ULykJv2T2CbA5LavVT+a+NnjdeNB385A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Oct 4, 2021 at 1:48 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> My mental model of these things is that the target table is cross-joined
> to the additional tables as though by a comma in FROM [...]
Mine as well.
I just managed to dredge up some history here though. Turns out you
explicitly disabled this feature for 9.4 to make room for a future
feature to allow left-joining the target table [0]. Is support for
that feature still desired/planned? (If it's been permanently
abandoned for whatever reason, then maybe it's safe just to revert
158b7fa?)
[0]: https://github.com/postgres/postgres/commit/158b7fa6a34006bdc70b515e14e120d3e896589b
Nikhil
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Lewis | 2021-10-04 19:03:15 | Re: DELETE ... USING LATERAL |
| Previous Message | Tom Lane | 2021-10-04 17:48:39 | Re: DELETE ... USING LATERAL |