X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/efafa5271957fb54b356ec1c90e8613f14de40d4..ecf4693a799055b3795ca691337941f931cf0a59:/lib-sql/functions/ranking.sql?ds=sidebyside diff --git a/lib-sql/functions/ranking.sql b/lib-sql/functions/ranking.sql index af23335a..97a0cde3 100644 --- a/lib-sql/functions/ranking.sql +++ b/lib-sql/functions/ranking.sql @@ -284,3 +284,24 @@ BEGIN END; $$ LANGUAGE plpgsql IMMUTABLE; + + +CREATE OR REPLACE FUNCTION weigh_search(search_vector INT[], + rankings TEXT, + def_weight FLOAT) + RETURNS FLOAT + AS $$ +DECLARE + rank JSON; +BEGIN + FOR rank IN + SELECT * FROM json_array_elements(rankings::JSON) + LOOP + IF true = ALL(SELECT x::int = ANY(search_vector) FROM json_array_elements_text(rank->1) as x) THEN + RETURN (rank->>0)::float; + END IF; + END LOOP; + RETURN def_weight; +END; +$$ +LANGUAGE plpgsql IMMUTABLE;