Richard Huxton wrote:
Michael Toews wrote:
You could accumulate the values in an array and then sort that with
the final-func that create aggregate supports.
Thanks for the help. Here was my final functions to aggregate things
into a comma serpented text element (if anyone is interested):
Richard Huxton <[EMAIL PROTECTED]> writes:
> Michael Toews wrote:
>> This is where I get confused, since in the aggregate function, I have
>> specified `SORTOP="<"`, which according to the documentation
>> (http://www.postgresql.org/docs/8.3/interactive/sql-createaggregate.html)
>> "must be equi
Michael Toews wrote:
Now, I would like to group a summary of the strings in "sub", but they
must be ordered alphabetically. Here I attempt the SQL:
select commacat(sub), grp from aggr_test group by grp;
However, on my system it will output the "commacat" column as:
"one, two, three";"pom
