""didiergm"" <Didiergm@...> wrote in message
news:a5eh79+107d6@......

> I have the following query
>
> Select extract (month from sales_transaction.transaction_date), count(*)
> from sales_transaction
> Group by extract(month from transaction_date)

An artificial limitation in the DSQL layer to be in sync with the SQL
standard's entry level conformance, probably. The engine could handle this
directly.

create view v(e) as
Select extract (month from sales_transaction.transaction_date)
from sales_transaction;

Select e, count(*)
from v
Group by e;

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing