PolarDB：ST_Collect

文法

• 文法一：

  sfmesh ST_Collect(sfmesh sfmeshObject1, sfmesh sfmeshObject2);

• 文法二：

  sfmesh ST_Collect(sfmesh[] sfmesh_array);

• 文法三：

  sfmesh ST_Collect(setofsfmesh sfmesh_set);

參數

描述

基於節點的方式合并兩個或多個sfmesh。此函數僅做簡單的節點合併作業，不會對sfmesh對象的幾何及紋理做裁剪合併作業。

樣本

• 文法一：

  WITH tmp AS
  (
      SELECT num, the_mesh
      FROM t_mesh
      WHERE num IN (1, 3)
  )
  SELECT a.num, b.num,
       ST_AsText(st_Collect(a.the_mesh,  b.the_mesh))
  FROM tmp a, tmp b;

• 文法二：

  WITH tmp AS
  (
      SELECT num, the_mesh
      FROM t_mesh
      WHERE num IN (1, 3, 13, 14)
  )
  SELECT a.num, b.num,
      ST_AsText(st_Collect(ARRAY[a.the_mesh,  b.the_mesh]))
  FROM tmp a, tmp b;

• 文法三：

  WITH tmp AS
  (
       SELECT num, the_mesh
       FROM t_mesh
  )
  SELECT 
       ST_AsText(st_Collect(the_mesh))
  FROM tmp;