On Mon, Jun 9, 2008 at 11:19 AM, David Baird <[EMAIL PROTECTED]> wrote:
> 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 :-(
Okay, just built SQLite 3.5.9 and group_concat does in fact work:
select group_concat(t, ' ') from w where f=1;
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
