Return the values
getValues(tpose) → poseset
SELECT asText(getValues(tpose '{[Pose(Point(1 1), 0.3)@2001-01-01, Pose(Point(1 1), 0.5)@2001-01-02)}')); -- {"Pose(Point(1 1),0.3)","Pose(Point(1 1),0.5)"} SELECT asEWKT(getValues(tpose 'SRID=5676;{[Pose(Point(1 1), 0.3)@2001-01-01, Pose(Point(1 1), 0.3)@2001-01-02)}')); -- SRID=5676;{"Pose(Point(1 1),0.3)"}
Return the points
points(tpose) → geomset
SELECT asEWKT(points(tpose 'SRID=5676;{Pose(Point(3 3), 0.3)@2001-01-01, Pose(Point(1 1), 0.5)@2001-01-02}')); -- SRID=5676;{Point(1 1), Point(3 3)}
Return the rotation
rotation(tpose2d) → tfloat
SELECT rotation(tpose 'SRID=5676;{[Pose(Point(1 1), 0.3)@2001-01-01, Pose(Point(1 1), 0.3)@2001-01-02)}'); -- {[0.3@2001-01-01, 0.3@2001-01-02)}
Return the value at a timestamp
valueAtTimestamp(tpose,timestamptz) → pose
SELECT asText(valueAtTimestamp(tpose '[Pose(Point(1 1), 0.3)@2001-01-01, Pose(Point(3 3), 0.5)@2001-01-03)', '2001-01-02')); -- Pose(Point(2 2),0.4) SELECT asText(valueAtTimestamp(tpose '[Pose(Point Z(1 1 1), 0.5, 0.5, 0.5, 0.5)@2001-01-01, Pose(Point Z(3 3 3), 1, 0, 0, 0)@2001-01-03)', timestamptz '2001-01-02'), 6); -- Pose(POINT Z (2 2 2),0.866025,0.288675,0.288675,0.288675)