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...
Thanks
--
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
Manuel
[EMAIL PROTECTED]
http://manuelfgm.blogspot.com
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
