Thanks for the quick response. I'll elaborate on the actual problem. Basically, I want to call:
select * from partiesWithin("DAYTONA", "FL", 5);
The partiesWithin() function finds all zip codes (and zip_code centroids), then searches a 5 (or n) mile radius around those centroids for parties. Since each zip code has a 'point' column which is a PostGIS feature, I need to iterate through each of those points, and search for parties within 5 miles of each of the centroids, returning a concatenated query of all parties that were found in any of the queries. Someone mentioned that one way to do that is to use a temporary table inside the partiesWithin function. Any thoughts?
On Mon, May 16, 2011 at 1:28 AM, John R Pierce <pierce@xxxxxxxxxxxx> wrote:
On 05/15/11 8:53 PM, Bernardo Telles wrote:all the queries would have to have the same fields to do this. Âif they do, then you can write it as a join or union.
Hi there,
We'd like to use a plpgsql function to use results from query A to execute several queries B, C, etc., and return the results of all B, C, etc queries as one result set. Would placing 'RETURN QUERY' inside a loop automatically concatenate all 'return query' results in the function's return? If not, how would we go about getting this result?
in your example case, its easy.
 Âselect * from locations l join zipcode z on l.state = z.state where z.zipcode like '32301%';
this also would be more efficient than the way you proposed
now, if you're thinking of a DIFFERENT problem thats more complex to solve, well, without knowing the actual problem there's not much I can suggest.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
