public inbox for [email protected]
help / color / mirror / Atom feedFrom: Amir Rohan <[email protected]>
To: David G. Johnston <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Docs claim that "select myTable.*" wildcard won't let you assign column names
Date: Tue, 22 Sep 2015 21:40:58 +0200
Message-ID: <trinity-e197b2d0-4ada-493c-a0a5-85e7784d9b1f-1442950858486@3capp-mailcom-lxa05> (raw)
In-Reply-To: <CAKFQuwagxbGTVji92nQ5a10u8gPK2THwG55Zh3yy-MYRCa=9dA@mail.gmail.com>
References: <trinity-f7a55438-da76-471a-8b06-b5446f01918b-1442875052542@3capp-mailcom-lxa10>
<CAKFQuwb1pTAh3gGzReSnUAoSobYQmHhy-90rKo82BeVCR7W+Kw@mail.gmail.com>
<trinity-ff5523c7-87b0-4409-ab20-83a3b5b172f8-1442883892582@3capp-mailcom-lxa13>
<CAKFQuwagxbGTVji92nQ5a10u8gPK2THwG55Zh3yy-MYRCa=9dA@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>
On Monday, September 21, 2015, David G. Johnston wrote:
>To be honest, if you have a situation where you think you need to alias "*"
>you should probably be expanding that "*" out into individual column names
>anyway, which you can easily alias.
>
That depends. If my table has 30 columns and I just need to rename
the first couple, then I probably would find that advice unreasonable.
>The docs don't make a big deal of alising other than noting individually
>where they can happen (cte, from clause, select-list) and few questions
>that are raised are probably better served to be simply handled on these
>lists than cluttering the docs.
What constitutes "clutter", or what is "obvious", really depends on who is
making the assertion. A pg veteran's views probably don't mirrort those of the
person you'd typically find actually reading the docs, trying to figure out how
to write the query they want.
But yeah, the pg documentation isn't the best resource to pick up SQL from
(nor is is their purpose), and no patch I'd submit would really change that.
So, we're done.
Amir
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
view thread (6+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Docs claim that "select myTable.*" wildcard won't let you assign column names
In-Reply-To: <trinity-e197b2d0-4ada-493c-a0a5-85e7784d9b1f-1442950858486@3capp-mailcom-lxa05>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox