Stephan Beal <sgbeal@...> writes: > For the small percentage of users who need it (or would even know how to > apply it). i've been following this list since 2006 or 2007 and i recall > this topic having come up only a small handful of times, which implies that > only a small minority of users feels the need for it.
Respectfully, I wouldn't consider feature requests via the listserv a necessarily good indicator of the demand for a given feature. For one, many SQL users don't know that window functions are even possible, so they aren't going to ask for them. (I learned about them after Postgres added them, then discovered their extraordinary utility.) Second, window functions are a bit out of the (current) niche for SQLite, which (I think) is doing datastore work for single user applications. I am still not convinced window functions are a good use of developer time or money, just that lack of mention on the listserv doesn't necessarily imply such a fact. It seems to me the way to experiment is to branch, extend the parser to accept the syntax but yield no-ops, then to work on the bytecode generation. I unfortunately don't have the skill to do it at the moment or the budget to contract, so it is speculative for me only currently. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
