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

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Fri, Sep 1, 2017 at 2:25 PM, Ken Tanzer <ken.tanzer@xxxxxxxxx> 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.