Project

General

Profile

« Previous | Next » 

Revision 13567

inputs/.TNRS/schema.sql: added tnrs__batch_begin() trigger to populate the match_num (match sort order)

View differences:

trunk/inputs/.TNRS/schema.sql
158 158

  
159 159

  
160 160
--
161
-- Name: tnrs__batch_begin(); Type: FUNCTION; Schema: TNRS; Owner: -
162
--
163

  
164
CREATE FUNCTION tnrs__batch_begin() RETURNS trigger
165
    LANGUAGE plpgsql
166
    AS $$
167
BEGIN
168
	PERFORM util.seq__reset('pg_temp.tnrs__match_num__seq', 0);
169
	RETURN NULL;
170
END;
171
$$;
172

  
173

  
174
--
161 175
-- Name: tnrs_populate_fields(); Type: FUNCTION; Schema: TNRS; Owner: -
162 176
--
163 177

  
......
672 686

  
673 687

  
674 688
--
689
-- Name: tnrs__batch_begin; Type: TRIGGER; Schema: TNRS; Owner: -
690
--
691

  
692
CREATE TRIGGER tnrs__batch_begin BEFORE INSERT ON tnrs FOR EACH STATEMENT EXECUTE PROCEDURE tnrs__batch_begin();
693

  
694

  
695
--
675 696
-- Name: tnrs_populate_fields; Type: TRIGGER; Schema: TNRS; Owner: -
676 697
--
677 698

  

Also available in: Unified diff