TopoElementArray_Agg
Prev  9.9. TopoGeometry 작성자  Next

Name

TopoElementArray_Agg — Returns a topoelementarray for a set of element_id, type arrays (topoelements).

Synopsis

topoelementarray TopoElementArray_Agg(topoelement set tefield);

설명

TopoElement 집합으로부터 TopoElementArray 를 생성하는 데 쓰입니다.

2.0.0 버전부터 사용할 수 있습니다.

예시

SELECT topology.TopoElementArray_Agg(ARRAY[e,t]) As tea
  FROM generate_series(1,3) As e CROSS JOIN generate_series(1,4) As t;
  tea
--------------------------------------------------------------------------
{{1,1},{1,2},{1,3},{1,4},{2,1},{2,2},{2,3},{2,4},{3,1},{3,2},{3,3},{3,4}}