Re: [HACKERS] SQL syntax (column alias)

[Joe Conway]

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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster