function returning a merge of the same query executed X time

From: Marc-André Goderre <magoderre(at)cgq(dot)qc(dot)ca>
To: "'pgsql-general(at)postgresql(dot)org' (pgsql-general(at)postgresql(dot)org)" <pgsql-general(at)postgresql(dot)org>
Subject: function returning a merge of the same query executed X time
Date: 2015-04-22 13:14:28
Message-ID: D8DAC91BA6256246BA3FF835F6AAA1189943EC2B@SI-MB01.cegep-chicoutimi.qc.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,
I'm having difficulties to create a function that should execute X time the same query and return their results as a single table.
I tried this way but it don't work :
Thanks to help.

create function cm_get_json_loop_info(
IN profile integer,
IN distance double precision DEFAULT 10,
IN x_start double precision DEFAULT 0,
IN y_start double precision DEFAULT 0,
IN nbr integer default 1)

returns setof json as
$BODY$
declare jsona json;
BEGIN
for json a i in 1.. nbr loop

select row_to_json(q)
from (select row_number() over() as id, sum(cost) as total_cost,sum(length) as total_length,json_agg(row_to_json(r)) as data
from (select * from cm_get_loop_route_4(2, 10, -73.597070, 45.544083))r)q
return next jsona
end loop;
return jsona;

Marc

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim Nasby 2015-04-22 15:21:09 Re: function returning a merge of the same query executed X time
Previous Message Keith Fiske 2015-04-21 23:12:15 Re: Background worker assistance & review