I have to use the A* algorithm and my geometry is in multilinestring and I want to take stratpoint(x1,y1) and endpoint(x2,y2) . I use this queries but the columns after the execute is still empty
UPDATE roads SET x1 = ST_x(ST_startpoint(geom)); UPDATE roads SET y1 = ST_y(ST_startpoint(geom)); UPDATE roads SET x2 = ST_x(ST_endpoint(geom)); UPDATE roads SET y2 = ST_y(ST_endpoint(geom));
after the execution give this message
Query returned successfully: 2584 rows affected, 101 ms execution time.
Then I make a select and the columns are empty
I searched the net and I didn't find anything, I don't know what I can do.