[postgis-users] functions

[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, 0.01) AND f.gid=' . $_GET['fuse'] . '
  UNION ALL
    SELECT n.gid, n.geom
    FROM electric_line n, flow f
    WHERE ST_DWithin(ST_EndPoint(f.geom),ST_StartPoint(n.geom),0.01)
  )
SELECT *, ST_ASGeoJSON(ST_Transform(geom,4326),6) AS geojson
FROM flow;

   I'd like to make a function flow(gid)

Thanks,

Jon

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131209/474ec5c1/attachment.html>