Devuelve los valores
getValues(tnpoint) → npoint[]
SELECT getValues(tnpoint '{[NPoint(1, 0.3)@2001-01-01, NPoint(1, 0.5)@2001-01-02)}'); -- {"NPoint(1,0.3)","NPoint(1,0.5)"} SELECT getValues(tnpoint '{[NPoint(1, 0.3)@2001-01-01, NPoint(1, 0.3)@2001-01-02)}'); -- {"NPoint(1,0.3)"}
Devuelve los identificadores de ruta
routes(tnpoint) → bigintset
SELECT routes(tnpoint '{NPoint(3, 0.3)@2001-01-01, NPoint(1, 0.5)@2001-01-02}'); -- {1, 3}
Devuelve el valor en una marca de tiempo
valueAtTimestamp(tnpoint,timestamptz) → npoint
SELECT valueAtTimestamp(tnpoint '[NPoint(1, 0.3)@2001-01-01, NPoint(1, 0.5)@2001-01-03)', '2001-01-02'); -- NPoint(1,0.4)
Devuelve la longitud atravesada por el punto de red temporal
length(tnpoint) → float
SELECT length(tnpoint '[NPoint(1, 0.3)@2001-01-01, NPoint(1, 0.5)@2001-01-02]'); -- 54.3757408468784
Devuelve la longitud acumulada atravesada por el punto de red temporal
cumulativeLength(tnpoint) → tfloat
SELECT cumulativeLength(tnpoint '{[NPoint(1, 0.3)@2001-01-01, NPoint(1, 0.5)@2001-01-02, NPoint(1, 0.5)@2001-01-03], [NPoint(1, 0.6)@2001-01-04, NPoint(1, 0.7)@2001-01-05]}'); /* {[0@2001-01-01, 54.3757408468784@2001-01-02, 54.3757408468784@2001-01-03], [54.3757408468784@2001-01-04, 81.5636112703177@2001-01-05]} */
Devuelve la velocidad del punto de red temporal en unidades por segundo
speed({tnpointSeq, tnpointSeqSet}) → tfloatSeqSet
SELECT speed(tnpoint '[NPoint(1, 0.1)@2001-01-01, NPoint(1, 0.4)@2001-01-02, NPoint(1, 0.6)@2001-01-03]') * 3600 * 24; /* Interp=Step;[21.4016800272077@2001-01-01, 14.2677866848051@2001-01-02, 14.2677866848051@2001-01-03] */