All Products
Search
Document Center

PolarDB:ST_Combine

Last Updated:Mar 28, 2026

Merges all scene objects in a column into a single 3D model.

Syntax

scene ST_Combine(scene sc)

Parameters

ParameterDescription
scThe scene object column or expression to aggregate. ST_Combine processes all rows in the column and merges them into one scene object.

How it works

ST_Combine operates on a set of rows. Pass a scene column directly in a SELECT statement, and the function merges all scene objects in that column into one.

The following example shows four neighboring 3D models before the merge.

Four separate 3D tile models before merging

After calling ST_Combine, the four models are merged into one.

One combined 3D model after merging

Examples

The following query merges all scene objects in the scene column of table t and returns the result as text:

SELECT ST_AsText(ST_Combine(scene)) FROM t;

Output:

{"type" : "gltf", "content" : {"accessors":[{"bufferView":0, ...

Limitations

ST_Combine only merges scene objects of the same type. Mixing scene object types in the same column is not supported.

For example, ST_Combine cannot merge glTF scene objects with OSG scene objects in the same query.