Postgres Pro
Downloads
Home   >   mailing lists

str_aggr function not wokring - Mailing list pgsql-performance

From aditya desai
Subject str_aggr function not wokring
Date
Msg-id CAN0SRDHivv3kOFYcgvQv647F4O5PuKkRJwemm5hesZO75Q=Wjg@mail.gmail.com
Whole thread Raw
Responses RE: str_aggr function not wokring  (Patrick FICHE <Patrick.Fiche@aqsacom.com>)
List pgsql-performance
Tree view
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.

pgsql-performance by date:

Previous
From: Szalontai Zoltán
Date:
Subject: procedure using CURSOR to insert is extremely slow
Next
From: Hervé Schweitzer (HER)
Date:
Subject: Re: procedure using CURSOR to insert is extremely slow