On 29 November 2015 at 18:59, Sterpu Victor <victor@xxxxxxxx> wrote:
I can't skip the ordering.I'm sure aqjs3 is the one that produces the duplication.I guess subqueries are the only option, like this:
Well you could look at the intarray extension and a combination of array_agg, uniq() and string_to_array:
but that's probably sledgehammer:nut time.
Not sure why you need to order the values you're getting back by something other than the values themselves - is there a reason you wouldn't want the "children" set to be ordered numerically? You can still order the outer query by whatever you like, or you can order the aggregate by the values themselves, it's just the DISTINCT inside the aggregate query requires that an internal ORDER includes the ordering term in the result.
Geoff
