Re: [SQL] can a column be aliased? - Mailing list pgsql-sql

On Mon, 3 Aug 1998, D'Arcy J.M. Cain wrote:

> Thus spake James Olin Oden
> > I know this is probably a strange question, but can you give a column
> > name an alias?  The reason I ask is because I have recently realized I
>
> SELECT table1.oid AS custnum, table2.oid AS salesman FROM ...
>

Hot as flame bait, but is the AS a SQL92 standard?  Coming from an Oracle
background I used

   select table1.oid custnum,
          table2.oid salesman
     from ...

TIA,
Rod
--
Roderick A. Anderson
raanders@altoplanos.net               Altoplanos Information Systems, Inc.
Voice: 208.765.6149                            212 S. 11th Street, Suite 5
FAX: 208.664.5299                                  Coeur d'Alene, ID 83814