--
-- category_synonym__edit/3
--
create or replace function category_synonym__edit(
  integer,
  character varying,
  character varying
) returns int4 as $$

declare
	p_synonym_id	alias for $1;
	p_new_name	alias for $2;
	p_locale	alias for $3;
begin
	-- update synonym data
	update	category_synonyms
	set	name = p_new_name,
		locale = p_locale
	where	synonym_id = p_synonym_id;

	-- update synonym index and search results
	PERFORM category_synonym__reindex (p_synonym_id, p_new_name, p_locale);

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