Guest
Public paste!

Untitled

By: a guest | Dec 4th, 2007 | Syntax: SQL | Size: 0.33 KB | Hits: 297 | Expires: Never
Copy text to clipboard
  1. SELECT * FROM shortest_path_shooting_star('
  2.  
  3. SELECT gid as id,
  4.  
  5. source::integer, target::integer, length::double precision as cost, rcost::double precision as reverse_cost, x1, y1, x2, y2, rule, to_cost
  6.  
  7. FROM streets',
  8.  
  9. give_source('POINT(640905 225230)',1000,200), give_target('POINT(640982 225439)',1000,200),
  10.  
  11. false,true);