I have two columns latitude and longitude. I am trying to create boundaries such that only points within the boundary is returned. For example i have this static lat/long (40.6681, -73.9806).
There are latitude/longitude coordinates in my database which are not within that static coordinate, how do I only select those coordinates within 40.6681, -73.9806? Here is my query:
select houses from housing where borough = 'BROOKLYN' and latitude + longitude = st_within(40.6681, -73.9806);
The error message I see is:
Hint: No function matches the given name and argument types. You might need to add explicit type casts. Can someone guide me in the right direction?