Re: BUG (incomaptibility) in sql fransformation of __TABLE(class=alias)__

[prev] [thread] [next] [Date index for 2004/07/06]

On Tue, Jul 06, 2004 at 11:56:20AM +0200, Adam Przygienda wrote:
> I'm not deeply familiar with SQL-ISO standard but according to Oracle
> specifications (and Oracle stuff is ISO certified), expression 'AS' my only
> be used to define column aliases but newer to define table aliases.

This email prompted me to check the PostgreSQL docs (v7.4) which say[1]:

    To create a table alias, write
    
    FROM table_reference AS alias
    
    or
    
    FROM table_reference alias
    
    The AS key word is noise. alias can be any identifier. 


[1]
http://www.postgresql.org/docs/7.4/interactive/queries-table-expressions.html

        -- 
        Knowmad Services Inc.
http://www.knowmad.com