postgresql7.1
select lpad(' ', (tree_level(tree_sortkey) - 1) * 4) || t.pretty_name,
t.object_type as rel_type
from acs_object_types t
where tree_sortkey like (select tree_sortkey || '%' from acs_object_types
where object_type = :max_object_type_one)
select case when exists (select 1 from acs_object_types t where t.pretty_name = :pretty_name)
then 1 else 0 end
select case when exists (select 1 from acs_object_types t where t.pretty_name = :pretty_name)
then 1 else 0 end