On Tue, 30 Jan 2018 12:16:32 +0100, Stephan Buchert
wrote:
> Thanks for the replies.
>
> Allowing non-aggregate columns in aggregate queries is very useful, as
> shown with the min/max functions.
It is forbidden in most SQL dialects, only supported by SQLite
as a dirty shortcut.
> Probably with
Hello,
On 2018-01-29 18:08, Stephan Buchert wrote:
But then I have a related question: to get my hands on each row in SELECTs
with GROUP BY I could write an aggregate extension function. How do I see
there, when a group ends and a new one starts? I.e. How do I implement the
xStep and xFinal C fu
On 29 Jan 2018, at 3:19pm, Stephan Buchert wrote:
> is there a way to know when a group ends and the next starts?
No. Not even SQLite knows this. Sorry. You have to monitor the group column
in your own software.
Simon.
___
sqlite-users mailing l
3 matches
Mail list logo
