Debian Codegraph @

modules/cv/functions/cv-helper.plpgsql

raw
1
2 CREATE OR REPLACE FUNCTION get_cv_id_for_relation() RETURNS BIGINT
3 AS 'SELECT cv_id FROM cv WHERE name=''relationship''' LANGUAGE 'sql';
4 CREATE OR REPLACE FUNCTION get_cvterm_id_for_is_a() RETURNS BIGINT
5 AS 'SELECT cvterm_id FROM cvterm WHERE name=''is_a'' AND cv_id=get_cv_id_for_relation()' LANGUAGE 'sql';
6