Revision 2867
Added by Aaron Marcuse-Kubitza about 12 years ago
| py_functions.sql | ||
|---|---|---|
| 184 | 184 |
-- Name: _dateRangeEnd_unique; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: |
| 185 | 185 |
-- |
| 186 | 186 |
|
| 187 |
CREATE UNIQUE INDEX "_dateRangeEnd_unique" ON "_dateRangeEnd" USING btree (functions.ensure_not_null(value));
|
|
| 187 |
CREATE UNIQUE INDEX "_dateRangeEnd_unique" ON "_dateRangeEnd" USING btree ((COALESCE(value, '\\N'::text)));
|
|
| 188 | 188 |
|
| 189 | 189 |
|
| 190 | 190 |
-- |
| 191 |
-- Name: _dateRangeEnd_value; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: |
|
| 192 |
-- |
|
| 193 |
|
|
| 194 |
CREATE INDEX "_dateRangeEnd_value" ON "_dateRangeEnd" USING btree (value); |
|
| 195 |
|
|
| 196 |
|
|
| 197 |
-- |
|
| 198 | 191 |
-- Name: _dateRangeStart_unique; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: |
| 199 | 192 |
-- |
| 200 | 193 |
|
| 201 |
CREATE UNIQUE INDEX "_dateRangeStart_unique" ON "_dateRangeStart" USING btree (functions.ensure_not_null(value));
|
|
| 194 |
CREATE UNIQUE INDEX "_dateRangeStart_unique" ON "_dateRangeStart" USING btree ((COALESCE(value, '\\N'::text)));
|
|
| 202 | 195 |
|
| 203 | 196 |
|
| 204 | 197 |
-- |
| 205 |
-- Name: _dateRangeStart_value; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: |
|
| 206 |
-- |
|
| 207 |
|
|
| 208 |
CREATE INDEX "_dateRangeStart_value" ON "_dateRangeStart" USING btree (value); |
|
| 209 |
|
|
| 210 |
|
|
| 211 |
-- |
|
| 212 | 198 |
-- Name: _namePart_first; Type: INDEX; Schema: py_functions; Owner: bien; Tablespace: |
| 213 | 199 |
-- |
| 214 | 200 |
|
Also available in: Unified diff
schemas/py_functions.sql: _dateRangeStart, _dateRangeEnd: Changed indexes to use `COALESCE` to match what sql_gen now does