Re: 1 cset was pushed to core/stable: bug 1575 - Oracle installation (not supp...

Jason Judge wrote:
> "Michel Dalle" <mikespub-111RdWWlOxkOkXtL6OYfHgC/[email protected]> wrote in message
> news:[email protected]...
> 
>>Changes were applied by mikespub to core/stable level 10.
>>    The following cset was applied:
>>
>>    ChangeSet
>>      1.2052 05/03/05 18:15:13 [email protected] +12 -0
>>      bug 1575 - Oracle installation (not supported)
> 
> 
> With the 'AS' missing from the table aliases, isn't this going to cause
> problems for Postgres?
> 
http://www.postgresql.org/docs/current/static/sql-select.html

The AS Key Word

In the SQL standard, the optional key word AS is just noise and can be 
omitted without affecting the meaning. The PostgreSQL parser requires 
this key word when renaming output columns because the type 
extensibility features lead to parsing ambiguities without it. AS is 
optional in FROM items, however.


In other words, you need it for column aliases, but it's optional
(= noise) for table aliases - same as for MySQL. And since Oracle
doesn't like the AS in table aliases at all, it's easiest to get
rid of it altogether there :-)

Mike.