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