Revision 2887
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.sql | ||
|---|---|---|
| 5187 | 5187 |
|
| 5188 | 5188 |
|
| 5189 | 5189 |
-- |
| 5190 |
-- Name: specimenreplicate_catalognumber_dwc; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5191 |
-- |
|
| 5192 |
|
|
| 5193 |
CREATE INDEX specimenreplicate_catalognumber_dwc ON specimenreplicate USING btree ((COALESCE(catalognumber_dwc, '\\N'::text))); |
|
| 5194 |
|
|
| 5195 |
|
|
| 5196 |
-- |
|
| 5190 | 5197 |
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5191 | 5198 |
-- |
| 5192 | 5199 |
|
Also available in: Unified diff
schemas/vegbien.sql: specimenreplicate: Added indexes using COALESCE to match what sql_gen does