X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7870C9FB2B6 for ; Tue, 22 Aug 2006 22:54:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 32186-03 for ; Tue, 22 Aug 2006 22:54:49 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from grzm.com (grzm.com [200.46.204.98]) by postgresql.org (Postfix) with ESMTP id EFB3E9FB233 for ; Tue, 22 Aug 2006 22:54:48 -0300 (ADT) Received: from localhost (unknown [200.46.208.251]) by grzm.com (Postfix) with ESMTP id AFA0A127E108 for ; Wed, 23 Aug 2006 02:54:42 +0100 (BST) Received: from grzm.com ([200.46.204.98]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 32170-03; Tue, 22 Aug 2006 22:54:44 -0300 (ADT) Received: from [172.16.1.101] (unknown [61.197.227.146]) by grzm.com (Postfix) with ESMTP id 831CE127C4ED; Wed, 23 Aug 2006 02:54:37 +0100 (BST) In-Reply-To: <000301c6c655$0e3a0100$0b00a8c0@tedy> References: <000301c6c655$0e3a0100$0b00a8c0@tedy> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: pgsql-sql@postgresql.org Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: SQL92 compliance Date: Wed, 23 Aug 2006 10:54:38 +0900 To: Daniel CAUNE X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.08 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200608/159 X-Sequence-Number: 26117 On Aug 23, 2006, at 10:40 , Daniel CAUNE wrote: > Hi, > > Is AS in "SELECT my_column AS my_name FROM my_table" mandatory to > be SQL92 > compliant? You can find this in the documentation: http://www.postgresql.org/docs/8.1/interactive/sql-select.html#AEN48391 > The AS Key Word > > In the SQL standard, the optional key word AS is just noise and can > be omitted without affecting the meaning. The PostgreSQL parser > requires this key word when renaming output columns because the > type extensibility features lead to parsing ambiguities without it. > AS is optional in FROM items, however. Hope this helps. Michael Glaesemann grzm seespotcode net