Re: [GENERAL] Mandatory AS keyword in SELECT statements

2008-01-04 Thread Martijn van Oosterhout
On Fri, Jan 04, 2008 at 09:31:41AM -0500, Bruce Momjian wrote: > 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 possi

Re: [GENERAL] Mandatory AS keyword in SELECT statements

2008-01-04 Thread Bruce Momjian
Martijn van Oosterhout wrote: -- Start of PGP signed section. > On Fri, Jan 04, 2008 at 09:31:41AM -0500, Bruce Momjian wrote: > > 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) > >

Re: [GENERAL] Mandatory AS keyword in SELECT statements

2008-01-04 Thread Bruce Momjian
[EMAIL PROTECTED] 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 F

[GENERAL] Mandatory AS keyword in SELECT statements

2008-01-04 Thread vincent.moreau
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 o