Does PostgreSQL have a function that determines whether the point lies on the border of the polygon or is its vertex?

  • Seriously? PostgreSQL now we have a graphics engine? and how are you not knowing the "vertices" of the polygon gathered to determine whether the point is its vertex? - Vladimir Klykov
  • Probably your sarcasm should be restrained a little by explaining the problem. In one table I have POLYGON () polygons, in another table there are POINT () points. I check for hitting a point in a polygon using the '@>' function. But I admit that some points may lie on the boundaries of polygons or on their tops. - Cold Pol
  • one
    Probably you will get an answer for the simple reason that it’s not clearer from the word at all =) You have a database and you want to do some mathematical operations on its side =) this is all that is clear at the moment =) Not a description of the structure of the tables , there are no descriptions that you have already done yourself - no, there is no imputed description of the desired result, all the more so. And after that, are you still talking about my sarcasm?) And yes, my answer to you in advance is that the DATABASE MUST BE STORED AND ISSUED BY DATA , and not their processing and modification =) - Vladimir Klykov

0