File: cv-helper.plpgsql

package info (click to toggle)
libchado-perl 1.23-2
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 23,976 kB
  • ctags: 10,378
  • sloc: xml: 192,540; sql: 165,945; perl: 28,339; sh: 101; python: 73; makefile: 46
file content (6 lines) | stat: -rw-r--r-- 307 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
 

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