Received: from altoplanos.net (raanders@asgard.altoplanos.net [207.170.216.2]) by hub.org (8.8.8/8.7.5) with ESMTP id OAA20983 for ; Mon, 3 Aug 1998 14:52:42 -0400 (EDT) Received: from localhost (raanders@localhost) by altoplanos.net (8.8.5/8.8.5) with SMTP id LAA26323; Mon, 3 Aug 1998 11:56:07 -0700 Date: Mon, 3 Aug 1998 11:56:07 -0700 (PDT) From: "Roderick A. Anderson" To: "D'Arcy J.M. Cain" cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] can a column be aliased? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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@altoplanos.net Altoplanos Information Systems, Inc. Voice: 208.765.6149 212 S. 11th Street, Suite 5 FAX: 208.664.5299 Coeur d'Alene, ID 83814