Subject Re: [firebird-support] Why PLAN token is not allowed after ORDER BY?
Author Michael Ludwig
Alec Swan schrieb am 03.06.2012 um 09:01 (-0600):
>
> Is there online docs for SELECT syntax?

There's an online HTML version of the SQL reference linked to from the
overview page:

http://www.ibphoenix.com/files/60sqlref.html

> On Sun, Jun 3, 2012 at 8:59 AM, Alec Swan <alecswan@...> wrote:
> >
> > I found FB 2.5 SQL Language reference here
> > http://www.firebirdsql.org/refdocs/langrefupd25-select.html but it
> > does not contain the grammar for the entire SELECT statement, just
> > individual fragments, such as JOIN, ORDER BY, etc.
> >
> > Where can I find a comprehensive syntax definition for the entire
> > SELECT statement?

There's no complete one-stop doc for the whole thing yet, as far as I
know. Guess most people are happy enough using the old InterBase 6.0
docs (links at the bottom of the doc overview page) supplemented by
the Firebird additions you've found. All here:

http://www.firebirdsql.org/en/reference-manuals/

From the "InterBase 6.0 Manuals" section, download either the "Full Set"
or just the "Language Reference".

Producing a comprehensive doc would require a lot of work, and there
might also be copyright issues for the old InterBase 6.0 docs.

Michael