From: Scott C. <sco...@us...> - 2005-12-27 20:58:37
|
Update of /cvsroot/gmod/schema/chado/modules/sequence/functions In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv6614/modules/sequence/functions Modified Files: sequtil.plpgsql Log Message: adding the ability to do sub components in the Tk tool and adding a dependency on gencode for the sequence-dbapi, and fixing a problem with function declaration ordering in sequtil.plpgsql Index: sequtil.plpgsql =================================================================== RCS file: /cvsroot/gmod/schema/chado/modules/sequence/functions/sequtil.plpgsql,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** sequtil.plpgsql 25 Jul 2005 21:19:35 -0000 1.2 --- sequtil.plpgsql 27 Dec 2005 20:58:30 -0000 1.3 *************** *** 27,35 **** LANGUAGE 'sql'; - -- DNA to AA, default genetic code - CREATE OR REPLACE FUNCTION translate_dna(TEXT) RETURNS TEXT AS - 'SELECT translate_dna($1,1)' - LANGUAGE 'sql'; - -- DNA to AA CREATE OR REPLACE FUNCTION translate_dna(TEXT,INT) RETURNS TEXT AS --- 27,30 ---- *************** *** 57,60 **** --- 52,61 ---- language plpgsql; + -- DNA to AA, default genetic code + CREATE OR REPLACE FUNCTION translate_dna(TEXT) RETURNS TEXT AS + 'SELECT translate_dna($1,1)' + LANGUAGE 'sql'; + + CREATE OR REPLACE FUNCTION translate_codon(TEXT,INT) RETURNS CHAR AS 'SELECT aa FROM genetic_code.gencode_codon_aa WHERE codon=$1 AND gencode_id=$2' |