Home > Blockchain >  Cannot use named parameters with ST_AsMVT
Cannot use named parameters with ST_AsMVT

Time:07-30

Postgres 14, PostGIS 3.1

I am unable to use named parameters in ST_AsMVT, e.g.,

SELECT
  ST_AsMVT(mvt_geom.*, feature_id_name => ('id'::text)) FROM mvt_geom;`

results in

ERROR:  function st_asmvt(record, feature_id_name => text) does not exist

On the other hand, I can use them in ST_AsMVTGeom, e.g., the following is successful.

SELECT
  ST_AsMVTGeom (geom, bbox, clip_geom => true)

Is there something particular about ST_AsMVT that prevents the usage of named parameters?

CodePudding user response:

ST_AsMVTGeom has default values for arguments 3 through 5, so they do not need to be specified.

The form of ST_AsMVT which accepts feature_id_name has 4 other mandatory arguments, but you only specify one other parameter.

  • Related