| From: | "Roderick A(dot) Anderson" <raanders(at)altoplanos(dot)net> |
|---|---|
| To: | "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net> |
| Cc: | pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Re: [SQL] can a column be aliased? |
| Date: | 1998-08-03 18:56:07 |
| Message-ID: | Pine.LNX.3.95.980803115341.26293A-100000@altoplanos.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)altoplanos(dot)net Altoplanos Information Systems, Inc.
Voice: 208.765.6149 212 S. 11th Street, Suite 5
FAX: 208.664.5299 Coeur d'Alene, ID 83814
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Lynch | 1998-08-03 20:11:39 | Re: [SQL] locked my keys in the car |
| Previous Message | John Edstrom | 1998-08-03 18:54:31 | Re: [SQL] locked my keys in the car |