Revision 13633
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 10957 | 10957 |
|
| 10958 | 10958 |
|
| 10959 | 10959 |
-- |
| 10960 |
-- Name: taxonlabel_taxonomicname_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 10961 |
-- |
|
| 10962 |
|
|
| 10963 |
|
|
| 10964 |
|
|
| 10965 |
|
|
| 10966 |
-- |
|
| 10960 | 10967 |
-- Name: taxonlabel_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 10961 | 10968 |
-- |
| 10962 | 10969 |
|
| trunk/schemas/public_.sql | ||
|---|---|---|
| 14551 | 14551 |
|
| 14552 | 14552 |
|
| 14553 | 14553 |
-- |
| 14554 |
-- Name: taxonlabel_taxonomicname_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 14555 |
-- |
|
| 14556 |
|
|
| 14557 |
CREATE INDEX taxonlabel_taxonomicname_idx ON taxonlabel USING btree (taxonomicname) WHERE ((taxonomicname IS NOT NULL) AND "TNRS".taxon_name_is_safe(taxonomicname)); |
|
| 14558 |
|
|
| 14559 |
|
|
| 14560 |
-- |
|
| 14554 | 14561 |
-- Name: taxonlabel_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 14555 | 14562 |
-- |
| 14556 | 14563 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 14551 | 14551 |
|
| 14552 | 14552 |
|
| 14553 | 14553 |
-- |
| 14554 |
-- Name: taxonlabel_taxonomicname_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 14555 |
-- |
|
| 14556 |
|
|
| 14557 |
CREATE INDEX taxonlabel_taxonomicname_idx ON taxonlabel USING btree (taxonomicname) WHERE ((taxonomicname IS NOT NULL) AND "TNRS".taxon_name_is_safe(taxonomicname)); |
|
| 14558 |
|
|
| 14559 |
|
|
| 14560 |
-- |
|
| 14554 | 14561 |
-- Name: taxonlabel_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 14555 | 14562 |
-- |
| 14556 | 14563 |
|
Also available in: Unified diff
schemas/public_.sql: taxonlabel: added index on taxonomicname to facilitate retrieving rows from tnrs_input_name