select (replace(
         array (    select string_to_array(
		SA.SaleArticleID::text			|| '|' ||
		coalesce(ATS.Name,A.Code)::text          || '|' ||
		coalesce(TR.Amount, 0 )::text      	|| '|' ||
		coalesce(TR.AmountFree, 0 )::text  	|| '|' ||
		coalesce(TRIT.Amount, 0 )::text    	|| '|' ||
		coalesce(TRIT.AmountFree, 0 )::text
		, '|')::text
            from  Articles as A
            inner join TotalRestsNew as TR on (A.ArticleID = TR.ArticleID and TR.StoreGroupID= 5 ) --AAM+
            inner join TotalRestsNew as TRIT on (A.ArticleID = TRIT.ArticleID and TRIT.StoreGroupID= 6 ) --
            inner join SaleArticles  as SA on (A.ArticleID = SA.ArticleID)
          left outer join Existed.ArticleTextileSizes as ATS on (A.ArticleID = ATS.ArticleID)
              where A.ParentArticleID =  36122   and A.ParentArticleID<>A.ArticleID
              order by ATS.ArticleClassificationID,A.code)::text
		-----------------
		, '"', '')::text[][])

CREATE AGGREGATE array_accum(anyelement)
(
    sfunc = array_append,
    stype = anyarray,
    initcond = '{}'
);

select * from ParentArticles as PA
inner join (select TR.ParentArticleID,
	('{' || array_to_string(array_accum(		
               (string_to_array(
		TR.SaleArticleID::text			    || '|' ||
		coalesce(ATS.Name,TR.SaleArticleCode)::text         || '|' ||
		coalesce(TR.Amount, 0 )::text      	|| '|' ||
		coalesce(TR.AmountFree, 0 )::text  	|| '|' ||
		coalesce(TRIT.Amount, 0 )::text    	|| '|' ||
		coalesce(TRIT.AmountFree, 0 )::text
		, '|')::text)), ',') || '}')::text[][] as AmountArray
            from  TotalRestsNew as TR 
            inner join TotalRestsNew as TRIT on (TR.ArticleID = TRIT.ArticleID and TRIT.StoreGroupID= 6 ) 
          left outer join Existed.ArticleTextileSizes as ATS on (TR.ArticleID = ATS.ArticleID)
              where TR.ParentArticleID<>TR.ArticleID  and TR.StoreGroupID= 5 
              group by TR.ParentArticleID) as AArrays on (AArrays.ParentArticleID = PA.ParentArticleID)