Hi Brent,
I am aware of PostGIS and already use it. My question was regarding
the entry format of PostgreSQL polygon data. There is a void
in the PostgreSQL documentation regarding this.
Incidentally, PostGIS uses PostgreSQL polygon, point, and path
data types.
Using PostGIS for simple ,
On Mon, Mar 23, 2009 at 2:13 PM, Peter Willis pet...@borstad.com wrote:
For example:
I have a triangle with vertex corners A, B, C.
One entry per vertex format suggests
INSERT INTO my_table (my_polygon_column)
VALUES ( ((Ax,Ay),(Bx,By),(Cx,Cy)) );
One entry per edge format suggests
Mark Cave-Ayland wrote:
Peter Willis wrote:
Incidentally, PostGIS uses PostgreSQL polygon, point, and path
data types.
Errr... no it doesn't. PostGIS uses its own internal types to represent
all the different geometries, although it does provide a cast between
the existing PostgreSQL types
Hi Peter,
If you want to use Postgres to store/manage/query spatial data, I strongly
recommend you look at PostGIS, not the native Postgres geometry types.
Brent Wood
Brent Wood
DBA/GIS consultant
NIWA, Wellington
New Zealand
Peter Willis pet...@borstad.com 03/24/09 10:35 AM
Hello,
I