带有postgis的dblink postgresql中的linestring不起作用

我正在尝试使用postgis函数进行dblink,但是线串给了我很多问题.

SELECT 
    DV3."XXX",s."QQQID",s."X",s."Y",a."PPP"
FROM 
    "QQQ" s INNER JOIN "AAA" a ON a."QQQID" = s."QQQID",dblink('dbname=ZZZ','SELECT XXX,the_geom 
        FROM "geometry","QQQ" s 
        WHERE box2d(geomfromtext(''LINESTRING('|| s."X" ||' '||s."Y" ||','|| s."X" || ' '||s."Y" || ')'',2309))
        && the_geom'
                           ) 
        DV3("XXX" INTEGER,"the_geom"  geometry)


WHERE 
    contains(DV3.the_geom,geomfromtext('POINT('|| s."X" ||' '|| s."Y" ||')',2309))--21
    AND "GGG" IS NOT NULL

错误

LINE 9: … WHERE box2d(geomfromtext(”LINESTRING(‘|| s.”X” + 0….

解决方法

在

'SELECT XXX,the_geom 
    FROM "geometry","QQQ" s 
    WHERE box2d(geomfromtext(''LINESTRING('|| s."X" ||' '||s."Y" ||',2309))
    && the_geom'

在LINESTRING之前和之前,2309.

（编辑：新余站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!