On 4 Oct 2017, at 4:06pm, Doug Nebeker <[email protected]> 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. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
