Return the text representation of a tpcpoint, or of an array of them, and cast a tpcpoint to text
asText(tpcpoint) → text
asText(tpcpoint[]) → text[]
tpcpoint::text → text
-- The pcpoint payload renders as hex-encoded WKB. SELECT asText(tpcpoint(pcpoint(1, 1, 1, 1), '2001-01-01'::timestamptz)); -- 5C00000001000000640000006400000064000000000000@2001-01-01
Return the text representation of a tpcpatch, or of an array of them, and cast a tpcpatch to text
asText(tpcpatch) → text
asText(tpcpatch[]) → text[]
tpcpatch::text → text
-- The pcpatch payload renders as hex-encoded WKB. SELECT left(asText(tpcpatch(pcpatch(1, pcpoint(1, 1, 1, 1), pcpoint(1, 2, 2, 2)), '2001-01-01'::timestamptz)), 24); -- EC0100000100000000000000
Unlike the other spatial temporal types, asText takes no maxdecimaldigits argument here: a pcpoint or pcpatch prints as the hex-WKB of its serialized form, which has no decimal places to round. The same holds for th3index.
Text output is the safe subset of the textual surface: there is no tpcpointFromText / tpcpatchFromText, because pgPointCloud's pcpoint_in / pcpatch_in accept hex-WKB only and the schema is not reconstructible from the text form. For round-trip use asBinary / asHexWKB with their matching parse functions.