Revision 2888
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.sql | ||
|---|---|---|
| 4816 | 4816 |
|
| 4817 | 4817 |
|
| 4818 | 4818 |
-- |
| 4819 |
-- Name: method_description; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4820 |
-- |
|
| 4821 |
|
|
| 4822 |
CREATE INDEX method_description ON method USING btree ((COALESCE(description, '\\N'::text))); |
|
| 4823 |
|
|
| 4824 |
|
|
| 4825 |
-- |
|
| 4826 |
-- Name: method_name; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4827 |
-- |
|
| 4828 |
|
|
| 4829 |
CREATE INDEX method_name ON method USING btree (name); |
|
| 4830 |
|
|
| 4831 |
|
|
| 4832 |
-- |
|
| 4819 | 4833 |
-- Name: method_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4820 | 4834 |
-- |
| 4821 | 4835 |
|
| 4822 |
CREATE UNIQUE INDEX method_unique ON method USING btree (name, (COALESCE(description, ''::text))); |
|
| 4836 |
CREATE UNIQUE INDEX method_unique ON method USING btree (name, (COALESCE(description, '\\N'::text)));
|
|
| 4823 | 4837 |
|
| 4824 | 4838 |
|
| 4825 | 4839 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: method: Changed indexes to use `COALESCE` to match what sql_gen now does