Re: [GENERAL] Fields re-ordered on JOIN with * and USING

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [GENERAL] Fields re-ordered on JOIN with * and USING
Дата
Msg-id CAKFQuwaKJMgOoG32B8Mbdbn7kY1pOFV8kkHH5WozCF4DXrqZjw@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Fields re-ordered on JOIN with * and USING  (Ken Tanzer <ken.tanzer@gmail.com>)
Ответы Re: [GENERAL] Fields re-ordered on JOIN with * and USING  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [GENERAL] Fields re-ordered on JOIN with * and USING  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Fri, Sep 1, 2017 at 2:25 PM, Ken Tanzer <ken.tanzer@gmail.com> wrote:
Hi.  I recently noticed that when doing a SELECT * with USING, that the join field(s) appear first in the output.  I'd never noticed that before, and was just curious if that is expected behavior or not.  Thanks.
  
​I don't recall if or where it is documented but it is intentional., as is the documented fact that only one instance of the named column appears in the output.

David J.

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] Strange SQL result - any ideas.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] Fields re-ordered on JOIN with * and USING