...@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
-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
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,
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
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
[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