Mercurial > gemma
changeset 3735:96230eadf96e
Added some optimizer hints to search functions.
author | Sascha Wilde <wilde@intevation.de> |
---|---|
date | Mon, 24 Jun 2019 11:49:08 +0200 |
parents | 1504856c9378 |
children | 4cc3b28fd87b |
files | schema/search_functions.sql |
diffstat | 1 files changed, 6 insertions(+), 6 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/search_functions.sql Mon Jun 24 11:46:20 2019 +0200 +++ b/schema/search_functions.sql Mon Jun 24 11:49:08 2019 +0200 @@ -12,7 +12,7 @@ -- * Sascha Wilde <wilde@intevation.de> CREATE OR REPLACE FUNCTION search_hectometre(search_string text) RETURNS jsonb - LANGUAGE plpgsql + LANGUAGE plpgsql STABLE PARALLEL SAFE AS $$ DECLARE _result jsonb; @@ -33,7 +33,7 @@ $$; CREATE OR REPLACE FUNCTION search_bottlenecks(search_string text) RETURNS jsonb - LANGUAGE plpgsql + LANGUAGE plpgsql STABLE PARALLEL SAFE AS $$ DECLARE _result jsonb; @@ -51,7 +51,7 @@ $$; CREATE OR REPLACE FUNCTION search_cities(search_string text) RETURNS jsonb - LANGUAGE plpgsql + LANGUAGE plpgsql STABLE PARALLEL SAFE AS $$ DECLARE _result jsonb; @@ -73,7 +73,7 @@ $$; CREATE OR REPLACE FUNCTION search_gauges(search_string text) RETURNS jsonb - LANGUAGE plpgsql + LANGUAGE plpgsql STABLE PARALLEL SAFE AS $$ DECLARE _result jsonb; @@ -104,7 +104,7 @@ $$; CREATE OR REPLACE FUNCTION search_sections(search_string text) RETURNS jsonb - LANGUAGE plpgsql + LANGUAGE plpgsql STABLE PARALLEL SAFE AS $$ DECLARE _result jsonb; @@ -123,7 +123,7 @@ $$; CREATE OR REPLACE FUNCTION search_most(search_string text) RETURNS jsonb - LANGUAGE plpgsql + LANGUAGE plpgsql STABLE PARALLEL SAFE AS $$ BEGIN RETURN search_hectometre(search_string)