Proper entry of polygon type data

From: Peter Willis <peterw(at)borstad(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Proper entry of polygon type data
Date: 2009-03-23 18:13:48
Message-ID: 49C7D15C.5060700@borstad.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I would like to use 'polygon' type data and am wondering about
the entry format of the vertex coordinates.

Are the coordinates of the polygon type to be entered one
entry per polygon vertex, or one entry per polygon edge segment?

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

INSERT INTO my_table (my_polygon_column)
VALUES ( ((Ax,Ay),(Bx,By),(Bx,By),(Cx,Cy),(Cx,Cy),(Ax,Ay)) );

Which entry format is the correct one?

If per vertex format is the correct one, do I need to
'close' the path by entering the first vertex again at the end of the
list?

ie:
INSERT INTO my_table (my_polygon_column)
VALUES ( ((Ax,Ay),(Bx,By),(Cx,Cy),(Ax,Ay)) );

Thanks,

Peter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Erik Jones 2009-03-23 19:04:17 Re: [SQL] bash & postgres
Previous Message justin 2009-03-23 17:48:46 Re: Garbage Collecting