Received: from druid.net (root@druid.net [198.96.119.226]) by hub.org (8.8.8/8.7.5) with SMTP id HAA29789 for ; Tue, 4 Aug 1998 07:38:14 -0400 (EDT) Received: from localhost (1607 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:38:08 -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: raanders@altoplanos.net (Roderick A. Anderson) Date: Tue, 4 Aug 1998 07:38:08 -0400 (EDT) Cc: pgsql-sql@postgreSQL.org In-Reply-To: from "Roderick A. Anderson" at Aug 03, 1998 11:56:07 AM X-Mailer: ELM [version 2.5 PL0b1] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Thus spake Roderick A. Anderson > > 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 Yes it is. > background I used > > select table1.oid custnum, > table2.oid salesman > from ... This is accepted by the standard as well but doesn't seem to be accepted by PostgreSQL. Does Oracle accept AS? [ { ::= | ::= [ ] ::= [ AS ] -- 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.