Bear with me as I'm new to PostGIS and GIS in general. I also don't know the domain well enough to create a good title for this post! Here is what I'm trying to accomplish:
I have Venues in my system. Each Venue has a promotion radius in miles. Given an arbitrary point (lat/lng), I want to find all the Venues which encompass the arbitrary point in their promotion radius.
Here's what venues tables look like:
venues id | name | latitude | longitude | promo_radius
Is this possible with PostGIS? Are there any resources that would help me further understand the query?