Received: from druid.net (root@druid.net [198.96.119.226]) by hub.org (8.8.8/8.7.5) with SMTP id NAA13033 for ; Mon, 3 Aug 1998 13:17:24 -0400 (EDT) Received: from localhost (940 bytes) by druid.net via sendmail with P:stdio/R:inet_hosts/T:smtp (sender: ) (ident using unix) id for ; Mon, 3 Aug 1998 13:17:16 -0400 (EDT) (Smail-3.2.0.101 1997-Dec-17 #1 built 1998-Jul-20) Message-Id: From: darcy@druid.net (D'Arcy J.M. Cain) Subject: Re: [SQL] can a column be aliased? To: joden@lee.k12.nc.us (James Olin Oden) Date: Mon, 3 Aug 1998 13:17:15 -0400 (EDT) Cc: pgsql-sql@postgreSQL.org In-Reply-To: <81Aug2.105331edt.35713@gateway.lee.k12.nc.us> from "James Olin Oden" at Aug 03, 1998 12:04:04 PM X-Mailer: ELM [version 2.5 PL0b1] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 | 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.