Sure!! Thanks for the response. Apologies for multiple questions. Faced
this during high priority MSSQL to PostgreSQL migration. Did not see any
equivalent of XML PATH which would give desired results. Finally was able
to resolve the issue by rewriting the Proc using WITH and string_aggr in
combina
Thanks Patrick. I used WITH Query and feeded that output to string_aggr
which worked. However it is giving performance issues. Will check on that.
THanks.
On Thu, Apr 8, 2021 at 5:11 PM Patrick FICHE
wrote:
> *From:* aditya desai
> *Sent:* Thursday, April 8, 2021 1:32 PM
> *To:* Pgsql Performan
From: aditya desai
Sent: Thursday, April 8, 2021 1:32 PM
To: Pgsql Performance
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.Rec
