When to use USING on DELETE could use more clarity

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: eric+postgresql(dot)org(at)tinnaeus(dot)com
Subject: When to use USING on DELETE could use more clarity
Date: 2025-02-07 17:23:12
Message-ID: 173894899293.1067.15761499536160191279@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/17/sql-delete.html
Description:

Referring to this page of the docs:
https://www.postgresql.org/docs/current/sql-delete.html

This comment is at the bottom of the Notes section:
"In some cases the join style is easier to write or faster to execute
than the sub-select style."

Feedback:
1. Nitpicky: Given the flow of this section, I'd suggest replacing the words
"the join style" with "the USING style" to help with clarity for newbies.
2. Far more importantly: I'm sure this comment is true and accurate, but "In
some cases" doesn't tell me much. I've actually come to this page
specifically in search of that information, and it isn't here. In which
cases would my code operate better with USING than with a sub-select? I
assume there must be a reason USING was created as a non-standard extension
feature just for Postgres, but what is that reason?

Thanks!
Eric

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2025-02-07 17:41:46 Re: timestamp with time zone ~> GMT
Previous Message Miłosz Chmura 2025-02-07 16:56:41 Re: Minor suggestions for docs regarding json_table