Re: SQL92 compliance

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