uninstall_earthdistance.sql

来自「PostgreSQL 8.2中增加了很多企业用户所需要的功能和性能上的提高,其开」· SQL 代码 · 共 24 行

SET search_path = public;

DROP OPERATOR <@> (point, point);

DROP FUNCTION geo_distance (point, point);

DROP FUNCTION earth_box(earth, float8);

DROP FUNCTION earth_distance(earth, earth);

DROP FUNCTION longitude(earth);

DROP FUNCTION latitude(earth);

DROP FUNCTION ll_to_earth(float8, float8);

DROP FUNCTION gc_to_sec(float8);

DROP FUNCTION sec_to_gc(float8);

DROP DOMAIN earth;

DROP FUNCTION earth();