Re: Small docs bugfix: make it clear what can be used in UPDATE FROM and DELETE USING - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Small docs bugfix: make it clear what can be used in UPDATE FROM and DELETE USING
Date
Msg-id 7354.1584500334@sss.pgh.pa.us
Whole thread Raw
In response to Re: Small docs bugfix: make it clear what can be used in UPDATE FROMand DELETE USING  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Small docs bugfix: make it clear what can be used in UPDATE FROMand DELETE USING  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> I have implemented the ideas above in the attached patch.  I have
> synchronized the syntax to match SELECT, and synchronized the paragraphs
> describing the item.

I think that the DELETE synopsis should look like

    [ USING <replaceable class="parameter">from_item</replaceable> [, ...] ]

so that there's not any question which part of the SELECT syntax we're
talking about.  I also think that the running text in both cases should
say in exactly these words "from_item means the same thing as it does
in SELECT"; the wording you propose still seems to be dancing around
the point, leaving readers perhaps not quite sure about what is meant.

In the DELETE case you could alternatively say "using_item means the same
thing as from_item does in SELECT", but that doesn't really seem like an
improvement to me.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Andy Fan
Date:
Subject: Re: [PATCH] Erase the distinctClause if the result is unique by definition
Next
From: Amit Langote
Date:
Subject: Re: adding partitioned tables to publications