[pgrouting-users] create geometry table with the result

[James David Smith]

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> 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 <Pgrouting-users at lists.osgeo.org>
> http://lists.osgeo.org/**mailman/listinfo/pgrouting-**users<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/be5c364d/attachment.html