在或接近或接近＆＃x27; select＆＃x27;的语法错误问题

Question

我正在尝试编写有关如何创建等距的编码，这是我的代码：

SELECT i As time_access,
ST_SetSRID(pgr_pointsAsPolygon(
‘SELECT id, ST_X (geom) AS x, ST_Y (geom) As y
FROM dd_caserne
WHERE access_time <= ‘|| i :: text), 4326) As geom
FROM generate_series(60,300,60)
As i
ORDER BY i DESC;

我遇到的错误如下：

ERROR:  syntax error at or near "id"
LINE 4: ‘SELECT id, ST_X (geom) AS x, ST_Y (geom) As y

有人可以帮助我吗？

Answer 1

欢迎来到。

您正在使用错误的字符引用选择字符串。使用单个引号'代替：

SELECT 
  i AS time_access,
  ST_SetSRID(pgr_pointsAsPolygon(
    'SELECT id, ST_X(geom) AS x, ST_Y(geom) AS y
     FROM dd_caserne WHERE access_time <= '|| i::text), 4326) AS geom
FROM generate_series(60,300,60) AS i
ORDER BY i DESC;

另请参阅 dollar-quoted字符串

注意：如果您使用的是pgrouting 3.0+，请检查 pgr_alphashape