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