[Firebird-devel] ORDER BY FIELD_ALIAS

[Maximenko <al...@no...>]

Firebird doesn't accept field aliases in order by, so:

SELECT FIELD AS ALIAS FROM TABLE ORDER BY FIELD - works, instead of
SELECT FIELD AS ALIAS FROM TABLE ORDER BY ALIAS - doesn't work

Of course,
SELECT FIELD AS ALIAS FROM TABLE ORDER BY 1 - works.

But in complex queries it's not quite useful. Because changing order or set
of fields required also not quite evident changes in order by.

Is it posible to add ordering (grouping) by aliases in FB?