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