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;