In database nest STRING_AGG() function? throws invalid syntax error

Sunitha

I tried to use string_agg() function in database nest. but it throws error whatever i used as syntax 

string_agg() WITHIN GROUP BYSTRING_AGG(email,';') WITHIN GROUP (ORDER BY email)I tried above two but no luck for me. Help me with syntax

jwpfau

Hi Sunitha,

maybe you are missing the "AS emails" parts at the end?

Greetings,
Jonas