Revision 705
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 21 | 21 |
-- Name: aggregateoccurrence_plantobs_count_1(); Type: FUNCTION; Schema: public; Owner: - |
| 22 | 22 |
-- |
| 23 | 23 |
|
| 24 |
CREATE FUNCTION aggregateoccurrence_plantobs_count_1() RETURNS trigger |
|
| 25 |
LANGUAGE plpgsql |
|
| 26 |
AS $$ |
|
| 27 |
BEGIN |
|
| 28 |
IF new.plantobservation_id IS NOT NULL THEN |
|
| 29 |
new.count = 1; |
|
| 30 |
END IF; |
|
| 31 |
RETURN new; |
|
| 32 |
END; |
|
| 33 |
$$; |
|
| 34 | 24 |
|
| 35 | 25 |
|
| 26 |
|
|
| 36 | 27 |
-- |
| 37 | 28 |
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: - |
| 38 | 29 |
-- |
| ... | ... | |
| 5548 | 5539 |
-- Name: aggregateoccurrence_plantobs_count_1; Type: TRIGGER; Schema: public; Owner: - |
| 5549 | 5540 |
-- |
| 5550 | 5541 |
|
| 5551 |
CREATE TRIGGER aggregateoccurrence_plantobs_count_1 BEFORE INSERT OR UPDATE ON aggregateoccurrence FOR EACH ROW EXECUTE PROCEDURE aggregateoccurrence_plantobs_count_1(); |
|
| 5552 | 5542 |
|
| 5553 | 5543 |
|
| 5544 |
|
|
| 5554 | 5545 |
-- |
| 5555 | 5546 |
-- Name: address_organization_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5556 | 5547 |
-- |
| lib/PostgreSQL-MySQL.csv | ||
|---|---|---|
| 1 | 1 |
"PostgreSQL","MySQL","Comments" |
| 2 | 2 |
,,"PostgreSQL-only features" |
| 3 | 3 |
"^SET\b[^;]*;",, |
| 4 |
"^(?:CREATE|ALTER) (?:AGGREGATE|SEQUENCE)\b[^;]*;",, |
|
| 4 |
"^(?:CREATE|ALTER) (?:AGGREGATE|SEQUENCE|TRIGGER)\b[^;]*;",, |
|
| 5 |
"(?s)^CREATE FUNCTION\b.*?(\$\w*\$).*?\1;",, |
|
| 5 | 6 |
"^COMMENT\b[^;]*;",, |
| 6 | 7 |
"^ALTER TABLE\b[^;]*\bSET DEFAULT nextval\([^;]*\)[^;]*;",, |
| 7 | 8 |
"^CREATE\b[^;]*\bINDEX\b[^;]*\([^;]*\([^;]*;",, |
Also available in: Unified diff
PostgreSQL-MySQL.csv: Remove functions and triggers