Revision 2868
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 4974 | 4974 |
-- Name: plantname_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4975 | 4975 |
-- |
| 4976 | 4976 |
|
| 4977 |
CREATE UNIQUE INDEX plantname_unique ON plantname USING btree ((COALESCE(parent_id, 0)), (COALESCE(scope_id, 0)), rank, plantname);
|
|
| 4977 |
CREATE UNIQUE INDEX plantname_unique ON plantname USING btree ((COALESCE(parent_id, 2147483647)), (COALESCE(scope_id, 2147483647)), rank, plantname);
|
|
| 4978 | 4978 |
|
| 4979 | 4979 |
|
| 4980 | 4980 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: plantname: Changed indexes to use `COALESCE` to match what sql_gen now does