-- -- content_type__register_mime_type/2 -- create or replace function content_type__register_mime_type( character varying, character varying ) returns int4 as $$ declare register_mime_type__content_type alias for $1; register_mime_type__mime_type alias for $2; v_valid_registration integer; begin -- check if this type is already registered select count(*) into v_valid_registration from cr_mime_types where not exists ( select 1 from cr_content_mime_type_map where mime_type = register_mime_type__mime_type and content_type = register_mime_type__content_type ) and mime_type = register_mime_type__mime_type; if v_valid_registration = 1 then insert into cr_content_mime_type_map ( content_type, mime_type ) values ( register_mime_type__content_type, register_mime_type__mime_type ); end if; return 0; end;$$ language plpgsql;