-- -- apm_package__parent_id/1 -- create or replace function apm_package__parent_id( integer ) returns int4 as $$ declare apm_package__parent_id__package_id alias for $1; v_package_id apm_packages.package_id%TYPE; begin select sn1.object_id into v_package_id from site_nodes sn1 where sn1.node_id = (select sn2.parent_id from site_nodes sn2 where sn2.object_id = apm_package__parent_id__package_id); return v_package_id; end;$$ language plpgsql;