On Mon, Jun 9, 2008 at 11:09 AM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Wilson, Ron P
> <[EMAIL PROTECTED]>
> wrote:
>> select t from w where f=1;
>> 2
>> 3
>> 4
>> 5
>> 6
>> 7
>>
>> I would like the output to look like this:
>>
>> 1 2 3 4 5 6 7
>>
>> i.e. parent child1 child2 ... childN
>
> SQL is not formatting or reporting library. It gives you raw data, and
> it's up to your application to build a presentation from it.
>
Actually, it seems that the group_concat aggregation function should
do the trick:
http://www.sqlite.org/lang_aggfunc.html
But, my SQLite (3.4.2) on Ubuntu seems to be missing the group_concat
function though :-(
-David
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
