Jan- check out http://postgis.refractions.net/ M-- ----- Original Message ----- From: "Galkowski, Jan" <jgalkows@xxxxxxxxxx> To: <pgsql-general@xxxxxxxxxxxxxx> Sent: Tuesday, November 27, 2007 6:02 PM Subject: spatial composition operators for PG Are there any standard spatial composition operators people use for PG's polygon and path data types? That is, it seems there ought to be extenders of the signatures, polygon <- polygon %+% (point, vertex-number) path <- path %+% (point, node-number) where the right-hand-sided point is the new point, and the vertex-number or node-number tell where to put it. This function might be an update-in-place. I saw nothing like this in the PG docs, but I figured people probably made such things up. Any pointers? Anyone willing to share their favorites online some place? TIA, - Jan ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
