Revision 2634
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/py_functions.sql | ||
|---|---|---|
| 21 | 21 |
SET search_path = py_functions, pg_catalog; |
| 22 | 22 |
|
| 23 | 23 |
-- |
| 24 |
-- Name: _dateRangeEnd(); Type: FUNCTION; Schema: py_functions; Owner: bien |
|
| 25 |
-- |
|
| 26 |
|
|
| 27 |
CREATE FUNCTION "_dateRangeEnd"() RETURNS trigger |
|
| 28 |
LANGUAGE plpgsql IMMUTABLE |
|
| 29 |
AS $$ |
|
| 30 |
BEGIN |
|
| 31 |
new.result := (SELECT (py_functions.parse_date_range(new.value))[2]); |
|
| 32 |
RETURN new; |
|
| 33 |
END; |
|
| 34 |
$$; |
|
| 35 |
|
|
| 36 |
|
|
| 37 |
ALTER FUNCTION py_functions."_dateRangeEnd"() OWNER TO bien; |
|
| 38 |
|
|
| 39 |
-- |
|
| 24 | 40 |
-- Name: _dateRangeStart(); Type: FUNCTION; Schema: py_functions; Owner: bien |
| 25 | 41 |
-- |
| 26 | 42 |
|
| ... | ... | |
| 84 | 100 |
SET default_with_oids = false; |
| 85 | 101 |
|
| 86 | 102 |
-- |
| 103 |
-- Name: _dateRangeEnd; Type: TABLE; Schema: py_functions; Owner: bien; Tablespace: |
|
| 104 |
-- |
|
| 105 |
|
|
| 106 |
CREATE TABLE "_dateRangeEnd" ( |
|
| 107 |
result text, |
|
| 108 |
not_null_col boolean DEFAULT true NOT NULL, |
|
| 109 |
value text |
|
| 110 |
); |
|
| 111 |
|
|
| 112 |
|
|
| 113 |
ALTER TABLE py_functions."_dateRangeEnd" OWNER TO bien; |
|
| 114 |
|
|
| 115 |
-- |
|
| 87 | 116 |
-- Name: _dateRangeStart; Type: TABLE; Schema: py_functions; Owner: bien; Tablespace: |
| 88 | 117 |
-- |
| 89 | 118 |
|
| ... | ... | |
| 97 | 126 |
ALTER TABLE py_functions."_dateRangeStart" OWNER TO bien; |
| 98 | 127 |
|
| 99 | 128 |
-- |
| 129 |
-- Name: _dateRangeEnd_unique; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: |
|
| 130 |
-- |
|
| 131 |
|
|
| 132 |
CREATE UNIQUE INDEX "_dateRangeEnd_unique" ON "_dateRangeEnd" USING btree (functions.ensure_not_null(value)); |
|
| 133 |
|
|
| 134 |
|
|
| 135 |
-- |
|
| 100 | 136 |
-- Name: _dateRangeStart_unique; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: |
| 101 | 137 |
-- |
| 102 | 138 |
|
| ... | ... | |
| 104 | 140 |
|
| 105 | 141 |
|
| 106 | 142 |
-- |
| 143 |
-- Name: _dateRangeEnd; Type: TRIGGER; Schema: py_functions; Owner: bien |
|
| 144 |
-- |
|
| 145 |
|
|
| 146 |
CREATE TRIGGER "_dateRangeEnd" BEFORE INSERT OR UPDATE ON "_dateRangeEnd" FOR EACH ROW EXECUTE PROCEDURE "_dateRangeEnd"(); |
|
| 147 |
|
|
| 148 |
|
|
| 149 |
-- |
|
| 107 | 150 |
-- Name: _dateRangeStart; Type: TRIGGER; Schema: py_functions; Owner: bien |
| 108 | 151 |
-- |
| 109 | 152 |
|
Also available in: Unified diff
schemas/py_functions.sql: Added _dateRangeEnd relational function