Revision 2956
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 4135 | 4135 |
|
| 4136 | 4136 |
|
| 4137 | 4137 |
-- |
| 4138 |
-- Name: location_centerlatitude; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4139 |
-- |
|
| 4140 |
|
|
| 4141 |
|
|
| 4142 |
|
|
| 4143 |
|
|
| 4144 |
-- |
|
| 4145 |
-- Name: location_centerlongitude; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4146 |
-- |
|
| 4147 |
|
|
| 4148 |
|
|
| 4149 |
|
|
| 4150 |
|
|
| 4151 |
-- |
|
| 4138 | 4152 |
-- Name: location_parent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4139 | 4153 |
-- |
| 4140 | 4154 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4662 | 4662 |
|
| 4663 | 4663 |
|
| 4664 | 4664 |
-- |
| 4665 |
-- Name: location_centerlatitude; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4666 |
-- |
|
| 4667 |
|
|
| 4668 |
CREATE INDEX location_centerlatitude ON location USING btree ((COALESCE(centerlatitude, 'NaN'::double precision))); |
|
| 4669 |
|
|
| 4670 |
|
|
| 4671 |
-- |
|
| 4672 |
-- Name: location_centerlongitude; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4673 |
-- |
|
| 4674 |
|
|
| 4675 |
CREATE INDEX location_centerlongitude ON location USING btree ((COALESCE(centerlongitude, 'NaN'::double precision))); |
|
| 4676 |
|
|
| 4677 |
|
|
| 4678 |
-- |
|
| 4665 | 4679 |
-- Name: location_parent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4666 | 4680 |
-- |
| 4667 | 4681 |
|
Also available in: Unified diff
schemas/vegbien.sql: location: Added indexes using COALESCE to match what sql_gen does