Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id E41F32E379D for ; Thu, 10 Jan 2008 03:39:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 36813-05 for ; Thu, 10 Jan 2008 03:39:52 -0400 (AST) Received: from www01.kensystem.com (www01.kensystem.com [72.19.170.120]) by postgresql.org (Postfix) with ESMTP id 36CBC2E34E6 for ; Thu, 10 Jan 2008 03:39:52 -0400 (AST) Received: from 192.168.0.3 by www01.kensystem.com (SMTPD); id s20080110003949.45449; Thu, 10 Jan 2008 00:39:49 Message-ID: <4785CBE9.6000108@kensystem.com> Date: Thu, 10 Jan 2008 00:40:25 -0700 From: Ken Johanson User-Agent: Thunderbird 1.5.0.14 (Windows/20071210) MIME-Version: 1.0 To: Paul Lambert CC: pgsql-sql@postgresql.org Subject: Re: Shorthand column labels (SELECT col1 foo, ...) vs (SELECT col1 AS foo, ...) References: <4785C50F.6010505@kensystem.com> <4785C744.6080406@optusnet.com.au> In-Reply-To: <4785C744.6080406@optusnet.com.au> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/64 X-Sequence-Number: 29917 Paul Lambert wrote: > Ken Johanson wrote: >> I notice PG doesn't allow shorthand column labels -- it requires the >> 'AS' operand. >> >> SELECT col1 foo, ...; -> ERROR: syntax error at or near "foo" > > Briefly discussed a couple of weeks ago. > > See http://archives.postgresql.org/pgsql-general/2008-01/msg00089.php > Interesting thread(s)! What I didn't see discussed was the possibility of making a server and/or session option, where we could elect to turn-off the old behavior (PG specific behavior) and enable the standard/shorthand syntax. Users need a migration path. I personally cant ever see using those PGisms/features and would choose to enable the standard mode. I think I'd have fewer compatibility problems. Ken