---

SELECT
    n.nspname AS schema_name,
    p.proname AS function_name,
    p.oid,

    p.prosrc ILIKE '%insert into ourpension.contract_params%' AS inserts_contract_params,
    p.prosrc ILIKE '%update ourpension.contract_params%' AS updates_contract_params,

    substring(
        p.prosrc
        FROM greatest(
            CASE
                WHEN position('initial_payment' IN lower(p.prosrc)) > 0
                    THEN position('initial_payment' IN lower(p.prosrc))
                ELSE position('current_payment' IN lower(p.prosrc))
            END - 700,
            1
        )
        FOR 2000
    ) AS fragment

FROM pg_proc p
JOIN pg_namespace n
    ON n.oid = p.pronamespace
WHERE p.oid IN (10106433, 11169609);