postgresql7.1
select case when exists (select 1
from acs_object_types t
where t.dynamic_p = 't'
and t.object_type = :value)
then 1 else 0 end
select case when exists (select 1
from acs_object_types t1, acs_object_types t2
where t2.object_type not in (select g.rel_type
from group_type_rels g
where g.group_type = :group_type)
and t1.object_type in ('membership_rel','composition_rel')
and t2.tree_sortkey like t1.tree_sortkey || '%')
then 1 else 0 end