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