Joe Conway <[EMAIL PROTECTED]> quotes:
> 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 ambiguiti
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
On Sun, 2002-11-10 at 10:41, snpe wrote:
> Hello,
> Query :
>
> select id i
> from tab
>
> don't work in PostgreSQL
>
> I know that
>
> select id as i
> from tab
>
> work, but I think that AS in 'as cluse' is optional
Thats true. Section 7.11 has i