Christian Quest
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);

--

--

Christian Quest
Christian Quest

Written by Christian Quest

40 ans d'informatique + 33 de base de données + 25 d'internet + 11 de cartographie = #OpenStreetMap + #opendata + #logiciel_libre

No responses yet