<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Thanks to Talin and James <span id="result_box" class="" lang="en"><span
class="hps">but the problem</span> <span class="hps">is that</span>
<span class="hps">the new table</span> <span class="hps">has no</span>
<span class="hps">geometry.</span> <span class="hps">My</span> <span
class="hps">difficulty is</span> <span class="hps">to give the
table</span> <span class="hps">geometry. How I do that?<br>
<br>
thanks</span><span class=""></span></span><br>
<br>
<br>
<br>
<br>
<br>
On 16-03-2012 00:22, James David Smith wrote:
<blockquote
cite="mid:CAMu32AALbYqvCe9PCTGQwRd2nYSdsV_C1h88akuNUGUEKibZ1g@mail.gmail.com"
type="cite">
<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
moz-do-not-send="true" 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>
_______________________________________________<br>
Pgrouting-users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Pgrouting-users@lists.osgeo.org"
target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
<a moz-do-not-send="true"
href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users"
target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
</blockquote>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Pgrouting-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a>
</pre>
</blockquote>
<br>
</body>
</html>