Re: [SQL] Collapsing (select) row values into single text field.

2008-12-10 Thread Allan Kamau
Thanks Filip for the User Defined Aggregates information I will look into it, and compare its performance with the another probable solution (explained next). I do recall making use of arrays (then array_to_string()) to do this kind of collapsing as a subquery in the select clause of a group by que

Re: [SQL] Collapsing (select) row values into single text field.

2008-12-10 Thread Filip RembiaƂkowski
2008/12/10 Allan Kamau <[EMAIL PROTECTED]> > Hi all, > I would like to concatenate the field values of several rows in a table > that meet some similarity criteria based on a the values of some other > field (more like a group by). Then I would also like to also include the > lowest value of ano

[SQL] Collapsing (select) row values into single text field.

2008-12-10 Thread Allan Kamau
Hi all, I would like to concatenate the field values of several rows in a table that meet some similarity criteria based on a the values of some other field (more like a group by). Then I would also like to also include the lowest value of another associated field along. I have a table that