-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql: support DELETE FROM ... USING #40963
Copy link
Copy link
Closed
Labels
A-sql-pgcompatSemantic compatibility with PostgreSQLSemantic compatibility with PostgreSQLC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)E-quick-winLikely to be a quick win for someone experienced.Likely to be a quick win for someone experienced.T-sql-queriesSQL Queries TeamSQL Queries TeamX-anchored-telemetryThe issue number is anchored by telemetry references.The issue number is anchored by telemetry references.
Description
Add support for the USING clause on DELETE, which allows joining multiple tables for a DELETE clause.
This appears similar to #7841, which tracked adding joins to UPDATE.
https://www.postgresql.org/docs/10/sql-delete.html
Epic: CRDB-5498
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
A-sql-pgcompatSemantic compatibility with PostgreSQLSemantic compatibility with PostgreSQLC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)E-quick-winLikely to be a quick win for someone experienced.Likely to be a quick win for someone experienced.T-sql-queriesSQL Queries TeamSQL Queries TeamX-anchored-telemetryThe issue number is anchored by telemetry references.The issue number is anchored by telemetry references.
Type
Projects
Status
Done