Advertisement
Guest User

Untitled

a guest
Feb 22nd, 2019
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. WITH pt AS (
  2. SELECT 1 as id, 'point(-75.5 47.2)'::geometry geom
  3. union
  4. SELECT 2 as id, 'point(-75.6 47.3)'::geometry geom
  5. ),
  6. poly AS (SELECT 1 as id, 'polygon((-70 51, -81 51, -81 40,-70 40, -70 51))'::geometry geom)
  7. SELECT poly.id polyID, string_agg(pt.id::text,',') ptIDs
  8. FROM pt, poly
  9. WHERE st_intersects(poly.geom, pt.geom)
  10. GROUP BY poly.id;
  11.  
  12. polyid | ptids
  13. --------+-------
  14. 1 | 1,2
  15. (1 row)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement