Revision 13869
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/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 |
|
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 15305 | 15305 |
|
| 15306 | 15306 |
|
| 15307 | 15307 |
-- |
| 15308 |
-- Name: taxon_match_input__copy_to__insert(); Type: FUNCTION; Schema: TNRS; Owner: -
|
|
| 15308 |
-- Name: taxon_match__match_num__next(); Type: FUNCTION; Schema: TNRS; Owner: -
|
|
| 15309 | 15309 |
-- |
| 15310 | 15310 |
|
| 15311 | 15311 |
|
| 15312 | 15312 |
|
| 15313 | 15313 |
|
| 15314 | 15314 |
-- |
| 15315 |
-- Name: taxon_name_is_safe(varchar(255)); Type: FUNCTION; Schema: TNRS; Owner: -
|
|
| 15315 |
-- Name: taxon_match_input__copy_to__insert(); Type: FUNCTION; Schema: TNRS; Owner: -
|
|
| 15316 | 15316 |
-- |
| 15317 | 15317 |
|
| 15318 | 15318 |
|
| 15319 | 15319 |
|
| 15320 | 15320 |
|
| 15321 | 15321 |
-- |
| 15322 |
-- Name: tnrs__match_num__next(); Type: FUNCTION; Schema: TNRS; Owner: -
|
|
| 15322 |
-- Name: taxon_name_is_safe(varchar(255)); Type: FUNCTION; Schema: TNRS; Owner: -
|
|
| 15323 | 15323 |
-- |
| 15324 | 15324 |
|
| 15325 | 15325 |
|
| trunk/schemas/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__*