Revision 6672
Added by Aaron Marcuse-Kubitza almost 12 years ago
schemas/vegbien.sql | ||
---|---|---|
6015 | 6015 |
-- Name: coordinates_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
6016 | 6016 |
-- |
6017 | 6017 |
|
6018 |
CREATE UNIQUE INDEX coordinates_unique ON coordinates USING btree (source_id, latitude_deg, longitude_deg, (COALESCE(verbatimlatitude, '\N'::text)), (COALESCE(verbatimlongitude, '\N'::text)), (COALESCE(md5(verbatimcoordinates), '\N'::text)), (COALESCE(footprintgeometry_dwc, '\N'::text)));
|
|
6018 |
CREATE UNIQUE INDEX coordinates_unique ON coordinates USING btree (source_id, latitude_deg, longitude_deg, (COALESCE(verbatimlatitude, '\N'::text)), (COALESCE(verbatimlongitude, '\N'::text)), (COALESCE(verbatimcoordinates, '\N'::text)), (COALESCE(footprintgeometry_dwc, '\N'::text)));
|
|
6019 | 6019 |
|
6020 | 6020 |
|
6021 | 6021 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: coordinates: coordinates_unique: Removed md5() around verbatimcoordinates because functions within unique indexes (other than the standard COALESCE) are not yet supported by the import algorithm