Revision 2956
Added by Aaron Marcuse-Kubitza over 12 years ago
| 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