--
-- category_link__new/2
--
create or replace function category_link__new(
  integer,
  integer
) returns int4 as $$

	-- function for adding category links
declare
	p_from_category_id	alias for $1;
	p_to_category_id	alias for $2;
	v_link_id		integer;
begin
	v_link_id := nextval ('category_links_id_seq');

	insert into category_links (link_id, from_category_id, to_category_id)
	values (v_link_id, p_from_category_id, p_to_category_id);

	return v_link_id;
end;$$ language plpgsql;