Received: from druid.net (root@druid.net [198.96.119.226]) by hub.org (8.8.8/8.7.5) with SMTP id HAA28077 for ; Tue, 4 Aug 1998 07:12:21 -0400 (EDT) Received: from localhost (1782 bytes) by druid.net via sendmail with P:stdio/R:inet_hosts/T:smtp (sender: ) (ident using unix) id for ; Tue, 4 Aug 1998 07:12:19 -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: Tue, 4 Aug 1998 07:12:19 -0400 (EDT) Cc: pgsql-sql@postgreSQL.org In-Reply-To: <81Aug2.122437edt.35713@gateway.lee.k12.nc.us> from "James Olin Oden" at Aug 03, 1998 01:35:17 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 > > 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 ... > > > > OK, I get that, but what if you want to say: > > SELECT table1.custnum, table1.name, table2.invoicenum from table1, table2 > > WHERE table1.custnum = table2.custnum; > > and without using the AS clause table1.custnum is pointing to table1.oid? > The idea is in perhaps the creation of the table to do something like the AS > clause, so that I don't have to "know" later that custnum (the key field) is > actually the oid column. The end result with this is to hide the > implementation details of the database from those querying it. I might be > really reaching, but it would be nice if something like this is a > available...james I don't think so. Better use a sequence instead. You shouldn't be using OID as a key anyway. You lose the value if you dump and reload. -- 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.