Subject Re: [firebird-support] Reserved Words
Author Lester Caine
Helen Borrie wrote:

>>OK I have a pile of documents, but I've not as yet found a
>>definitive guide to the current list of 'reserved words'.
>>In particular I am being told that 'OUTPUT' is a reserved
>>word, it's not listed in "SQL Statement and Function
>>Reference" and I can't find a copy of "ibp_reserved.html" at

OK I've found my copy of "ibp_reserved.html"

> Humm, it's a command in isql and it's been a reserved word as long as I can
> recall. There's a list in the IB 6 LangRef and the updated lists for Fb

Found it in the IB5.0 book now - it was not in the index!

> 1.0 and Fb 1.5 are in the respective release notes. (Some from Fb 1.0 were
> "unreserved" in Fb 1.5, too).

And I've marked "ibp_reserved.html" up with the latest notes
and called it firebird_reserved :)
Couple of questions -
We are adding ABS, but the SQL92 list ABSOLUTE - are these
the same?
The non-reserved keywords could be used as field names, but
its probably better treating them as reserved?

>>I probably need to stop using it as a field name, but can
>>someone confirm that please :)
> Yep. Or you could decorate it with double-quotes. :-))

Haven't had to yet, but it is funny, this particular
database has been around for 5 years+, so I presume it's a
dialect 1 thing that is only now biting?

>>( Will this list be in the book Helen? )
> What's it worth to ya?
> :-)

Not a lot, I be buying a copy anyway :)

Lester Caine
L.S.Caine Electronic Services