Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
From: aditya desai <admad123@gmail.com> Sent: Thursday, April 8, 2021 1:32 PMTo: Pgsql Performance <pgsql-performance@lists.postgresql.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 Pwhere 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 Pwhere R.PhaseID = P.PhaseID Regards, Patrick
From: aditya desai <admad123@gmail.com> Sent: Thursday, April 8, 2021 1:32 PMTo: Pgsql Performance <pgsql-performance@lists.postgresql.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.
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
Patrick
В списке pgsql-performance по дате отправления: