CREATE OR REPLACE FUNCTION afiche_tariff2(integer)
  RETURNS json AS
$BODY$select array_to_json (array_agg(row)) from (select  star_type, star_class, star_direction, srot_code, star_begin_min, star_begin_max, star_stay_min, star_stay_max,  star_muststay, array(select k from ( select spet_code,  array(select i from ( select spri_base_value, spri_surcharge_value, spri_taxes_value from sto_price where star_id= sto_tariff.star_id and spet_id=sto_persontype.spet_id) as i) as price, array(select j from(select spri_base_rebat,spri_surcharge_rebat,spri_taxes_rebat from sto_price where spet_id=sto_persontype.spet_id and star_id=sto_tariff.star_id) as j) as rebat from sto_persontype ) as k) as persontype
from sto_tariff, sto_route, sto_tariff_route, sto_price
where sagr_id=$1 and sto_tariff.star_id=sto_tariff_route.star_id and sto_route.srot_id=sto_tariff_route.srot_id and sto_tariff.star_id=sto_price.star_id
group by sto_tariff.star_id, star_type, star_class, star_direction, srot_code, star_begin_min, star_begin_max, star_stay_min, star_stay_max,  star_muststay)row;$BODY$
  LANGUAGE sql VOLATILE
  COST 100;