Re: [firebird-support] Table alias with AS in SELECT statement supported?

[Helen Borrie]

At 06:24 PM 18/10/2011, reinier_olislagers wrote:
Hi all,

The Interbase 6 Language Reference mentions column aliases using the AS
notation, but doesn't show AS in table aliases, e.g.
select * from rdb$relations tables

On Firebird 2.5, this seems to work fine:
select * from rdb$relations as tables;

I had a look through the Firebird 2.5 Language Reference Update (8
October 2011, version 1.1, covers Firebird 2.5 and 2.5.1).
It doesn't seem to say anything about using AS for table aliases in
SELECT statements.

Have I overlooked something, was it already supported in Interbase 6, or
do the docs need updating?

Much simpler than that, actually.  AS is an optional keyword, just that most 
people don't bother to use it.

./heLen

Re: [firebird-support] Table alias with AS in SELECT statement supported?

[Paul Vinkenoog]

Hello Reinier,

 The Interbase 6 Language Reference mentions column aliases using the AS
 notation, but doesn't show AS in table aliases, e.g.

(...)

 Have I overlooked something, was it already supported in Interbase 6, or
 do the docs need updating?

The InterBase 6 LangRef needs updating ;-)

Frankly, I never noticed that the optional [AS] for table aliases was missing 
from the IB6 docs. Now that I know, I'll mention it in the next revision of the 
LangRef Update.


Kind regards,
Paul Vinkenoog