In my database I have two tables where:
Pincontains a column of type point representing lat and long.
Fencecontains (1) a column of type double representing a radius (2) and a foreign key reference to a Pin ID.
Given a lat, long and radius I would like to find any Pin+Fence that intersects (
ST_Intersects) with the given circle.
Since I can't represent/save a circle in PostGIS as is and some answers on Stackoverflow refer to using ST_Buffer. Can I store the output of
ST_Envelope in a new column in the
Fence table and maybe use a trigger to update it (when Pin row get's updated)?