[postgis-users] points to lines [Clarification]

[ahmed at elegantdesigns.ca]

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