From 1fd0eee66f1e74d6a547d860a9f5d51a2277bb02 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Tue, 31 Mar 2020 16:31:44 -0400 Subject: doc: adjust UPDATE/DELETE's FROM/USING to match SELECT's FROM Previously the syntax and wording were unclear. Reported-by: Alexey Bashtanov Discussion: https://postgr.es/m/968d4724-8e58-788f-7c45-f7b1813824cc@imap.cc Backpatch-through: 9.5 --- doc/src/sgml/ref/delete.sgml | 20 ++++++++++---------- 1 file changed, 10 insertions(+), 10 deletions(-) (limited to 'doc/src/sgml/ref/delete.sgml') diff --git a/doc/src/sgml/ref/delete.sgml b/doc/src/sgml/ref/delete.sgml index df8cea48cf4..08fb032b505 100644 --- a/doc/src/sgml/ref/delete.sgml +++ b/doc/src/sgml/ref/delete.sgml @@ -23,7 +23,7 @@ PostgreSQL documentation [ WITH [ RECURSIVE ] with_query [, ...] ] DELETE FROM [ ONLY ] table_name [ * ] [ [ AS ] alias ] - [ USING using_list ] + [ USING from_item [, ...] ] [ WHERE condition | WHERE CURRENT OF cursor_name ] [ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ] @@ -117,17 +117,17 @@ DELETE FROM [ ONLY ] table_name [ * - using_list + from_item - A list of table expressions, allowing columns from other tables - to appear in the WHERE condition. This is similar - to the list of tables that can be specified in the of a - SELECT statement; for example, an alias for - the table name can be specified. Do not repeat the target table - in the using_list, - unless you wish to set up a self-join. + A table expression allowing columns from other tables to appear + in the WHERE condition. This uses the same + syntax as the + of a SELECT statement; for example, an alias + for the table name can be specified. Do not repeat the target + table as a from_item + unless you wish to set up a self-join (in which case it must appear + with an alias in the from_item). -- cgit v1.2.3