Revision 13869
Added by Aaron Marcuse-Kubitza over 10 years ago
| schema.sql | ||
|---|---|---|
| 100 | 100 |
LANGUAGE plpgsql |
| 101 | 101 |
AS $$ |
| 102 | 102 |
BEGIN |
| 103 |
PERFORM util.seq__reset('pg_temp.tnrs__match_num__seq', 0);
|
|
| 103 |
PERFORM util.seq__reset('pg_temp.taxon_match__match_num__seq', 0);
|
|
| 104 | 104 |
RETURN NULL; |
| 105 | 105 |
END; |
| 106 | 106 |
$$; |
| ... | ... | |
| 190 | 190 |
AS $$ |
| 191 | 191 |
BEGIN |
| 192 | 192 |
IF new.match_num IS NULL THEN |
| 193 |
new.match_num = "TNRS".tnrs__match_num__next();
|
|
| 193 |
new.match_num = "TNRS".taxon_match__match_num__next();
|
|
| 194 | 194 |
END IF; |
| 195 | 195 |
RETURN new; |
| 196 | 196 |
END; |
| ... | ... | |
| 198 | 198 |
|
| 199 | 199 |
|
| 200 | 200 |
-- |
| 201 |
-- Name: taxon_match__match_num__next(); Type: FUNCTION; Schema: TNRS; Owner: - |
|
| 202 |
-- |
|
| 203 |
|
|
| 204 |
CREATE FUNCTION taxon_match__match_num__next() RETURNS bigint |
|
| 205 |
LANGUAGE sql |
|
| 206 |
AS $$ |
|
| 207 |
SELECT nextval('pg_temp.taxon_match__match_num__seq');
|
|
| 208 |
$$; |
|
| 209 |
|
|
| 210 |
|
|
| 211 |
-- |
|
| 201 | 212 |
-- Name: taxon_match_input__copy_to__insert(); Type: FUNCTION; Schema: TNRS; Owner: - |
| 202 | 213 |
-- |
| 203 | 214 |
|
| ... | ... | |
| 223 | 234 |
|
| 224 | 235 |
|
| 225 | 236 |
-- |
| 226 |
-- Name: tnrs__match_num__next(); Type: FUNCTION; Schema: TNRS; Owner: - |
|
| 227 |
-- |
|
| 228 |
|
|
| 229 |
CREATE FUNCTION tnrs__match_num__next() RETURNS bigint |
|
| 230 |
LANGUAGE sql |
|
| 231 |
AS $$ |
|
| 232 |
SELECT nextval('pg_temp.tnrs__match_num__seq');
|
|
| 233 |
$$; |
|
| 234 |
|
|
| 235 |
|
|
| 236 |
-- |
|
| 237 | 237 |
-- Name: unsafe_taxon_names(); Type: FUNCTION; Schema: TNRS; Owner: - |
| 238 | 238 |
-- |
| 239 | 239 |
|
Also available in: Unified diff
fix: inputs/.TNRS/schema.sql: taxon_match: renamed related items to start with taxon_match__*