Revision 13869
Added by Aaron Marcuse-Kubitza over 10 years ago
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
fix: inputs/.TNRS/schema.sql: taxon_match: renamed related items to start with taxon_match__*