Re: spatial composition operators for PG

From: "Martin Gainty" <mgainty(at)hotmail(dot)com>
To: "Galkowski, Jan" <jgalkows(at)akamai(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: spatial composition operators for PG
Date: 2007-11-27 23:27:24
Message-ID: BAY108-DAV10C4701FB374DDC6B894F7AE760@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jan-

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

M--
----- Original Message -----
From: "Galkowski, Jan" <jgalkows(at)akamai(dot)com>
To: <pgsql-general(at)postgresql(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brendan Jurd 2007-11-27 23:57:14 Re: [GENERAL] Empty arrays with ARRAY[]
Previous Message Galkowski, Jan 2007-11-27 23:02:49 spatial composition operators for PG