[pgrouting-users] create geometry table with the result

[Pedro Costa]

Thanks to Talin and James but the problem is that the new table has no 
geometry. My difficulty is to give the table geometry. How I do that?

thanks





On 16-03-2012 00:22, James David Smith wrote:
>
> Hi,
>
> Unless I'm missing something, you just need to change the first line to
>
> SELECT * INTO new_table FROM shortest_path( ...... etc.
>
> James
>
> On 16 Mar 2012 00:14, "Pedro Costa" <pedrocostaarma at sapo.pt 
> <mailto:pedrocostaarma at sapo.pt>> wrote:
>
>     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
>     _______________________________________________
>     Pgrouting-users mailing list
>     Pgrouting-users at lists.osgeo.org
>     <mailto:Pgrouting-users at lists.osgeo.org>
>     http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20120316/9da23d21/attachment.html