> On 12 Nov 2019, at 14:58, Dan Kennedy <danielk1...@gmail.com> wrote: > > No, they don't need to handle that. The rows will always be added/removed in > ORDER BY order for all window functions (and will be removed in the same > order in which they were added if the ORDER BY order is ambiguous).
Ah, excellent! This dramatically simplifies my life :) Could I suggest adding a note to this extent to https://www.sqlite.org/windowfunctions.html#udfwinfunc for the next paranoid person? Kind regards, Merijn _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users