Re: [HACKERS] SQL syntax (column alias)

2002-11-10 Thread Tom Lane
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

Re: [HACKERS] SQL syntax (column alias)

2002-11-10 Thread 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

Re: [HACKERS] SQL syntax (column alias)

2002-11-10 Thread Rod Taylor
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