'FOR XML PATH in Postgres

Hi everyone I'm trying convert this code so it works in postgres. I figured I will use to_char(dateinquar:: date, 'mm/dd/yyyy') instead of convert(varchar,dateinquar,101). But I'm not sure what can be used instead of FOR XML PATH? I don't need to generate any XML document. How would I get multiple dates in a single row separated by comma for the case below?

Case d.Closing  WHEN 0 THEN  NULL  WHEN 1 THEN ( 
        substring((SELECT convert(varchar,dateinquar,101) + ', ' FROM PDT_tblAReasons sub  
                   WHERE sub.IDnumber = d.IDnumber and dateoutquar IS NULL 
                   GROUP BY IDnumber,dateinquar FOR XML PATH('')),0,len(( 
                   SELECT convert(varchar,dateinquar,101) + ', ' FROM PDT_tblAReasons sub 
                   WHERE sub.IDnumber = d.IDnumber and dateoutquar IS NULL 
                   GROUP BY IDnumber,dateinquar FOR XML PATH('')))-0)) end As [Closing Date]

Thank you

postgresql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions