geometry_dump — A composite type used to describe the parts of complex geometry.
geometry_dump is a
composite data type
containing the fields:
geom - a references to a component geometry
path[] - a 1-dimensional integer array
that defines the navigation path within the dumped geometry to the geom component.
The path array starts at 1 (e.g. path[1] is the first element.)
It is used by the ST_Dump* family of functions as an output type to explode a complex geometry into its
constituent parts.