Am 16.03.2018 um 11:00 schrieb Martin Moore:
PG10
Is there an operator to determine if a box and circle intersect?
I can only see box && box and can use centre+rad and distance to calculate
circle:circle.
Thanks.
please don't hijack other mail-threads by answering & changing the
subject, your mail still contains references to "SELECT .. FOR UPDATE:
find out who locked a row"
Create a new mail for a new thread!
to your question: consider PostGIS and it's functions st_intersects()
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
