Using
PostgreSQL 10.4, compiled by Visual C++ build 1800, 64-bit
PostGIS 2.4.4
pgRouting 2.6.0
and This Tutorial I am trying to run this Query
$conn = pg_connect($conString);
$sql = "SELECT gid, AsText(geom) AS wkt,
length(geom) AS length, ".TABLE.".id
FROM ".TABLE.",
(SELECT gid, geom
FROM dijkstra_sp_delta(
'".TABLE."',
".$startEdge['source'].",
".$endEdge['target'].",
3000)
) as rt
WHERE ".TABLE.".gid=gid;";
$query = pg_query($conn,$sql);
but I am getting this error:
Warning: pg_query(): Query failed: ERROR: function dijkstra_sp_delta(unknown, integer, integer, integer) does not exist LINE 5: FROM dijkstra_sp_delta( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. in D:\wamp64\www\Route\assets\post.php on line 46
What am I doing wrong?
victoria
and getting same error back