DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:subject:from:reply-to:to:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding;
	b=d5GDAQUzcDXSI26gInfbHsX/kBSon+497NswDcNBrLH4Y5d6izeNAElPiV9QJBYfGNJPGbOOC1OgSR6Yn5nb0Dop2x5s2iUs35vPaihSyrm5G/L+xGHRiUx4wC+brZ886oSq+b2bcuNcvLufVFxLf0qInZQIN3edKs3CtQmn4Gg=
Subject: Re: Converting from MS Access field aliases
From: Adam Tauno Williams <adamtaunowilliams@gmail.com>
Reply-To: adamtaunowilliams@gmail.com
To: sql pgsql <pgsql-sql@postgresql.org>
In-Reply-To: <634.1184260980@sss.pgh.pa.us>
References: <746273.93291.qm@web54305.mail.re2.yahoo.com>
	<634.1184260980@sss.pgh.pa.us>
Content-Type: text/plain
Date: Thu, 12 Jul 2007 16:34:10 -0400
Message-Id: <1184272450.4427.35.camel@aleph.whitemice.org>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

On Thu, 2007-07-12 at 13:23 -0400, Tom Lane wrote:
> chester c young <chestercyoung@yahoo.com> writes:
> >> SELECT field1 / 2 AS foo,
> >> field2 * 2 AS bar,
> >> foo + bar AS total
> >> WHERE foo < 12;
> > First, I think it would be great if this worked - like the alias to an
> > update table added in 8.2  - saves a lot of typing and makes queries
> > much more readable.
> This is not an "extension", it is *directly* contrary to both the letter
> and spirit of the SQL standard.  I can hardly believe that M$ did that
> ... oh, actually, I can entirely believe it.  The OP has a serious
> problem of vendor lockin now, and that's exactly what M$ wants.

"AS" works in Informix, and I believe, in DB2 as well.  So it is at
least pretty common;  I'm not saying it is correct.  Since Informix
predates M$-SQL they at least didn't invent it.