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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Fields re-ordered on JOIN with * and USING
Date: 2017-09-02 00:19:09
Message-ID: CAKFQuwaKJMgOoG32B8Mbdbn7kY1pOFV8kkHH5WozCF4DXrqZjw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2017-09-02 01:04:30 Re: Fields re-ordered on JOIN with * and USING
Previous Message Tom Lane 2017-09-01 23:01:42 Re: Strange SQL result - any ideas.