Revision 13569
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.sql | ||
|---|---|---|
| 16953 | 16953 |
|
| 16954 | 16954 |
|
| 16955 | 16955 |
-- |
| 16956 |
-- Name: tnrs__batch_begin(); Type: FUNCTION; Schema: TNRS; Owner: - |
|
| 16957 |
-- |
|
| 16958 |
|
|
| 16959 |
CREATE FUNCTION tnrs__batch_begin() RETURNS trigger |
|
| 16960 |
LANGUAGE plpgsql |
|
| 16961 |
AS $$ |
|
| 16962 |
BEGIN |
|
| 16963 |
PERFORM util.seq__reset('pg_temp.tnrs__match_num__seq', 0);
|
|
| 16964 |
RETURN NULL; |
|
| 16965 |
END; |
|
| 16966 |
$$; |
|
| 16967 |
|
|
| 16968 |
|
|
| 16969 |
-- |
|
| 16956 | 16970 |
-- Name: tnrs_populate_fields(); Type: FUNCTION; Schema: TNRS; Owner: - |
| 16957 | 16971 |
-- |
| 16958 | 16972 |
|
| ... | ... | |
| 17586 | 17600 |
|
| 17587 | 17601 |
|
| 17588 | 17602 |
-- |
| 17603 |
-- Name: tnrs__batch_begin; Type: TRIGGER; Schema: TNRS; Owner: - |
|
| 17604 |
-- |
|
| 17605 |
|
|
| 17606 |
CREATE TRIGGER tnrs__batch_begin BEFORE INSERT ON tnrs FOR EACH STATEMENT EXECUTE PROCEDURE tnrs__batch_begin(); |
|
| 17607 |
|
|
| 17608 |
|
|
| 17609 |
-- |
|
| 17589 | 17610 |
-- Name: tnrs_populate_fields; Type: TRIGGER; Schema: TNRS; Owner: - |
| 17590 | 17611 |
-- |
| 17591 | 17612 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: added tnrs__batch_begin() trigger to populate the match_num (match sort order)