ERROR: function st_hexagongrid(integer, geometry) does not exist

Question

I am trying to run the following to test the st_hexagongrid function:

SELECT ST_HexagonGrid(10000, ST_Transform(ST_MakeEnvelope(10, 10, 11, 11, 4326), 3857))

But I am getting the following error:

ERROR:  function st_hexagongrid(integer, geometry) does not exist
LINE 2: SELECT ST_HexagonGrid(10000, ST_Transform(ST_MakeEnvelope(10...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SQL state: 42883
Character: 9

I did check my postgis version and it is 3.2:

SELECT PostGIS_Version();

3.2 USE_GEOS=1 USE_PROJ=1 USE_STATS=1

Do you know any possible reasons for this issue?

Answer 1

The error occurs because you are passing as parameters an integer and a geometry, and the function requires a float and a geometry.

ST_HexagonGrid(float8 size, geometry bounds);

change to:

SELECT ST_HexagonGrid(10000::numeric, ST_Transform(ST_MakeEnvelope(10, 10, 11, 11, 4326), 3857))

check this error:

HINT: No function matches the given name and argument types. You might need to add explicit type casts.

is telling you that it couldn't find a function that has this name or the types of arguments passed. It also asks to try to pass the arguments explicitly.