1 min readOct 25, 2019
Why use a subquery initially ?
I would have done it with a JOIN:
SELECT build.* FROM research_area.buildings build JOIN research_area.landuse land ON ST_Intersects(build.geom, land.geom);
Why use a subquery initially ?
I would have done it with a JOIN:
SELECT build.* FROM research_area.buildings build JOIN research_area.landuse land ON ST_Intersects(build.geom, land.geom);
40 ans d'informatique + 33 de base de données + 25 d'internet + 11 de cartographie = #OpenStreetMap + #opendata + #logiciel_libre