| 1 |
9920
|
aaronmk
|
SELECT util.search_path_append('util');
|
| 2 |
|
|
|
| 3 |
9921
|
aaronmk
|
-- runtime: 25 s ("real 0m21.770s")
|
| 4 |
|
|
SELECT set_col_types(:table_str, ARRAY[
|
| 5 |
|
|
('decimallatitude', 'double precision')
|
| 6 |
|
|
, ('decimallongitude', 'double precision')
|
| 7 |
|
|
]::col_cast[]);
|
| 8 |
|
|
|
| 9 |
6657
|
aaronmk
|
ALTER TABLE :table ALTER COLUMN decimallatitude SET NOT NULL;
|
| 10 |
|
|
ALTER TABLE :table ALTER COLUMN decimallongitude SET NOT NULL;
|
| 11 |
6658
|
aaronmk
|
|
| 12 |
9920
|
aaronmk
|
-- runtime: 55 s ("real 0m53.677s")
|
| 13 |
|
|
SELECT create_if_not_exists($$CREATE INDEX geoscrub_output_input ON geoscrub_output (decimallatitude, decimallongitude, country, stateprovince, county)$$);
|
