背景
我有一个具有以下属性的表hospitals_healthcenters_jointed_to_evacuationzones
:
-
lat
纬度 -
long_
经度
我尝试过的
我正在尝试创建结合了Point
和lat
的几何数据类型列long_
我使用了发现的以下代码:
ALTER TABLE hospitals_healthcenters_jointed_to_evacuationzones
ADD shape Point
;
UPDATE hospitals_healthcenters_jointed_to_evacuationzones
SET shape = Point("long_","lat")
我遇到错误
但是出现以下错误:
ERROR: function point(character varying,numeric) does not exist
LINE 4: SET shape = Point("long_","lat");
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
SQL state: 42883
Character: 157