Re: [Firebird-devel] Firebird feature requests

[Dmitry Y. <di...@us...>]

"Eyal" <ey...@re...> wrote:
>
>  From the Release Notes of FB2alpha:
>
> "Improved GROUP BY and ORDER BY clauses      A. Brinkman
>
> Column aliases are now allowed in both these clauses.
>
> Examples: ..."
>
> Does this mean that column aliases are only supported for non-expression
> columns?

For all columns, including expressions. With possible performance issues I
outlined.

> Or that they are supported for GROUP/ORDER BY but not for HAVING?

They are not supported for HAVING, as far as I remember.


Dmitry