<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.</div><div><br></div><div>Regards,</div><div>Sushma</div></div></body></html>