X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/a846872f04106b18c1d0cf2b77c3236a88e959d7..be63329a69762a3d13487b060f3cbc7b815bdb48:/lib-sql/functions/address_lookup.sql diff --git a/lib-sql/functions/address_lookup.sql b/lib-sql/functions/address_lookup.sql index cba11dbf..b59b7656 100644 --- a/lib-sql/functions/address_lookup.sql +++ b/lib-sql/functions/address_lookup.sql @@ -47,7 +47,7 @@ BEGIN RETURN trim((avals(name))[array_length(avals(name), 1)]); END; $$ -LANGUAGE plpgsql IMMUTABLE; +LANGUAGE plpgsql IMMUTABLE PARALLEL SAFE; --housenumber only needed for tiger data @@ -84,7 +84,7 @@ BEGIN RETURN array_to_string(result,', '); END; $$ -LANGUAGE plpgsql STABLE; +LANGUAGE plpgsql STABLE PARALLEL SAFE; DROP TYPE IF EXISTS addressdata_place; CREATE TYPE addressdata_place AS ( @@ -331,4 +331,4 @@ BEGIN RETURN; END; $$ -LANGUAGE plpgsql STABLE; +LANGUAGE plpgsql STABLE PARALLEL SAFE;