""Richard Pendered"" <rpendered@...> wrote in message
news:000c01c1984b$5196efe0$208282c1@tipadrrp...

> Does Firebird RC2 support "order by" in views yet ?

No. This is what the horribly formatted doc that ansi-store sells with the
SQL standard:

<view definition> ::=
CREATE VIEW <table name> [ <left paren> <view column list><right paren> ]
AS <query expression>
[ WITH [ <levels clause> ] CHECK OPTION ]

And
<declare cursor> ::=
DECLARE <cursor name> [ INSENSITIVE
FOR <cursor specification>
] [ SCROLL ] CURSOR

<cursor specification> ::=
<query expression> [ <order by clause> ]
[ <updatability clause> ]

Furthermore,
<direct select statement: multiple rows> ::=
<query expression> [ <order by clause> ]

As you can see, the standard considers the sorting clause apart from the
query expression and a view only allows a query expression. Hence, both IB
and FB agree to the standard by not allowing ORDER BY in a view definition.

C.