Re: [SQL] can a column be aliased?

From: darcy(at)druid(dot)net (D'Arcy J(dot)M(dot) Cain)
To: joden(at)lee(dot)k12(dot)nc(dot)us (James Olin Oden)
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] can a column be aliased?
Date: 1998-08-03 17:17:15
Message-ID: m0z3OEW-00006FC@druid.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at){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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message M Simms 1998-08-03 17:35:02 Low level socket locking...
Previous Message Thomas Good 1998-08-03 16:52:41 subqueries v. joins (locked my keys in the car)