Revision 2862
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/functions.sql | ||
|---|---|---|
| 195 | 195 |
CREATE TABLE _label ( |
| 196 | 196 |
result text, |
| 197 | 197 |
not_null_col boolean DEFAULT true NOT NULL, |
| 198 |
label text, |
|
| 198 |
label text NOT NULL,
|
|
| 199 | 199 |
value text |
| 200 | 200 |
); |
| 201 | 201 |
|
| ... | ... | |
| 314 | 314 |
-- Name: _label_label; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 315 | 315 |
-- |
| 316 | 316 |
|
| 317 |
CREATE INDEX _label_label ON _label USING btree (label);
|
|
| 317 |
CREATE INDEX _label_label ON _label USING btree (ensure_not_null(label));
|
|
| 318 | 318 |
|
| 319 | 319 |
|
| 320 | 320 |
-- |
Also available in: Unified diff
schemas/functions.sql: _label: Require a non-NULL label