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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to