Postgres Pro
Downloads
Home   >   mailing lists

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

From darcy@druid.net (D'Arcy J.M. Cain)
Subject Re: [SQL] can a column be aliased?
Date
Msg-id m0z3OEW-00006FC@druid.net
Whole thread Raw
In response to can a column be aliased?  (James Olin Oden <joden@lee.k12.nc.us>)
Responses Re: [SQL] can a column be aliased?  ("Roderick A. Anderson" <raanders@altoplanos.net>)
List pgsql-sql
Tree view 
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 ...

--
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 424 2871     (DoD#0082)    (eNTP)   |  what's for dinner.

pgsql-sql by date:

Previous
From: Thomas Good
Date:
Subject: subqueries v. joins (locked my keys in the car)
Next
From: James Olin Oden
Date:
Subject: Re: [SQL] can a column be aliased?