On 10/10/2012 10:09 PM, Hamish Allan wrote:
On 10 October 2012 16:07, Dan Kennedy wrote:
On 10/10/2012 10:01 PM, Ryan Johnson wrote:
On 10/10/2012 10:49 AM, Dan Kennedy wrote:
The easiest workaround is probably to use a temp table to store the
unaggregated results of the FTS query.
What
On 10/10/2012 11:07 AM, Dan Kennedy wrote:
On 10/10/2012 10:01 PM, Ryan Johnson wrote:
On 10/10/2012 10:49 AM, Dan Kennedy wrote:
On 10/10/2012 08:14 PM, Hamish Allan wrote:
Short form question:
Working: SELECT a, userfunc(systemfunc) FROM t;
Working: SELECT a, sum(systemfunc) FROM t GROUP BY
On 10 October 2012 16:07, Dan Kennedy wrote:
>
> On 10/10/2012 10:01 PM, Ryan Johnson wrote:
>>
>> On 10/10/2012 10:49 AM, Dan Kennedy wrote:
>>>
>>> The easiest workaround is probably to use a temp table to store the
>>> unaggregated results of the FTS query.
>>
>> What about a nested query?
>
>
On 10/10/2012 10:01 PM, Ryan Johnson wrote:
On 10/10/2012 10:49 AM, Dan Kennedy wrote:
On 10/10/2012 08:14 PM, Hamish Allan wrote:
Short form question:
Working: SELECT a, userfunc(systemfunc) FROM t;
Working: SELECT a, sum(systemfunc) FROM t GROUP BY a;
Not working: SELECT a, sum(userfunc(syst
On 10/10/2012 10:49 AM, Dan Kennedy wrote:
On 10/10/2012 08:14 PM, Hamish Allan wrote:
Short form question:
Working: SELECT a, userfunc(systemfunc) FROM t;
Working: SELECT a, sum(systemfunc) FROM t GROUP BY a;
Not working: SELECT a, sum(userfunc(systemfunc)) FROM t GROUP BY a;
Long form questi
On 10/10/2012 08:14 PM, Hamish Allan wrote:
Short form question:
Working: SELECT a, userfunc(systemfunc) FROM t;
Working: SELECT a, sum(systemfunc) FROM t GROUP BY a;
Not working: SELECT a, sum(userfunc(systemfunc)) FROM t GROUP BY a;
Long form question:
I have a user-defined C function called
Short form question:
Working: SELECT a, userfunc(systemfunc) FROM t;
Working: SELECT a, sum(systemfunc) FROM t GROUP BY a;
Not working: SELECT a, sum(userfunc(systemfunc)) FROM t GROUP BY a;
Long form question:
I have a user-defined C function called "hits", loosely based on the
function "rankfu
7 matches
Mail list logo