Postgresql aggregate array bracket removal

Question

How do i remove the brackets {} from an Array_AGG query output?

ARRAY_AGG(DISTINCT(SGL.short_name))

from this {01,02} to this 01|02|

thanks!

Craig Ringer · Accepted Answer · 2015-08-21 05:50:41Z

12

Use string_agg instead.

string_agg(DISTINCT SGL.short_name, '|')

answered Aug 21, 2015 at 3:16

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gordon Linoff · Accepted Answer · 2015-08-21 01:53:28Z

7

Use array_to_string():

ARRAY_TO_STRING(ARRAY_AGG(DISTINCT(SGL.short_name)), '|')

answered Aug 21, 2015 at 1:53

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Is it possible to change the order of the output from 01|02|03|04|05|KG|PK to PK|KG|01|02|03|04|05 ?

@user3263892 . . . Yes, you would add an order by clause.