On 05/15/11 8:53 PM, Bernardo Telles wrote:
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?
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.
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
