Hi All,<br><br>I just started using pgrouting. I followed the tutorial with my own data and have everything setup but when I run:<br><br><br>SELECT astext(required_roads.the_geom), required_roads.name FROM<br><br> shortest_path_dijkstra1_as_geometry_internal_id ( <br>
'required_roads',18583::integer, 18597::integer, 300::double precision) <br> AS T1 INNER JOIN required_roads on required_roads.gid=T1.gid;<br><br><br>I get this error message:<br><br>ERROR: operator does not exist: text || boolean<br>
SQL state: 42883<br>Hint: No operator matches the given name and argument type(s). You may need to add explicit type casts.<br>Context: PL/pgSQL function "shortest_path_dijkstra1_as_geometry_internal_id_directed" line 100 at assignment<br>
PL/pgSQL function "shortest_path_dijkstra1_as_geometry_internal_id" line 15 at for over execute statement<br><br><br><br>As shown in the code above I added in explicit type casts but still no joy.<br><br><br>Can anyone tell me what the problem is?<br>
<br><br>Thanks<br>