Re: [sqlite] Custom window functions vs builtin

> On 12 Nov 2019, at 14:58, Dan Kennedy 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

Re: [sqlite] Custom window functions vs builtin

On 12/11/62 18:50, Merijn Verstraaten wrote: I already asked this question without an answer, but as it hidden somewhere nested deeply in another thread I think it may have simply gone under the radar. Apologies for the duplication if you already saw it! How is the behaviour of (custom) windo

[sqlite] Custom window functions vs builtin

I already asked this question without an answer, but as it hidden somewhere nested deeply in another thread I think it may have simply gone under the radar. Apologies for the duplication if you already saw it! How is the behaviour of (custom) window functions defined? Specifically, in the prese