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