postgresql7.1
select case when exists (
select 1
from application_group_element_map
where package_id = :package_id
and element_id = :party_id
union all
select 1
from application_groups
where package_id = :package_id
and group_id = :party_id
) then 1 else 0 end
select case when exists (
select 1
from application_group_element_map
where package_id = :package_id
and element_id = :party_id
union all
select 1
from application_groups
where package_id = :package_id
and group_id = :party_id
) then 1 else 0 end
select case when exists (
select 1
from application_group_element_map
where package_id = :package_id
and rel_id = :rel_id
) then 1 else 0 end
select case when exists (
select 1
from application_group_segments
where package_id = :package_id
and segment_id = :segment_id
) then 1 else 0 end
select application_group__group_id_from_package_id (
:package_id,
:no_complain_p
)
select ag.group_id as parent_group_id
from application_groups ag,
apm_packages,
(select object_id, 1 as tree_rownum
from site_nodes
where tree_sortkey like (select tree_sortkey from site_nodes where node_id = :node_id) || '%') nodes
where nodes.object_id = apm_packages.package_id
and apm_packages.package_id = ag.package_id
limit 1
select application_group__new (
:group_id,
:group_type,
now(),
:creation_user,
:creation_ip,
:email,
:url,
:group_name,
:package_id,
:context_id
)
select composition_rel__new (
null,
'composition_rel',
:parent_group_id,
:group_id,
:creation_user,
:creation_ip
)