Project

General

Profile

« Previous | Next » 

Revision 2887

schemas/vegbien.sql: specimenreplicate: Added indexes using COALESCE to match what sql_gen does

View differences:

schemas/vegbien.my.sql
4660 4660

  
4661 4661

  
4662 4662
--
4663
-- Name: specimenreplicate_catalognumber_dwc; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4664
--
4665

  
4666

  
4667

  
4668

  
4669
--
4663 4670
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace: 
4664 4671
--
4665 4672

  
schemas/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