All Products
Search

This Product

    PolarDB:ST_asText

    Document Center

    PolarDB:ST_asText

    Last Updated:Aug 21, 2026

    Converts a pcpoint or pcpatch object to a JSON string.

    Syntax

    text ST_asText(pcpatch pp);
text ST_asText(pcpoint pt);

    Parameters

    ParameterDescription
    ppThe pcpatch object.
    ptThe pcpoint object.

    Examples

    Convert a pcpoint value to its JSON representation:

    SELECT ST_asText('010100000064CEFFFF94110000703000000400'::pcpoint);

    Output:

    {"pcid":1,"pt":[-127,45,124,4]}