Revision 2957
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4163 | 4163 |
|
| 4164 | 4164 |
|
| 4165 | 4165 |
-- |
| 4166 |
-- Name: locationdetermination_namedplace_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4166 |
-- Name: locationdetermination_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4167 | 4167 |
-- |
| 4168 | 4168 |
|
| 4169 |
CREATE INDEX locationdetermination_namedplace_id_x ON locationdetermination (namedplace_id); |
|
| 4170 | 4169 |
|
| 4171 | 4170 |
|
| 4171 |
|
|
| 4172 | 4172 |
-- |
| 4173 | 4173 |
-- Name: locationevent_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4174 | 4174 |
-- |
| schemas/vegbien.sql | ||
|---|---|---|
| 4690 | 4690 |
|
| 4691 | 4691 |
|
| 4692 | 4692 |
-- |
| 4693 |
-- Name: locationdetermination_namedplace_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4693 |
-- Name: locationdetermination_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4694 | 4694 |
-- |
| 4695 | 4695 |
|
| 4696 |
CREATE INDEX locationdetermination_namedplace_id_x ON locationdetermination USING btree (namedplace_id);
|
|
| 4696 |
CREATE INDEX locationdetermination_namedplace_id ON locationdetermination USING btree ((COALESCE(namedplace_id, 2147483647)));
|
|
| 4697 | 4697 |
|
| 4698 | 4698 |
|
| 4699 | 4699 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: locationdetermination: Changed indexes to use COALESCE to match what sql_gen now does