I have got stuck with a dynamic analysis that I would like to include in a project I am working with. I want to save the query in the project file or make it to a view in my database. I have tried a couple of combination without success so far, but I am on a SQL learning curve =).
I would like to combine the queries below so that my
ST_buffer is used in the same query as the layer where
building.geom need to be completely inside.
Is this possible?
SELECT event_point.id, event_point.geom, st_buffer(event_point.geom, 100) AS "Buffer", FROM public.event_point SELECT building.id building.address FROM building, "Buffer" WHERE ST_within(building.geom, "Buffer".geom)