From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | vincent(dot)moreau(at)adeoservices(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Mandatory AS keyword in SELECT statements |
Date: | 2008-01-04 14:31:41 |
Message-ID: | 200801041431.m04EVfT11927@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
vincent(dot)moreau(at)adeoservices(dot)com wrote:
> Hi,
>
> We are currently trying to migrate an Oracle database to PostgreSQL.
> Unfortunately, the Java application that access the database does not
> use the AS keyword to alias column names in select statements.
>
> Thus, the following statement "SELECT col1 alias1 FROM any_table" fails.
>
> AFAIK, AS is optional according to SQL Standard.
> Is there a way to workaround this behaviour, as it will be not possible
> for us to modify the application ?
> Is there a plan to support this in future PostgreSQL releases ?
>
> I apologize in advance if this question has already been submited, I was
> not able to find some threads discussing this point.
Unfortunately, this is on our TODO list as something we are not planning
to do:
* Allow AS in "SELECT col AS label" to be optional (not wanted)
Because we support postfix operators, it isn't possible to make AS
optional and continue to use bison.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2008-01-04 14:33:55 | Re: Using syslog on pg for Windows |
Previous Message | Martijn van Oosterhout | 2008-01-04 14:29:47 | Re: How to handle 'not a number' in postgresql |