| Subject | RE: [firebird-support] Things that works in versio 1.5 and dont works in 2.0 |
|---|---|
| Author | Alan McDonald |
| Post date | 2006-11-28T12:03:37Z |
> Hi,why is Price not aliased?
>
> In FireBird 1.5 I have a query with a group like this
>
> ...
> Group by ae.Author, l.Book, Price,
> case
> When op.StockChange in (23,24) Then 21
> When op.StockChange in (43,44) Then 22
> Else Mode end
> ...
>
> It works in 1.5 but raises an error in 2.0. Any idea how to work
> around this? The exception is: Cannot use an aggregate function in
> GROUP BY clause.
>
> Thanks,
>
> Marco Castro
Alan