Project

General

Profile

« Previous | Next » 

Revision 13869

fix: inputs/.TNRS/schema.sql: taxon_match: renamed related items to start with taxon_match__*

View differences:

vegbien.sql
19049 19049
    LANGUAGE plpgsql
19050 19050
    AS $$
19051 19051
BEGIN
19052
	PERFORM util.seq__reset('pg_temp.tnrs__match_num__seq', 0);
19052
	PERFORM util.seq__reset('pg_temp.taxon_match__match_num__seq', 0);
19053 19053
	RETURN NULL;
19054 19054
END;
19055 19055
$$;
......
19139 19139
    AS $$
19140 19140
BEGIN
19141 19141
	IF new.match_num IS NULL THEN
19142
		new.match_num = "TNRS".tnrs__match_num__next();
19142
		new.match_num = "TNRS".taxon_match__match_num__next();
19143 19143
	END IF;
19144 19144
	RETURN new;
19145 19145
END;
......
19147 19147

  
19148 19148

  
19149 19149
--
19150
-- Name: taxon_match__match_num__next(); Type: FUNCTION; Schema: TNRS; Owner: -
19151
--
19152

  
19153
CREATE FUNCTION taxon_match__match_num__next() RETURNS bigint
19154
    LANGUAGE sql
19155
    AS $$
19156
SELECT nextval('pg_temp.taxon_match__match_num__seq');
19157
$$;
19158

  
19159

  
19160
--
19150 19161
-- Name: taxon_match_input__copy_to__insert(); Type: FUNCTION; Schema: TNRS; Owner: -
19151 19162
--
19152 19163

  
......
19172 19183

  
19173 19184

  
19174 19185
--
19175
-- Name: tnrs__match_num__next(); Type: FUNCTION; Schema: TNRS; Owner: -
19176
--
19177

  
19178
CREATE FUNCTION tnrs__match_num__next() RETURNS bigint
19179
    LANGUAGE sql
19180
    AS $$
19181
SELECT nextval('pg_temp.tnrs__match_num__seq');
19182
$$;
19183

  
19184

  
19185
--
19186 19186
-- Name: unsafe_taxon_names(); Type: FUNCTION; Schema: TNRS; Owner: -
19187 19187
--
19188 19188

  

Also available in: Unified diff