File: feature.plpgsql

package info (click to toggle)
libchado-perl 1.31-7
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 44,728 kB
  • sloc: sql: 282,721; xml: 192,553; perl: 25,524; sh: 102; python: 73; makefile: 57
file content (9 lines) | stat: -rw-r--r-- 278 bytes parent folder | download | duplicates (4)
1
2
3
4
5
6
7
8
9
-- depends on sequence-cv-helper
CREATE OR REPLACE FUNCTION get_feature_id(VARCHAR,VARCHAR,VARCHAR) RETURNS BIGINT
 AS '
  SELECT feature_id 
  FROM feature
  WHERE uniquename=$1
    AND type_id=get_feature_type_id($2)
    AND organism_id=get_organism_id($3)
 ' LANGUAGE 'sql';