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