im trying to combine the result of my multiple rows to one row using function arrag_agg but it gives me the results as i want in 1 row with comma-separated list, however i dont need any other characters like the brackets at first and last character, noting that i tried to use string_agg but the function is not registered
Table name user.info with column phone_numbers
When i used
Select array_agg(phone_numbers) as phonenumbers from user.info
It showed resuts as below for sample
[9747827463,97432726363,974836367282]
What i need is to remove these brackets and leave the row results with only comma separated like
9747827463,97432726363,974836367282
2