Another morning another question I have a query that performs a recursive query and outputs a varying number of rows using group by
sqlite> with recursive path as (select id, previd, location from cities union all select cities.id, cities.previd, cities.location from path join cities on (path.previd = cities.id)) select * from path group by id; 1|0|texas 2|1|new york 3|2|washington 4|0|tampa 5|0|atlanta 6|5|charleston I'd like to add a break between groups in the results so it looks somethng like 1|0|texas 2|1|new york 3|2|washington 4|0|tampa 5|0|atlanta 6|5|charleston (it doesn't have to be a newline - just soemthng to make it more readable) * I know texas isn't a city :) Cheers Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite http://sandersonforensics.com/forum/content.php?168-Reconnoitre - VSC processing made easy _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
