Greetings,
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)
I'm thinking we should toss a syntax error here and force the 'order by' to be at the end of any arguments to the
aggregate.Alternatively, we should actually make this work like this one does:
postgres=# select
postgres-# string_agg(column1::text,',' order by column1 asc)
postgres-# from (values (3),(4),(1),(2)) a;string_agg
------------1,2,3,4
(1 row)
Thanks,
Stephen