Re: [Haskelldb-users] composing relational operations with aggregate expressions

[Bjorn B. <bri...@cs...>]

On Jul 11, 2006, at 3:33 PM, Matthias Radestock wrote:

> Bjorn Bringert <bri...@cs...> writes:
>
>> Try changing line 187 in Optimize.hs to
>>
>>           	=3D not (any (isAggregate.snd) assoc)
>>
>> Let me know if that helps and I'll fix it in darcs.
>
> That seems to do the trick. Thanks! I now get
>
> SELECT DISTINCT count6 as count
> FROM  (SELECT DISTINCT COUNT(id5) as count6
>        FROM  ((SELECT DISTINCT id as id5
>                FROM  table1 as T1)
>               EXCEPT
>               (SELECT DISTINCT id as id5
>                FROM  table2 as T1)) as T1) as T1
>
> The outer select is unnecessary but harmless.

Thank you for the report, the change is in darcs now.

/Bj=F6rn