Revision 2863
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/functions.sql | ||
|---|---|---|
| 314 | 314 |
-- Name: _label_label; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 315 | 315 |
-- |
| 316 | 316 |
|
| 317 |
CREATE INDEX _label_label ON _label USING btree (ensure_not_null(label));
|
|
| 317 |
CREATE INDEX _label_label ON _label USING btree ((COALESCE(label, '\\N'::text)));
|
|
| 318 | 318 |
|
| 319 | 319 |
|
| 320 | 320 |
-- |
| 321 | 321 |
-- Name: _label_unique; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 322 | 322 |
-- |
| 323 | 323 |
|
| 324 |
CREATE UNIQUE INDEX _label_unique ON _label USING btree (ensure_not_null(label), ensure_not_null(value));
|
|
| 324 |
CREATE UNIQUE INDEX _label_unique ON _label USING btree ((COALESCE(label, '\\N'::text)), (COALESCE(value, '\\N'::text)));
|
|
| 325 | 325 |
|
| 326 | 326 |
|
| 327 | 327 |
-- |
Also available in: Unified diff
schemas/functions.sql: _label: Changed indexes to use `COALESCE` to match what sql_gen now does