Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 579479FB8F0 for ; Thu, 12 Jul 2007 14:23:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 22957-02-3 for ; Thu, 12 Jul 2007 14:23:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id ED00A9FB985 for ; Thu, 12 Jul 2007 14:23:17 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l6CHN0fB000635; Thu, 12 Jul 2007 13:23:00 -0400 (EDT) To: chester c young cc: Joel Richard , sql pgsql Subject: Re: Converting from MS Access field aliases In-reply-to: <746273.93291.qm@web54305.mail.re2.yahoo.com> References: <746273.93291.qm@web54305.mail.re2.yahoo.com> Comments: In-reply-to chester c young message dated "Thu, 12 Jul 2007 09:36:50 -0700" Date: Thu, 12 Jul 2007 13:23:00 -0400 Message-ID: <634.1184260980@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/68 X-Sequence-Number: 28803 chester c young 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. regards, tom lane