ST_CurveN
Prev  7.4. Accessori alla geometria  Next

Name

ST_CurveN — Returns the Nth component curve geometry of a CompoundCurve.

Synopsis

geometry ST_CurveN(geometry a_compoundcurve, integer index);

Descrizione

Returns the Nth component curve geometry of a CompoundCurve. The index starts at 1. Returns NULL if the geometry is not a CompoundCurve or the index is out of range.

Questo metodo implementa la specifica SQL/MM. SQL-MM 3: 8.2.6, 8.3.5

Questa funzione supporta il 3d e non distrugge gli z-index.

Esempi

SELECT ST_AsText(ST_CurveN('COMPOUNDCURVE(
    (2 2, 2.5 2.5),
    CIRCULARSTRING(2.5 2.5, 4.5 2.5, 3.5 3.5),
    (3.5 3.5, 2.5 4.5, 3 5, 2 2)
  )', 1));