Re: [sqlite] basic "Window function"

2014-03-14 Thread big stone
"howzit" is my prefered greetings word. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] basic "Window function"

2014-03-13 Thread Darren Duncan
On 2014-03-13, 8:17 AM, big stone wrote: Hello again, Windowing functions are : - not easy to workaround with create_function(), - a truly "sql core" motor functionality. The only use case that I have, is the small subset I described earlier : - inside one 'select' : . several

Re: [sqlite] basic "Window function"

2014-03-13 Thread RSmith
On 2014/03/13 20:02, Petite Abeille wrote: On Mar 13, 2014, at 4:17 PM, big stone wrote: Is there anyone else, (besides little bee), that would "like" this request? "Oh! Oh pick me! Pick me! Me! Me! M!” — Donkey, Shrek Hehe, I live in a Country with 11 official

Re: [sqlite] basic "Window function"

2014-03-13 Thread Petite Abeille
On Mar 13, 2014, at 4:17 PM, big stone wrote: > Is there anyone else, (besides little bee), that would "like" this request? "Oh! Oh pick me! Pick me! Me! Me! M!” — Donkey, Shrek ___ sqlite-users mailing list

Re: [sqlite] basic "Window function"

2014-03-13 Thread big stone
Hello again, Windowing functions are : - not easy to workaround with create_function(), - a truly "sql core" motor functionality. The only use case that I have, is the small subset I described earlier : - inside one 'select' : . several sum/min/avg/max (different fields) , . all with

Re: [sqlite] basic "Window function"

2014-03-01 Thread Petite Abeille
On Mar 1, 2014, at 7:39 PM, big stone wrote: > Would it be possible to get a small basic subset of the sql windowing > function for Sqlite 3.8.5 ? Yes! Pretty please :) Supporting windowing functions (aka analytics) would be a major breakthrough.

[sqlite] basic "Window function"

2014-03-01 Thread big stone
Hello, Sqlite 3.8.3 implemented recursive CTE. Sqlite 3.8.4 is shaping to be another great tuning/optimisation release. Would it be possible to get a small basic subset of the sql windowing function for Sqlite 3.8.5 ? If we imagine that the basic windowing is a bit like a CTE 'rewording', it