make all query partition functions stable

diff --git a/sql/partition-functions.src.sql b/sql/partition-functions.src.sql
index 07e99c97b97b21fa33e8c499452e038ea469b002..8f78032ed18d4e05e5bc5d4f3ea9dc50563db898 100644 (file)
--- a/sql/partition-functions.src.sql
+++ b/sql/partition-functions.src.sql
@@ -39,7 +39,7 @@ BEGIN
   RAISE EXCEPTION 'Unknown partition %', in_partition;
 END
 $$
   RAISE EXCEPTION 'Unknown partition %', in_partition;
 END
 $$

-LANGUAGE plpgsql;
+LANGUAGE plpgsql STABLE;

 
 create or replace function deleteLocationArea(in_partition INTEGER, in_place_id BIGINT, in_rank_search INTEGER) RETURNS BOOLEAN AS $$
 DECLARE
 
 create or replace function deleteLocationArea(in_partition INTEGER, in_place_id BIGINT, in_rank_search INTEGER) RETURNS BOOLEAN AS $$
 DECLARE


@@ -145,7 +145,7 @@ BEGIN
   RAISE EXCEPTION 'Unknown partition %', in_partition;
 END
 $$
   RAISE EXCEPTION 'Unknown partition %', in_partition;
 END
 $$

-LANGUAGE plpgsql;
+LANGUAGE plpgsql STABLE;

 
 
 create or replace function insertSearchName(
 
 
 create or replace function insertSearchName(


@@ -254,7 +254,7 @@ BEGIN
   RAISE EXCEPTION 'Unknown partition %', in_partition;
 END
 $$
   RAISE EXCEPTION 'Unknown partition %', in_partition;
 END
 $$

-LANGUAGE plpgsql IMMUTABLE;
+LANGUAGE plpgsql STABLE;

 
 CREATE OR REPLACE FUNCTION getNearestParallelRoadFeature(in_partition INTEGER,
                                                          line GEOMETRY)
 
 CREATE OR REPLACE FUNCTION getNearestParallelRoadFeature(in_partition INTEGER,
                                                          line GEOMETRY)


@@ -298,4 +298,4 @@ BEGIN
   RAISE EXCEPTION 'Unknown partition %', in_partition;
 END
 $$
   RAISE EXCEPTION 'Unknown partition %', in_partition;
 END
 $$

-LANGUAGE plpgsql IMMUTABLE;
+LANGUAGE plpgsql STABLE;