How to extract shortest path from floydwarshall algorithm pgrouting

Question

I've tried Floyd-Warshall algorithm using pgrouting with the following code;

SELECT * FROM pgr_floydwarshall(
'SELECT gid AS id, 
      source, 
      target, 
      meters AS cost
      FROM jalan')

and the result is:

The question is How to extract path to new table from the result above if the source node = 9 and target node = 24?

Answer 1

First, to filter your result, simply add your required condition to your query. So here, it's your query with the addition WHERE start_vid = 9 AND end_vid = 24.

Here you can find further info on the usage of WHERE clauses.

After that, just insert your result into your desired table as explained in the documentation.

Answer 2

SELECT * FROM pgr_floydwarshall(
'SELECT gid AS id, 
  source, 
  target, 
  meters AS cost
  FROM jalan')
  WHERE start_vid = 9 AND end_vid = 24;

You were actually computing the shortest path from/to every node you have which was surely taking too much time, you need to add the where clause to you query so you can specify the origin and destination