I am using Postgres. I am trying to execute two functions in PARALLEL, and then union their results$-$ here is my code so far $($which throws the following error $-$ SQL Error $[25$P$02]$: ERROR: current transaction is aborted, commands ignored until end of transaction block$)-$ begin;

$--------$

WITH area$\_$ids AS $($

SELECT DISTINCT "areaID"::character varying

FROM campaign$\_$scope cs

WHERE $\text{'}2024-03-02\text{'}$ BETWEEN cs$.$"campaignStartDate" AND cs$.$"catchupEndDate"

$),$

area$\_$id$\_$counts AS $($

SELECT COUNT$(*)$ AS total$\_$count

FROM area$\_$ids

$),$

selected$\_$area$\_$ids AS $($

SELECT "areaID"::character varying,

ROW$\_$NUMBER$()$ OVER $($ORDER BY "areaID"::character varying$)$ AS row$\_$num

FROM area$\_$ids

$)$

$----------$

$,$

results$\_1$ as

$($

SELECT inter.$*$ FROM

$($select $*$ from public.interactions$\_$looped$\_$ucmo$\_$aic$($array$($SELECT selected$\_$area$\_$ids."areaID"::character varying

FROM selected$\_$area$\_$ids

JOIN area$\_$id$\_$counts ON true

WHERE selected$\_$area$\_$ids.row$\_$num $<=$ area$\_$id$\_$counts.total$\_$count $/2$

$),\text{'}2024-03-02\text{'},\text{'}2024-03-0206$:$00$:$00\text{'},\text{'}2024-03-0218$:$00$:$00\text{'})$

order by area$\_$id$,$parent$\_$imei,child$\_$imei,parent$\_$ping$\_$time$)$ as inter$)$

$,$

results$\_2$ as

$($

SELECT inter.$*$ FROM

$($select $*$ from public.interactions$\_$looped$\_$ucmo$\_$aic$($array$($SELECT selected$\_$area$\_$ids."areaID"::character varying

FROM selected$\_$area$\_$ids

JOIN area$\_$id$\_$counts ON true

WHERE selected$\_$area$\_$ids.row$\_$num $>$ area$\_$id$\_$counts.total$\_$count $/2$

$),\text{'}2024-03-02\text{'},\text{'}2024-03-0206$:$00$:$00\text{'},\text{'}2024-03-0218$:$00$:$00\text{'})$

order by area$\_$id$,$parent$\_$imei,child$\_$imei,parent$\_$ping$\_$time$)$ as inter

$)$

SELECT $*$ FROM result$\_1$

UNION ALL

SELECT $*$ FROM result$\_2$;

commit;