postgresql7.2
select logger_project__new (
:project_id,
:name,
:description,
:project_lead,
:creation_user,
:creation_ip,
:package_id
);
select logger_project__del(:project_id);
select distinct acs_object__name(p.project_lead), project_lead
from logger_projects p,
logger_project_pkg_map ppm
where ppm.project_id = p.project_id
and ppm.package_id = :package_id
select min(p.projection_id)
from logger_projections p
where p.project_id = :project_id
and p.variable_id = :variable_id
and current_timestamp between p.start_time and p.end_time