[OpenLayers-Users] Re: displaying PL/pgSQL shortest path function using openlayer

[Stephen Woodbridge]

On 8/21/2011 1:59 PM, sushma wrote:
> Hi guys,
> Below is my query result after calling the function written in pl/pgsql
> language. I wanted to display this
> result as a layer on the map using openlayer. As i am very new to json can u
> guys plz suggest me i could i format this in json
>
>
>
>
>
> testdb=# select road(1375,59);
>               road
> -------------------------------
>   (12348,8059,249.737504252945)
>   (12654,8286,219.425248073402)
>   (12992,8613,123.671322795878)
>   (13192,8699,55.2201869018148)
>   (13433,8734,106.426985819356)
>   (433,-1,0)
> (6 rows)


You need to provide more information when you post. Your questions tend 
to be vary vague, you do not provide any details of what your data 
tables look like, what have you tried already?

Your function outputs three columns, you do not tell us:

what the columns are?
What do expect to see on your map if you had it working?
what data tables are you working with?

-Steve