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