Subject Re: [ib-support] SQL query: how to group by a function
Author Bruno Motta
Hi all,

I've been following this group for a while ( im planning to migrate from
oracle to IB ) and was wondering ....

Interbase does not support GROUP BY / ORDER BY with funcions ? I have a
lot of Row funcions in oracle and ill need them to migrate my application!

Bruno Motta

Rusmin Noer wrote:

> From: Mirjam Besamusca <Mirjam.Besamusca@...>
> > I have a SELECT statement in which I want to group the data by the
> month
> of
> > a date field, to calculate monthly averages. GROUP BY does not
> allow the
> > month function though - is there any way around this?
> IMHO, Why dont you make a dummy-smallint-field containing the month of the
> date-field.
> You can make a before-post-trigger , so the dummy-field value
> is always the accurate month of the date-field.
> Rusmin Noer