多到GEOM

Question

我有这种MultiPolygon。我怎么才能把它转换成一个geom呢？当我使用UPDATE表SET = ST_GeomFromText('WKT')时，我有一个错误：

错误:解析错误-无效几何

提示："WK“<-解析几何中位置2的错误

WKT
MULTIPOLYGON (((24.0538073758627 37.7378703845543,24.0538007353528 37.7379487552645,24.0536236884047 37.7380046312008,24.0535794162991 37.7380077309477,24.0535382978588 37.7379758484951,24.0534338058209 37.7380279295364,24.0534348887244 37.7380896641314,24.053460740598 37.7381057377936,24.0534867036416 37.7381190093452,24.0535498820047 37.7381290046238,24.053633022553 37.7381254748393,24.0537206363065 37.7380982153644,24.0538080832798 37.7380751589808,24.0538873759795 37.7380350692302,24.0539348015795 37.7379969871668,24.0539640433116 37.7379275964686,24.0539663216762 37.7378701532806,24.0538073758627 37.7378703845543)))

Answer 1

SELECT
    ST_GeomFromText ('MULTIPOLYGON (24.0538073758627 37.7378703845543,
    24.0538007353528 37.7379487552645,
    24.0536236884047 37.7380046312008,
    24.0535794162991 37.7380077309477,
    24.0535382978588 37.7379758484951,
    24.0534338058209 37.7380279295364,
    24.0534348887244 37.7380896641314,
    24.053460740598 37.7381057377936,
    24.0534867036416 37.7381190093452,
    24.0535498820047 37.7381290046238,
    24.053633022553 37.7381254748393,
    24.0537206363065 37.7380982153644,
    24.0538080832798 37.7380751589808,
    24.0538873759795 37.7380350692302,
    24.0539348015795 37.7379969871668,
    24.0539640433116 37.7379275964686,
    24.0539663216762 37.7378701532806,
    24.0538073758627 37.7378703845543)');

或

SELECT ST_GeomFromText(
'MULTIPOLYGON ((
    (24.0538073758627 37.7378703845543,
    24.0538007353528 37.7379487552645,
    24.0536236884047 37.7380046312008,
    24.0535794162991 37.7380077309477,
    24.0535382978588 37.7379758484951,
    24.0534338058209 37.7380279295364,
    24.0534348887244 37.7380896641314,
    24.053460740598 37.7381057377936,
    24.0534867036416 37.7381190093452,
    24.0535498820047 37.7381290046238,
    24.053633022553 37.7381254748393,
    24.0537206363065 37.7380982153644,
    24.0538080832798 37.7380751589808,
    24.0538873759795 37.7380350692302,
    24.0539348015795 37.7379969871668,
    24.0539640433116 37.7379275964686,
    24.0539663216762 37.7378701532806,
    24.0538073758627 37.7378703845543)))', 4326);