-- -- 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;