ST_MultiSurface( ST_Surface , ST_Surface ) constructor

Syntax

NEW ST_MultiSurface( ST_Surface surface1, ST_Surface surfacei)

Parameters

• surface1 – The first surface value of the multi-surface.
• surfacei – Additional surface values of the multi-surface.

Returns

ST_MultiSurface A multi-surface containing the provided surface values.

Examples

• Example 1 – The following example returns the result MultiSurface (((0 0, 1 0, 1 1, 0 1, 0 0))).

  SELECT NEW ST_MultiSurface( NEW ST_Polygon('Polygon ((0 0, 0 1, 1 1, 1 0, 0 0))' )  )

  The following example returns the result MultiSurface (((0 0, 1 0, 1 1, 0 1, 0 0)), ((5 5, 10 5, 10 10, 5 10, 5 5))).

  SELECT NEW ST_MultiSurface(
  NEW ST_Polygon('Polygon ((0 0, 0 1, 1 1, 1 0, 0 0))' ),
  NEW ST_Polygon('Polygon ((5 5, 5 10, 10 10, 10 5, 5 5))' )  )

Standards

SQL/MM (ISO/IEC 13249-3: 2006) Vendor extension