CODEWITHSUNDEEP
postgresqlpostgispostgresql-12
horoyoi o
horoyoi o

Reputation: 682

postgres st_dwithin doesn't exist

Here is my OS & db version

cat /etc/centos-release

CentOS Linux release 7.6.1810 (Core)



################################################

psql --version

PostgreSQL 12.1

I already installed postgres and postgis.

enter image description here

but still, I cannot use ST_Dwithin or ST_Distance ... and so on. I can use stddev... ? (this is useless method to me currently)

enter image description here this means -> "No function matches the specified name and argument data types. You may need to add explicit casters"

What more should I check? Please let me know.

Upvotes: 1

Views: 2520

Answers (1)

Jim Jones
Jim Jones

Reputation: 19623

You're calling ST_DWithin using numeric parameters instead of geometries, and therefore the error message:

.. Function st_dwithin(numeric, numeric, integer) does not exist ..

This function expects 1) geometry 2) geometry and 3) double precision.

SELECT 
  ST_DWithin(
  'POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))'::GEOMETRY,
  'POINT (29 10)'::GEOMETRY,
  3000);

Upvotes: 2

Related Questions