[postgis-users] Obtaining vertex order...

Manu manuelfgm at gmail.com
Fri Jul 20 04:10:08 PDT 2007

Hi, I am trying to create a table of vertex of a family of polygons, order
by the distance to a point (3.2 -35.9). I need also a integer column id.

I made this:
create table wp_obs as select Pointn(exteriorring(obstacles.geom ),
generate_series(1,npoints(obstacles.geom)-1)) as geom, nextval('wp_seq3') as
id from obstacles, place where obstacles.geom && place.geometry and
intersects(place.geometry,obstacles.geom) order by distance
(Pointn(exteriorring( obstacles.geom), generate_series(1,npoints(
obstacles.geom)-1)),GeomFromText('POINT(3.2 -35.9)',-1));

But id is not from ordered from 1. It seems that it creates table firts to
order later... How can I get id ordered?? I tried to do alter table with
generate series, but i coudn't make it work...



manuelfgm at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070720/6e5023be/attachment.html>

More information about the postgis-users mailing list