circle @> box, polygon points access - Mailing list pgsql-hackers

From Thomas Simpson
Subject circle @> box, polygon points access
Date
Msg-id 3efc05bc-f11e-43f7-bcc8-0b44f4b152a0@talentstack.to
Whole thread Raw
Responses Re: circle @> box, polygon points access
List pgsql-hackers

Hi

Looking through the archives, around 20 years ago someone asked about getting a list of points from a polygon [15 AUG 2004] and the reply was this was not available but something like point(polygon, n) could be added relatively easily as a new feature to extract points.

I'm hitting an issue trying to check if a box is entirely contained within a circle and I had thought since that comparison is not directly supported to cast the box to a polygon and then check each of the points in the polygon since that is what the circle containing a box is essentially going to do.

However, there does not seem to be an easy way to access the polygon elements either (unnest failed, indexing doesn't work and the point(poly,n) is not there).

Can anyone point me to an approach to do what I need or is this going to be best by adding the box comparison in the mainline code?  I'm happy to take a go if someone points [no pun intended] me to where in the code to go.

Thanks

Tom

pgsql-hackers by date:

Previous
From: Marcos Pegoraro
Date:
Subject: Re: Document NULL
Next
From: Jacob Champion
Date:
Subject: Re: [PoC] Federated Authn/z with OAUTHBEARER