postgresql7.4 select p.instance_name, o.creation_user, o.creation_ip from apm_packages p join acs_objects o on (p.package_id = o.object_id) where p.package_id = :curriculum_id SELECT 1 from cc_curriculum where curriculum_id = :curriculum_id INSERT INTO cc_curriculum (curriculum_id, folder_id, root_keyword_id) VALUES (:curriculum_id, :folder_id, :keyword_id) SELECT cc_curriculum__delete(:curriculum_id) SELECT first_names || ' ' || last_name || ' (' || email || ')' AS name, user_id FROM cc_users SELECT department_name, department_id FROM cc_department WHERE package_id = :package_id