Product Documentation

Appearance

All platforms

ST_MULTI ​

Transform a GEOGRAPHY into a MULTI* collection. If the input GEOGRAPHY is already a collection, it is returned unchanged.

Syntax ​

sql
ST_MULTI(<input>)

Arguments ​

  • <input>: A GEOGRAPHY object to be converted to a multi-type

Returns ​

A GEOGRAPHY of corresponding MULTI* type

Example ​

sql
SELECT ST_AsText(ST_MULTI('POINT(1 1)'::GEOGRAPHY));
-- 'MULTIPOINT((1 1))'

SELECT ST_AsText(ST_MULTI('MULTIPOINT((1 1))'::GEOGRAPHY));
-- 'MULTIPOINT((1 1))'