-- -- content_item__register_template/3 -- create or replace function content_item__register_template( integer, integer, character varying ) returns int4 as $$ declare register_template__item_id alias for $1; register_template__template_id alias for $2; register_template__use_context alias for $3; begin -- register template if it is not already registered insert into cr_item_template_map select register_template__item_id as item_id, register_template__template_id as template_id, register_template__use_context as use_context from dual where not exists ( select 1 from cr_item_template_map where item_id = register_template__item_id and template_id = register_template__template_id and use_context = register_template__use_context ); return 0; end;$$ language plpgsql;