[postgis-users] Making links

[Gustavo Ces]

Hi all,

    I´ve got a railway linestring table and a railstation point table. Some linestring´s nodes are stations, and others aren´t. I have to extract a links table  from the linestring one,  with this structure

link      StartStation     EndStation

I´m trying to do it with ogr&python, but perhaps there is an easiest way to achive this in PostGis. Any help?

Thanks in advance,

Gus
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20071024/dd1de677/attachment.html>