CREATE OR REPLACE FUNCTION get_cv_id_for_relation() RETURNS BIGINT AS 'SELECT cv_id FROM cv WHERE name=''relationship''' LANGUAGE 'sql'; CREATE OR REPLACE FUNCTION get_cvterm_id_for_is_a() RETURNS BIGINT AS 'SELECT cvterm_id FROM cvterm WHERE name=''is_a'' AND cv_id=get_cv_id_for_relation()' LANGUAGE 'sql';