RE: str_aggr function not wokring

From: aditya desai <admad123(at)gmail(dot)com>
Sent: Thursday, April 8, 2021 1:32 PM
To: Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: str_aggr function not wokring

Hi,
I need to combine results of multiple rows in one row. I get below error. Could you please help.

Query:

select string_agg((select '******' || P.PhaseName || ' - ' || R.Recommendation AS "ABC" from tblAssessmentRecommendation R,tblAssessmentPhases P
where R.PhaseID = P.PhaseID Order BY P.sortOrder DESC),' ')

Error:

ERROR: more than one row returned by a subquery used as an expression SQL state: 21000

Regards,
Aditya.

Hi,

I would suggest you to try something like this instead

select string_agg( '******' || P.PhaseName || ' - ' || R.Recommendation '' ORDER BY P.sortOrder DESC ) AS "ABC"
from tblAssessmentRecommendation R,tblAssessmentPhases P
where R.PhaseID = P.PhaseID

Regards,

Patrick