On Aug 23, 2006, at 10:40 , Daniel CAUNE wrote:
Hi,
Is AS in "SELECT my_column AS my_name FROM my_table" mandatory to
be SQL92
compliant?
You can find this in the documentation:
http://www.postgresql.org/docs/8.1/interactive/sql-select.html#AEN48391
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.
Hope this helps.
Michael Glaesemann
grzm seespotcode net
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
