Re: [postgis-users] functions

2013-12-10 Thread Rémi Cura
...@lists.osgeo.org] *On Behalf Of *Jonatan Malaver *Sent:* Monday, December 09, 2013 8:52 PM *To:* PostGIS Users Discussion *Subject:* Re: [postgis-users] functions Thank you!!! Jon *From:* postgis-users-boun...@lists.osgeo.org [ mailto:postgis-users-boun...@lists.osgeo.orgpostgis

Re: [postgis-users] functions

2013-12-10 Thread Jonatan Malaver
-boun...@lists.osgeo.org] On Behalf Of Rémi Cura Sent: Tuesday, December 10, 2013 5:21 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] functions On a more high level: I'm guessing you are using the recursive cte to walk trough a graph. There are ways to accelerate this, but at the cost

[postgis-users] functions

2013-12-09 Thread Jonatan Malaver
Hello, I'm new to postgis/postgresql. I was wondering if anyone could tell me how to make a function out of this sql query: WITH RECURSIVE flow(gid, geom) AS ( SELECT e.gid, e.geom FROM electric_line e, fuses f WHERE ST_DWithin(ST_AsText(e.geom)::geometry, ST_AsText(f.geom)::geometry,

Re: [postgis-users] functions

2013-12-09 Thread Jonatan Malaver
Thank you!!! Jon From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of tommaso Sent: Monday, December 09, 2013 12:57 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] functions This should work: create or replace function flow

Re: [postgis-users] functions

2013-12-09 Thread Jonatan Malaver
Subject: Re: [postgis-users] functions Thank you!!! Jon From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of tommaso Sent: Monday, December 09, 2013 12:57 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] functions This should work

Re: [postgis-users] functions

2013-12-09 Thread tommaso
[mailto:postgis-users-boun...@lists.osgeo.org] *On Behalf Of *Jonatan Malaver *Sent:* Monday, December 09, 2013 8:52 PM *To:* PostGIS Users Discussion *Subject:* Re: [postgis-users] functions Thank you!!! Jon *From:*postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-boun...@lists.osgeo.org