Cheers - I'd tried postGIS on 9.6 but had install issues. Installed first time on 10 :)
-----Original Message----- From: Andreas Kretschmer [mailto:andr...@a-kretschmer.de] Sent: 16 March, 2018 11:46 AM To: pgsql-general@lists.postgresql.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