[pgrouting-users] create geometry table with the result

[Pedro Costa]

Hello to all,

Can anybody help me to solve this problem:

I want to create a geometry table with the result of this query:


SELECT * FROM shortest_path
('SELECT gid AS id,
source::int4 AS source,
target::int4 AS target,
lenght::float8 AS cost
FROM passeios',
438,
439,
false,
false)

someone know how I do that?
thanks