On 4 Jun 2002 at 18:04, Didier Gasser-Morlay wrote:

>In the 1.00 release docs, it is stated that
>'a side effect of the changes enabling the grouping by UDF is that,
>whereas previously you could not call built-in firebird functions in
>GROUP BY, now you can by creating a dummy UDF wrapper.

There must be a mistake because there is a much simplier way to do
this - a computed column.

CREATE TABLE TEST (
d DATE,
y COMPUTED BY Extract(year from d));

Select max(d),y from test group by y;

>The example given suggest that I could to a group by a the result of
>the subselect, how could this be done ?

You, probably, could create a view and then use 'group by' in
select from this view.

SY, Dimitry Sibiryakov.