X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id A5FF69FB300 for ; Tue, 22 Aug 2006 22:40:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 36137-01 for ; Wed, 23 Aug 2006 01:40:15 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from relais.videotron.ca (relais.videotron.ca [24.201.245.36]) by postgresql.org (Postfix) with ESMTP id 89A799FB2B6 for ; Tue, 22 Aug 2006 22:40:15 -0300 (ADT) Received: from tedy ([66.130.229.163]) by VL-MO-MR002.ip.videotron.ca (Sun Java System Messaging Server 6.2-2.05 (built Apr 28 2005)) with ESMTP id <0J4F00FJXGN2GXD0@VL-MO-MR002.ip.videotron.ca> for pgsql-sql@postgresql.org; Tue, 22 Aug 2006 21:40:14 -0400 (EDT) Date: Tue, 22 Aug 2006 21:40:03 -0400 From: Daniel CAUNE Subject: SQL92 compliance To: pgsql-sql@postgresql.org Message-id: <000301c6c655$0e3a0100$0b00a8c0@tedy> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-Mailer: Microsoft Office Outlook 11 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT Thread-index: AcbGVQ4T3hO4K8ahQfG4Fz7k9OI2PA== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.816 tagged_above=0 required=5 tests=SPF_HELO_SOFTFAIL, SPF_SOFTFAIL X-Spam-Level: *** X-Archive-Number: 200608/157 X-Sequence-Number: 26115 Hi, Is AS in "SELECT my_column AS my_name FROM my_table" mandatory to be SQL92 compliant? PostgreSQL requires this keyword by default when defining alias, which might be good thing. I mean, I would prefer being notified from a syntax error than spending a couple of hours wondering why a client application, at the end of a several data marshalling processes, doesn't get the right data... For instance MySQL doesn't require it and sometimes that sucks: SELECT my_column1 my_column2, my_column3 FROM my_table Regards, -- Daniel