gistfile1.txt

create type search.amounts_by_code as (total integer, purpose_code text);

create or replace function search.amount_by_code(auser text, apath jsonb, args jsonb)
  returns setof search.amounts_by_code as $$

  select (sum(amount), purpose_codes)::search.amounts_by_code
      from working_transactions
      where tran_date > '2012-01-01' and tran_date < '2013-01-01'
      and filer ilike '%' || (apath->>0) || '%'
  group by purpose_codes order by sum(amount) desc;

$$ language sql;