この関数は、pcpatch オブジェクトを複数行の pcpoint オブジェクトに分割します。

構文

setof[pcpoint] ST_explode(pcpatch pc);

パラメーター

パラメーター  説明 
pc pcpatch オブジェクト

SELECT ST_AsText(ST_Explode(pa)), id FROM patches WHERE id = 7;
-------------------------------------------
              st_astext               | id
--------------------------------------+----
 {"pcid":1,"pt":[-126.5,45.5,50,5]}   |  7
 {"pcid":1,"pt":[-126.49,45.51,51,5]} |  7
 {"pcid":1,"pt":[-126.48,45.52,52,5]} |  7
 {"pcid":1,"pt":[-126.47,45.53,53,5]} |  7
 {"pcid":1,"pt":[-126.46,45.54,54,5]} |  7
 {"pcid":1,"pt":[-126.45,45.55,55,5]} |  7
 {"pcid":1,"pt":[-126.44,45.56,56,5]} |  7
 {"pcid":1,"pt":[-126.43,45.57,57,5]} |  7
 {"pcid":1,"pt":[-126.42,45.58,58,5]} |  7
 {"pcid":1,"pt":[-126.41,45.59,59,5]} |  7