All pastes #911801 Raw Edit

Mine

public text v1 · immutable
·published 2008-02-20 22:48 UTC
rendered paste body
ERROR:  syntax error at or near "$5"
LINE 2: ...1 ||','|| $2 ||') ' ,  $3 ,  $4 , false, false),  $5  as  $5...
                                                             ^
QUERY:  INSERT INTO results_retepd select * FROM shortest_path_astar ('SELECT gid AS id, source::int4, target::int4, length::double precision AS cost,
length::double precision AS reverse_cost,x1,x2,y1,y2 FROM a_getpadova('|| $1 ||','|| $2 ||') ' ,  $3 ,  $4 , false, false),  $5  as  $5 
CONTEXT:  SQL statement in PL/PgSQL function "a_calculateshortestpath_retepd" near line 26

********** Errore **********

ERROR: syntax error at or near "$5"
Stato SQL: 42601
Contesto: SQL statement in PL/PgSQL function "a_calculateshortestpath_retepd" near line 26