postgresql7.4
SELECT lrc_lab__new (
NULL,
:name,
:description,
:instructor_id,
$start_date,
$end_date,
:package_id,
now(),
:user_id,
:peeraddr,
:package_id
)
UPDATE lrc_lab
SET name = :name,
description = :description,
instructor_id = :instructor_id,
start_date = $start_date,
end_date = $end_date
WHERE lab_id = :lab_id
UPDATE acs_objects
SET modifying_user = :modifying_user,
modifying_ip = :modifying_ip,
package_id = :package_id
WHERE object_id = :lab_id