postgresql7.4 SELECT n.uos_code FROM cc_uos_name n, cc_uos u WHERE u.uos_name_id = n.name_id AND u.uos_id = :uos_id SELECT s.latest_revision_id FROM cc_uos u, cc_uos_revisions r, cr_items i, cc_uos_textbook_set s WHERE u.uos_id = :uos_id AND i.item_id = u.uos_id AND r.uos_revision_id = i.latest_revision AND s.parent_uos_id = :uos_id SELECT cc_uos_textbook__map ( :latest_revision_id, :textbook_id ); UPDATE cc_uos_textbook SET title = :title, author = :author, publisher = :publisher, isbn = :isbn WHERE textbook_id = :textbook_id UPDATE acs_objects SET modifying_user = :modifying_user, modifying_ip = :modifying_ip, package_id = :package_id WHERE object_id = :textbook_id