-- SET SESSION group_concat_max_len = 102400;
SELECT
BB.road_name,
BB.direct_type,
concat (
'MULTILINESTRING(',
array_to_string(
ARRAY (
SELECT
UNNEST (
ARRAY_AGG (substr(BB.wkt, 11))
)
ORDER BY
1
),
','
),
')'
) poly
FROM
(
SELECT
rd.road_name,
rd.direct_type,
rl.wkt --"direction_num", "section_num", "link_num"
FROM
d_road_direction rd,
d_road_link rl
WHERE
rd.road_name = rl.road_name
ORDER BY
rd.road_name,
rl.direction_num,
rl.section_num,
rl.link_num
) BB
GROUP BY
road_name,
direct_type
ORDER BY
road_name,
direct_type
uj5u.com熱心網友回復：
被截斷到多長了? 我用系統表模擬沒離了一下，看起來是正常的嘛SELECT
COUNT(*),
LENGTH(concat (
'MULTILINESTRING(',
array_to_string(
ARRAY (
SELECT
UNNEST (
ARRAY_AGG (substr(BB.name, 11))
)
ORDER BY 1
),
','
),
')'
)) poly
FROM(
SELECT a.name FROM pg_settings A, pg_settings B, pg_settings c
) bb
結果
count poly
19465109 178514603
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/89470.html
標籤：PostgreSQL
上一篇：求PB9.0教程