Re: Aliases for Field Names in SELECT statements

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pdxpug(at)postgresql(dot)org
Subject: Re: Aliases for Field Names in SELECT statements
Date: 2008-01-04 18:11:00
Message-ID: Pine.LNX.4.64.0801041010220.5706@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pdxpug

On Fri, 4 Jan 2008, Randal L. Schwartz wrote:

> The problem is the optional "AS" keyword. Other SQLs permit:
>
> SELECT foo bar FROM atable;
>
> to mean
>
> SELECT foo AS bar FROM atable;

Thank you. That clarifies the situation completely.

Rich

--
Richard B. Shepard, Ph.D. | Integrity Credibility
Applied Ecosystem Services, Inc. | Innovation
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863

In response to

Browse pdxpug by date

  From Date Subject
Next Message Hu, William 2008-01-04 18:31:23 Re: your Survey
Previous Message Roth, Gabrielle 2008-01-04 17:37:24 Re: Aliases for Field Names in SELECT statements