public inbox for [email protected]  
help / color / mirror / Atom feed
From: Joe Conway <[email protected]>
To: 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: Mon, 21 Sep 2015 18:32:16 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <trinity-ff5523c7-87b0-4409-ab20-83a3b5b172f8-1442883892582@3capp-mailcom-lxa13>
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>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>

On 09/21/2015 06:04 PM, Amir Rohan wrote:
> This belongs in the page describing SELECT, and though I've looked I haven't found it. If I'm wrong (
> I did look again just now), please correct me.

Feel free to submit a doc patch if you feel it needs to be improved, but
it is mentioned here:

 http://www.postgresql.org/docs/9.4/interactive/sql-select.html#SQL-FROM

8<-----------
alias

    A substitute name for the FROM item [...] If an alias is written, a
column alias list can also be written to provide substitute names for
one or more columns of the table.
8<-----------

Joe

-- 
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development



Attachments:

  [application/pgp-signature] signature.asc (836B, 2-signature.asc)
  download

view thread (6+ messages)  latest in thread

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], [email protected]
  Subject: Re: Docs claim that "select myTable.*" wildcard won't let you assign column names
  In-Reply-To: <[email protected]>

* 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