| 1 |
|
| 2 |
CREATE OR REPLACE FUNCTION store_analysis (VARCHAR,VARCHAR,VARCHAR) |
| 3 |
RETURNS BIGINT AS |
| 4 |
'DECLARE |
| 5 |
v_program ALIAS FOR $1; |
| 6 |
v_programversion ALIAS FOR $2; |
| 7 |
v_sourcename ALIAS FOR $3; |
| 8 |
pkval BIGINT; |
| 9 |
BEGIN |
| 10 |
SELECT INTO pkval analysis_id |
| 11 |
FROM analysis |
| 12 |
WHERE program=v_program AND |
| 13 |
programversion=v_programversion AND |
| 14 |
sourcename=v_sourcename; |
| 15 |
IF NOT FOUND THEN |
| 16 |
INSERT INTO analysis |
| 17 |
(program,programversion,sourcename) |
| 18 |
VALUES |
| 19 |
(v_program,v_programversion,v_sourcename); |
| 20 |
RETURN currval(''analysis_analysis_id_seq''); |
| 21 |
END IF; |
| 22 |
RETURN pkval; |
| 23 |
END; |
| 24 |
' LANGUAGE 'plpgsql'; |
| 25 |
|
| 26 |
--CREATE OR REPLACE FUNCTION store_analysisfeature |
| 27 |
--() |
| 28 |
--RETURNS INT AS |
| 29 |
--'DECLARE |
| 30 |
-- v_srcfeature_id ALIAS FOR $1; |
| 31 |
|