use function with query parameters. How?!

[pcace]

Hi there, i am trying to get functions with parameters working:

CREATE OR REPLACE FUNCTION function_zxy_query(z integer, x integer, y integer, query_params json)
RETURNS bytea AS $$
DECLARE
  mvt bytea;
BEGIN
  SELECT INTO mvt ST_AsMVT(tile, 'function_zxy_query', 4096, 'geom', 'id') FROM (
    SELECT
      ST_AsMVTGeom(
          ST_Transform(ST_CurveToLine("ground_geometry"), 3857),
          ST_TileEnvelope(z, x, y),
          4096, 64, true) AS geom,
      "id", "type",
      CASE WHEN (query_params->'cityjson'->>'true')::int = 1 THEN attributes::TEXT ELSE NULL END AS attributes,
      CASE WHEN (query_params->'cityjson'->>'true')::int = 1 THEN geometry::TEXT ELSE NULL END AS geometry
    FROM 
      cjdb.city_object
    WHERE 
      "ground_geometry" && ST_Transform(ST_TileEnvelope(z, x, y, margin => 0.015625), 3857)
  ) as tile
  WHERE geom IS NOT NULL;

  RETURN mvt;
END
$$ LANGUAGE plpgsql IMMUTABLE STRICT PARALLEL SAFE;

trying to get a tile like this:
localhost:3000/function_source_id/17/69881/43588?cityjson=true
seems to not register the parameter. Is the request wrong? or something in the function? any help (or better documentation ;) )
would be awesome!

Thanks a lot!

[nyurik]

Hi, the URL has function_source_id but your function is function_zxy_query -- is that intentional (do you rename it in your config)?