RSmith wrote: > On 2014/10/14 13:09, Clemens Ladisch wrote: >> SELECT CASE WHEN previd = 0 THEN '--------------' || char(10) END, * >> FROM (SELECT ...); > > This solution from Clemens will work perfectly, and depending on the > kind of OS you use and output method it might even work to add > something like '-----\n' or '----\r\n' as the Inserted item if > char(10) causes headaches.
sqlite> select '-----\n'; -----\n That's not very useful. ;-) > On output produced for Windows systems that should also be > char(13) || char(10). The sqlite3 shell uses the C runtime conventions, where stdout is in text mode, so char(10) is correct even on Windows. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users