insert into bt_components
(component_id, project_id, component_name, description, url_name, maintainer)
values
(:component_id, :package_id, :name, :description, :url_name, :maintainer)
update bt_components
set component_name = :name,
description = :description,
maintainer = :maintainer,
url_name = :url_name
where component_id = :component_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