<p>Hi,</p>
<p>Unless I'm missing something, you just need to change the first line to</p>
<p>SELECT * INTO new_table FROM shortest_path( ...... etc.</p>
<p>James </p>
<div class="gmail_quote">On 16 Mar 2012 00:14, "Pedro Costa" <<a href="mailto:pedrocostaarma@sapo.pt">pedrocostaarma@sapo.pt</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hello to all,<br>
<br>
Can anybody help me to solve this problem:<br>
<br>
I want to create a geometry table with the result of this query:<br>
<br>
<br>
SELECT * FROM shortest_path<br>
('SELECT gid AS id,<br>
source::int4 AS source,<br>
target::int4 AS target,<br>
lenght::float8 AS cost<br>
FROM passeios',<br>
438,<br>
439,<br>
false,<br>
false)<br>
<br>
someone know how I do that?<br>
thanks<br>
______________________________<u></u>_________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.<u></u>org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/<u></u>mailman/listinfo/pgrouting-<u></u>users</a><br>
</blockquote></div>