Re: SQL syntax (column alias)

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 it as optional

<derived column> ::= <value expression> [ <as clause> ]
<as clause> ::= [ AS ] <column name>


But this isn't going to be very nice to fix.

conflicts:  1378 shift/reduce, 44 reduce/reduce

--  Rod Taylor