i am resubmitting this as I missed an important fact. Hello list,
** I have a [edit]non geometric[/edit] table in the following format: id node_1 node_2 weight 1 1 2 5.4 2 1 3 2 3 2 4 6 4 4 4 1 the table is about 2,000 rows long. ** I also have a point table gid the_geom node_id - - - i was wondering what query should i do so i can create * a line table between the corresponding nodes, and add to that * a weight field/attribute that corresponds to the newly created link Thank you, dassouki _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users