| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | Amir Rohan <amir(dot)rohan(at)mail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | "pgsql-docs(at)postgresql(dot)org" <pgsql-docs(at)postgresql(dot)org> |
| Subject: | Re: Docs claim that "select myTable.*" wildcard won't let you assign column names |
| Date: | 2015-09-22 01:32:16 |
| Message-ID: | 5600AFA0.8090809@joeconway.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2015-09-22 01:58:58 | Re: Docs claim that "select myTable.*" wildcard won't let you assign column names |
| Previous Message | Amir Rohan | 2015-09-22 01:04:53 | Re: Docs claim that "select myTable.*" wildcard won't let you assign column names |