Project

General

Profile

1
ALTER TABLE :table ALTER COLUMN decimallatitude SET NOT NULL;
2
ALTER TABLE :table ALTER COLUMN decimallongitude SET NOT NULL;
3

    
4
CREATE INDEX ON :table (decimallatitude, decimallongitude);
(6-6/7)