0

I have a custom table where it shows custom_field as a column and display_value in another column.

I'm pulling hiring managers from there and some jobs have more than one hiring manager, so it results in multiple rows. I am trying to concatenate them into one row per job:

select
    j.name,
    string_agg(jcf.display_value, ' ,') as hiring_managers
from
    jobs j
left join
    job_custom_fields jcf on j.id = jcf.job_id
where 
    jcf.custom_field = 'Manager'

I'm using Postico as my SQL server client, but it's saying there isn't a function called string_agg available. I'm working within Amazon Redshift, so AFAIK I haven't had any issues with postgresql functions being implemented.

anyone have any ideas?

nick lanta
  • 602
  • 3
  • 10
  • Does this answer your question? [Alternatives of array\_agg() or string\_agg() on redshift](https://stackoverflow.com/questions/52405853/alternatives-of-array-agg-or-string-agg-on-redshift) – Atmo Feb 04 '23 at 08:30

0 Answers0