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
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 |