A temporal pose value can be converted to and from a temporal geometry point. This can be done using an explicit CAST
or using the ::
notation. A null value is returned if any of the composing geometry point values cannot be converted into a pose
value.
Convert a temporal pose into a temporal geometry point
tpose::tgeompoint
SELECT asText((tpose '[Pose(Point(1 1), 0.2)@2001-01-01, Pose(Point(1 1), 0.3)@2001-01-02)')::tgeompoint); -- [POINT(1 1)@2001-01-01, POINT(1 1)@2001-01-02) SELECT asEWKT((tpose '[Pose(Point Z(1 1 1), 0.5, 0.5, 0.5, 0.5)@2001-01-01, Pose(Point Z(2 2 2), 1, 0, 0, 0)@2001-01-02)')::tgeompoint); -- [POINT Z (1 1 1)@2001-01-01, POINT Z (2 2 2)@2001-01-02)