<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div>Hi guys,</div>
<div><br>
</div>
<div>I want to implement pgrouting using openlayer. I want to get the shortest route from one building to another building</div>
<div>and i have written a
PL/pgSQL(this is an procedural language which helps to iterate and put
more than one sql queries together) function to find the shortest route from one building to another and i wanted to use this PL.pgSQL function in openlayer such that the routes can be return on the map<br>
</div>
<div>Can any of you guys suggest me how PL/pgSQL function can be displyed on map using openlayer.</div>
<div>So far i can display the map from postgis database using geoserver and openlayer and can set the start and end point as a layer using openlayer .</div>
<div><br>
</div>
<div>Regards,</div>
<div>Sushma</div></div></body></html>