Re: Ordering of data on calls to user defined aggregate.

Tim Hart <timjhart(at)shaw(dot)ca> said:

> So I tried a query like this:
>
> select fk, concat_with_and(name) from ( select fk, name from foo order
> by fk, name) sub_select group by fk;
>
> From just eyeballing the first 10 to 12 pages of the results, all but 2
> records had the names in alphabetical order. So I removed the subselect
> and ran the query again - this time paying attention to the ordering
> within names. Very few entries in the 'names' column were in
> alphabetical order at all.

Hmmm... in my (small) test case, they were all alphabetized.

I didn't think that subquery sort orders were guaranteed, though, so perhaps it's okay that yours weren't.

Can you try with GROUP BY fk, name in the subquery? That works, too, on my small test case, and that should be guaranteed behavior in a subquery. Let's see how that works with your data set.

- J.