Revision 13633
Added by Aaron Marcuse-Kubitza over 10 years ago
| 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 |
|
Also available in: Unified diff
schemas/public_.sql: taxonlabel: added index on taxonomicname to facilitate retrieving rows from tnrs_input_name