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 |