select 1 from bt_versions where version_id = :version_id insert into bt_versions ( version_id, project_id, version_name, description, anticipated_freeze_date, anticipated_release_date, actual_freeze_date, actual_release_date, maintainer, supported_platforms, assignable_p ) values ( :version_id, :package_id, :version_name, :description , $anticipated_freeze_date, $anticipated_release_date, $actual_freeze_date, $actual_release_date, :maintainer, :supported_platforms, :assignable_p ) update bt_versions set version_id = :version_id, project_id = :package_id, version_name = :version_name, description = :description, anticipated_freeze_date = $anticipated_freeze_date, anticipated_release_date = $anticipated_release_date, actual_freeze_date = $actual_freeze_date, actual_release_date = $actual_release_date, maintainer = :maintainer, supported_platforms = :supported_platforms, assignable_p = :assignable_p where version_id = :version_id select version_id, version_name, description, to_char(anticipated_freeze_date, 'YYYY MM DD HH24 MI') as anticipated_freeze_date, to_char(anticipated_release_date, 'YYYY MM DD HH24 MI') as anticipated_release_date, to_char(actual_freeze_date, 'YYYY MM DD HH24 MI') as actual_freeze_date, to_char(actual_release_date, 'YYYY MM DD HH24 MI') as actual_release_date, maintainer, supported_platforms, assignable_p from bt_versions where version_id = :version_id select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id from cc_users u where upper(coalesce(u.first_names || ' ', '') || coalesce(u.last_name || ' ', '') || u.email || ' ' || coalesce(u.screen_name, '')) like upper('%'||:value||'%') order by name