Re: Small docs bugfix: make it clear what can be used in UPDATE FROM and DELETE USING

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Small docs bugfix: make it clear what can be used in UPDATE FROM and DELETE USING
Дата
Msg-id 7354.1584500334@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Small docs bugfix: make it clear what can be used in UPDATE FROMand DELETE USING  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Small docs bugfix: make it clear what can be used in UPDATE FROMand DELETE USING  (Bruce Momjian <bruce@momjian.us>)
Список 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 по дате отправления:

Предыдущее
От: Andy Fan
Дата:
Сообщение: Re: [PATCH] Erase the distinctClause if the result is unique by definition
Следующее
От: Amit Langote
Дата:
Сообщение: Re: adding partitioned tables to publications