Re: Bug with ordering aggregates?

* Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
> Stephen Frost <sfrost(at)snowman(dot)net> writes:
> > This doesn't seem right to me:
>
> > postgres=# select
> > postgres-# string_agg(column1::text order by column1 asc,',')
> > postgres-# from (values (3),(4),(1),(2)) a;
> > string_agg
> > ------------
> > 1234
> > (1 row)
>
> Looks fine to me: you have two ordering columns (the second rather
> useless, but that's no matter).

Ah, yeah, guess I'll just complain that having the order by look like
it's an argument to an aggregate makes things confusing. Not much to be
done about it though.

Thanks,

Stephen