pgsql中polygon用法

SELECT
pl.id,
(select district from (
SELECT
(SELECT string_agg(label,', ') from (SELECT unnest(points_arr) "label")L) as polygon,
block.district as district
FROM
block
)b where b.polygon::POLYGON @> CAST ( '(' || pl.longitude::VARCHAR || ',' || pl.latitude::VARCHAR || ')' AS polygon ) limit 1) as district_name
FROM
parking_lot pl
版权声明：本文为weixin_45893488原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。