Re: Mandatory AS keyword in SELECT statements

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. +