Thanks Stephen. That's exactly what I was looking for. --Jack
-----Original Message----- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Stephen Woodbridge Sent: Tuesday, May 08, 2012 10:32 AM To: postgis-users@postgis.refractions.net Subject: Re: [postgis-users] building a polygon with variables On 5/8/2012 10:26 AM, Gold, Jack L (US SSA) wrote: > I'm not even sure how to express this properly, but I'll try. I'm > trying to build a query which will select positions within a specified > polygon. > I have the query: > > SELECT * FROM positions WHERE ST_Within(geometry(positions.location), > ST_GeomFromText('POLYGON((l b, r b, r t, l t, l b))'::text, 4326)); > > I want to be able to replace l, b, r, and t with variable values in a > plpgsql function like so: > > $BODY$ > > DECLARE > > l integer; > > r integer; > > b integer; > > t integer; > > BEGIN > > SELECT pli_config.filter_left_longitude INTO l FROM pli_config; > > SELECT pli_config.filter_right_longitude INTO r FROM pli_config; > > SELECT pli_config.filter_bottom_latitude INTO b FROM pli_config; > > SELECT pli_config.filter_top_latitude INTO t FROM pli_config; > > SELECT * FROM positions > > WHERE st_within(geometry(positions.location), > st_geomfromtext('POLYGON((l b,r b,r t,l t,l b))'::text, 4326)); 'POLYGON(('||l||' '||b||','||r||' '||b||','.... > END; > > $BODY$ > > The problem I have is I don't know the proper syntax to replace the > variables in the single-quoted statement or even if it is possible. > Any ideas? > > --Jack Gold > > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users