Hi Sushma I have used plpgsql very successfully together with Tobin Bradley's RESTful Web Service Framework (www.fuzzytolerance.info/projects ). All I do is set the function to return a text data type and then format the in-function result as a geojson string. The geojson response can then be directly displayed in openlayers or even loaded into a GeoExt featuregrid.
It is also possible to use the same framework with gml instead of geojson (but I prefer the geojson way...) Hope this helps. Regards Glenn Mullett BTech(Nature Cons) PGDip(UNIGIS) H.O.D. GIS Lidwala Consulting Engineers On Wed, 2011-08-17 at 17:27 +0100, Sush Pokharel wrote: > Hi guys, > > > I want to implement pgrouting using openlayer. I want to get the > shortest route from one building to another building > 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 > > Can any of you guys suggest me how PL/pgSQL function can be displyed > on map using openlayer. > 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 . > > > Regards, > Sushma > > _______________________________________________ > Users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/openlayers-users
_______________________________________________ Users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/openlayers-users
