---

select
    p.proname as function_name,
    btrim(line) as source_line
from pg_proc p
join pg_namespace n
    on n.oid = p.pronamespace
cross join lateral regexp_split_to_table(p.prosrc, E'\n') as line
where n.nspname = 'ourpension'
  and line ilike '%npo_agreement_id%'
order by p.proname;