I have a multipolygon of geography type (
multi_bounds) and a point. I'm trying to figure out the fastest way to query whether the multipolygon contains the point. In this case if the point is part of the boundary it should still return true.
I've tried CoveredBy:
WHERE ST_CoveredBy(ST_SetSRID(ST_MakePoint(:long, :lat), 4326),
:lat are arguments provided by yesql.
And I've tried contains:
ST_SetSRID(ST_MakePoint(:long, :lat), 4326))
I don't see a noticeable difference and I'm wondering what the best practice is here.
I did try
ST_CoveredBy without casting
multi_bounds to geometry but I couldn't get past an error:
org.postgresql.util.PSQLException: ERROR: BOOM! Could not generate outside point!