RE: Circle and box intersect

Cheers - I'd tried postGIS on 9.6 but had install issues. Installed first time on 10 :)

-----Original Message-----
From: Andreas Kretschmer [mailto:andreas(at)a-kretschmer(dot)de]
Sent: 16 March, 2018 11:46 AM
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Circle and box intersect

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