Re: [sqlite] Combining user-defined functions with aggregate functions

2012-10-10 Thread Dan Kennedy
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

Re: [sqlite] Combining user-defined functions with aggregate functions

2012-10-10 Thread Ryan Johnson
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

Re: [sqlite] Combining user-defined functions with aggregate functions

2012-10-10 Thread Hamish Allan
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? > >

Re: [sqlite] Combining user-defined functions with aggregate functions

2012-10-10 Thread Dan Kennedy
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

Re: [sqlite] Combining user-defined functions with aggregate functions

2012-10-10 Thread Ryan Johnson
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

Re: [sqlite] Combining user-defined functions with aggregate functions

2012-10-10 Thread Dan Kennedy
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

[sqlite] Combining user-defined functions with aggregate functions

2012-10-10 Thread Hamish Allan
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