I get such errors when using these functions, what's is wrong?
pgdb=# SELECT distance('foo','zoo');
ERROR: parse error - invalid geometry
LINE 1: SELECT distance('foo','zoo');
^
HINT: You must specify a valid OGC WKT geometry type such as POINT, LINESTRING or POLYGON
pgdb=#
pgdb=#
pgdb=# SELECT difference('foo','zoo');
ERROR: parse error - invalid geometry
LINE 1: SELECT difference('foo','zoo');
^
HINT: You must specify a valid OGC WKT geometry type such as POINT, LINESTRING or POLYGON
May be these functions are not installed at all?
distanceanddifferenceare not for strings, they are for geometry types (just as the error messages says). Why do you think they would operate on strings? – a_horse_with_no_name Jan 18 at 13:37difference()function. – ypercube Jan 18 at 13:49create extension fuzzystrmatch– a_horse_with_no_name Jan 18 at 15:17