On 4 Oct 2017, at 4:06pm, Doug Nebeker <ad...@poweradmin.com> wrote:

> Is it just a matter of using sqlite3_create_function to register a function 
> that guarantees it will concatenate in the order rows are received?  Would 
> that guarantee that your example works, or is order no longer guaranteed once 
> they leave the inner select?
> SELECT group_concat(LineText, '\n') FROM
>       (SELECT LineText FROM DocLines
>               WHERE DocID = 10
>               ORDER BY LineIndex)

I’ve never tried it but I can’t think why it wouldn’t work.  Yes, you could 
register a function written in your favourite shimmed language.  All this 
really does is move the "concat_in_order" function from your own code into 

sqlite-users mailing list

Reply via email to