postgresql7.1 select rel_constraint__new( null, 'rel_constraint', :constraint_name, :segment_id, 'two', rel_segment__get(:supersite_group_id, 'membership_rel'), null, :user_id, :creation_ip ); select t.pretty_name as package_name, acs_object__name(s.object_id) as object_name from site_nodes s, apm_package_types t where s.node_id = :node_id and t.package_key = :package_key select case when exists (select 1 from acs_object_types where supertype = :object_type) then 1 else 0 end select t2.object_type from acs_object_types t1, acs_object_types t2 where t1.object_type = :object_type and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey) order by t2.tree_sortkey desc select pretty_name, package_key from apm_package_types where not (apm_package__singleton_p(package_key) = 1 and apm_package__num_instances(package_key) >= 1) and package_key != 'acs-subsite' order by upper(pretty_name)