Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Fields re-ordered on JOIN with * and USING - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] Fields re-ordered on JOIN with * and USING
Date
Msg-id CAKFQuwaKJMgOoG32B8Mbdbn7kY1pOFV8kkHH5WozCF4DXrqZjw@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Fields re-ordered on JOIN with * and USING  (Ken Tanzer <ken.tanzer@gmail.com>)
Responses 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>)
List pgsql-general
Tree view
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Strange SQL result - any ideas.
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Fields re-ordered on JOIN with * and USING