[pgrouting-users] pgRouting dijkstra (points and lines)

[dy32 mutQ]

hello all, 
I have a question, how can I get the shortest path with dijkstra algorithm on a map but additionally have another layer or points of interest files from the map.
I set up pgrouting from http://www.utdallas.edu/~ama054000/rt_tutorial.html

for example: I have two layers, hotel (points) and road (polylines)
>From hotel A (start point) to hotel B (end point) I can get road 2,3,4

there is any way to integrate these two files (point and line) into one so that for the calculations. In other words, how can I connect two tables, road and hotel to get dijkstra result?

Thanks for your answers
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20111012/95b80556/attachment.html