Re: SQL syntax (column alias)

snpe wrote:
> work, but I think that AS in 'as cluse' is optional
> 
> Please comment.

See:  http://developer.postgresql.org/docs/postgres/sql-select.html


Near the bottom:

" SQL92

SELECT Clause

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

Joe