ST_unCompress
Updated at:
Returns an uncompressed version of the pcpatch object, bypassing the schema-defined automatic recompression that all other pcpatch-returning functions apply.
Syntax
pcpatch ST_Uncompress(pcpatch pc);Parameters
| Parameter | Description |
|---|---|
pc | The pcpatch object to decompress. |
Description
All functions that return a pcpatch automatically recompress the output using the compression method defined in the schema before returning. ST_Uncompress overrides this behavior and returns the patch uncompressed.
Examples
SELECT ST_Uncompress(pa) FROM patches WHERE ST_NumPoints(pa) = 1;Output:
01010000000000000001000000C8CEFFFFF8110000102700000A00Is this page helpful?