postgresql7.1 select case when exists (select 1 from pg_proc where proname like :package_name || '%') then 1 else 0 end select case when exists (select 1 from acs_object_types t where t.object_type = :group_type) then 1 else 0 end select drop_package('[DoubleApos $group_type]') begin delete from group_type_rels where group_type = :group_type; return 1; end; select acs_object_type__drop_type(:group_type, 'f') begin drop table $table_name; return 1; end; begin delete from group_types where group_type=:group_type; return 1; end;