Re: spatial composition operators for PG - Mailing list pgsql-general

From Martin Gainty
Subject Re: spatial composition operators for PG
Date
Msg-id BAY108-DAV10C4701FB374DDC6B894F7AE760@phx.gbl
Whole thread Raw
In response to spatial composition operators for PG  ("Galkowski, Jan" <jgalkows@akamai.com>)
List pgsql-general
Jan-

check out
http://postgis.refractions.net/

M--
----- Original Message -----
From: "Galkowski, Jan" <jgalkows@akamai.com>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, November 27, 2007 6:02 PM
Subject: [GENERAL] 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


pgsql-general by date:

Previous
From: "Galkowski, Jan"
Date:
Subject: spatial composition operators for PG
Next
From: Scott Ribe
Date:
Subject: Re: Linux v.s. Mac OS-X Performance