您是否知道如何显示以下查询的结果或将其存储在表中:
do
$$
declare
i record;
begin
for i in 1..3 loop
PERFORM ROW_NUMBER() OVER() AS id,
sub_query.*
FROM line AS b, LATERAL (
SELECT array_agg(DISTINCT a.id) AS old_id,
ST_Union(a.geom) AS fusion
FROM line AS a
WHERE a.id > b.id
AND ST_touches(a.geom, b.geom) = true
AND a.material = b.material
GROUP BY a.material
) AS sub_query
;
end loop;
end;
$$
;发布于 2017-10-13 16:52:48
我不明白如何在上面的代码中使用记录,所以只需运行三次:
SELECT ROW_NUMBER() OVER() AS id,
sub_query.*
FROM line AS b, LATERAL (
SELECT array_agg(DISTINCT a.id) AS old_id,
ST_Union(a.geom) AS fusion
FROM line AS a
WHERE a.id > b.id
AND ST_touches(a.geom, b.geom) = true
AND a.material = b.material
GROUP BY a.material
) AS sub_query
;??..
如果从理论上讲,可以使用raise输出值,或者使用insert into将值放入表中……
https://stackoverflow.com/questions/46726013
复制相似问题