--
-- category_synonym__del/1
--
create or replace function category_synonym__del(
  integer
) returns int4 as $$

-- delete synonym
declare
	p_synonym_id	alias for $1;
begin
	-- delete search results
	delete	from category_search_results
	where	synonym_id = p_synonym_id;

	-- delete synonym index
	delete	from category_synonym_index
	where	synonym_id = p_synonym_id;

	-- delete synonym
	delete	from category_synonyms
	where	synonym_id = p_synonym_id;

	return (1);
end;$$ language plpgsql;