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 B97D09FB3BA for ; Wed, 23 Aug 2006 13:11:53 -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 04405-03 for ; Wed, 23 Aug 2006 13:11:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from gauss.credativ.com (ipx11302.ipxserver.de [212.112.227.254]) by postgresql.org (Postfix) with ESMTP id 253C79FB3B6 for ; Wed, 23 Aug 2006 13:11:52 -0300 (ADT) Received: from bell.credativ.de (p50895387.dip.t-dialin.net [80.137.83.135]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id 5423BD791B; Wed, 23 Aug 2006 18:11:51 +0200 (CEST) From: Peter Eisentraut To: pgsql-sql@postgresql.org Subject: Re: SQL92 compliance Date: Wed, 23 Aug 2006 18:11:47 +0200 User-Agent: KMail/1.9.3 Cc: Daniel CAUNE References: <000301c6c655$0e3a0100$0b00a8c0@tedy> In-Reply-To: <000301c6c655$0e3a0100$0b00a8c0@tedy> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200608231811.48538.peter_e@gmx.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200608/164 X-Sequence-Number: 26122 Am Mittwoch, 23. August 2006 03:40 schrieb Daniel CAUNE: > Is AS in "SELECT my_column AS my_name FROM my_table" mandatory to be SQL92 > compliant? No. I have a patch at that fixes this at least for 7.4. I don't think it works for newer versions, but it should give you an idea what is required to get it working. -- Peter Eisentraut http://developer.postgresql.org/~petere/