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 09:06:26AM -0400, William McKee wrote:
> 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. 

With MySQL in 'AS' is optional too.

I think I'll just remove it, unless someone can point me to a database
where it's mandatory, and then we'll need to factor something out that
can be overridden.

Tony