Thanks, Mark.

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?

Thanks,

Alec

On Sun, Jun 3, 2012 at 2:03 AM, Mark Rotteveel <mark@...> wrote:

> **
>
>
> On 2-6-2012 23:17, Dmitry Kuzmenko wrote:
> > Hello, Alec!
> >
> > AS> The question is why FB complains about PLAN token after ORDER BY
> clause?
> >
> > the answer is that PLAN is wrong. ORDER BY in query affects PLAN, it
> > will contain PLAN SORT or TABLE ORDER INDEX specification. Your PLAN
> > specification is crap, sorry for rude answer.
> > As I said before, you need to know how Firebird produces plan
> > specification and how it accepts it.
>
> Dmitry, I think this is not a very constructive way to respond. Alec is
> asking why Firebird does not accept a PLAN after ORDER BY, but it does
> before ORDER BY.
>
> I think the reason is simply that the grammar definition of Firebird
> expects it before the ORDER BY. There is probably nothing more to it.
>
> Telling people they are stupid (my interpretation of your messages) is
> not helpful.
>
> Mark
> --
> Mark Rotteveel
>
>
>


[Non-text portions of this message have been removed]