A temporal pose value can be converted to and from a temporal point, which is a temporal geometry point for a planar pose and a temporal geography point for a geodetic pose. This can be done using an explicit CAST or using the :: notation. Converting a temporal pose to the temporal point type of the other reference frame raises an error. 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)
Convert a geodetic temporal pose into a temporal geography point
tpose::tgeogpoint
SELECT asText((tpose '[GeodPose(Point(1 1), 0.2)@2001-01-01, GeodPose(Point(1 1), 0.3)@2001-01-02)')::tgeogpoint); -- [POINT(1 1)@2001-01-01, POINT(1 1)@2001-01-02)