CREATE OR REPLACE FUNCTION store_db (VARCHAR) RETURNS BIGINT AS 'DECLARE v_name ALIAS FOR $1; v_db_id BIGINT; BEGIN SELECT INTO v_db_id db_id FROM db WHERE name=v_name; IF NOT FOUND THEN INSERT INTO db (name) VALUES (v_name); RETURN currval(''db_db_id_seq''); END IF; RETURN v_db_id; END; ' LANGUAGE 'plpgsql'; CREATE OR REPLACE FUNCTION store_dbxref (VARCHAR,VARCHAR) RETURNS BIGINT AS 'DECLARE v_dbname ALIAS FOR $1; v_accession ALIAS FOR $2; v_db_id BIGINT; v_dbxref_id BIGINT; BEGIN SELECT INTO v_db_id store_db(v_dbname); SELECT INTO v_dbxref_id dbxref_id FROM dbxref WHERE db_id=v_db_id AND accession=v_accession; IF NOT FOUND THEN INSERT INTO dbxref (db_id,accession) VALUES (v_db_id,v_accession); RETURN currval(''dbxref_dbxref_id_seq''); END IF; RETURN v_dbxref_id; END; ' LANGUAGE 'plpgsql';