From: | Michael Glaesemann <grzm(at)seespotcode(dot)net> |
---|---|
To: | Daniel CAUNE <d(dot)caune(at)free(dot)fr> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: SQL92 compliance |
Date: | 2006-08-23 01:54:38 |
Message-ID: | A7421249-2D3B-4AE2-AB53-A23C6C678026@seespotcode.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Osvaldo Kussama | 2006-08-23 02:03:51 | Re: error with mor than 1 sub-select |
Previous Message | chrisj | 2006-08-23 01:47:51 | error with mor than 1 sub-select |