Revision 7337
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 7340 | 7340 |
-- Name: taxonverbatim_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 7341 | 7341 |
-- |
| 7342 | 7342 |
|
| 7343 |
CREATE UNIQUE INDEX taxonverbatim_unique ON taxonverbatim USING btree (taxonlabel_id, (COALESCE(morphospecies, '\N'::text)));
|
|
| 7343 |
CREATE UNIQUE INDEX taxonverbatim_unique ON taxonverbatim USING btree ((COALESCE(taxonlabel_id, 2147483647)), (COALESCE(morphospecies, '\N'::text)));
|
|
| 7344 | 7344 |
|
| 7345 | 7345 |
|
| 7346 | 7346 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: taxonverbatim: Allow taxonlabel_id to be NULL when morphoname is provided