From 5fa68cfc622d76393e75795dadec32ec7ca29557 Mon Sep 17 00:00:00 2001
From: Sandro Santilli <strk@keybit.net>
Date: Mon, 13 Feb 2012 16:04:30 +0000
Subject: [PATCH] Some VOLATILE functions turned to STABLE (#955)

A noticeable exception is the Geometry(TopoGeometry) cast which
triggers a regression when made STABLE.

git-svn-id: http://svn.osgeo.org/postgis/trunk@9170 b70326c6-7e19-0410-871a-916f4a2858ee
---
 topology/topology.sql.in.c | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

diff --git a/topology/topology.sql.in.c b/topology/topology.sql.in.c
index c038a06b2..1f5e43cdf 100644
--- a/topology/topology.sql.in.c
+++ b/topology/topology.sql.in.c
@@ -968,7 +968,7 @@ BEGIN
   RETURN ret;
 END
 $$
-LANGUAGE 'plpgsql' VOLATILE STRICT;
+LANGUAGE 'plpgsql' STABLE STRICT;
 --} GetTopologyName(topoid)
 
 --{
@@ -986,7 +986,7 @@ BEGIN
   RETURN ret;
 END
 $$
-LANGUAGE 'plpgsql' VOLATILE STRICT;
+LANGUAGE 'plpgsql' STABLE STRICT;
 --} GetTopologyId(toponame)
   
 
@@ -1033,7 +1033,7 @@ BEGIN
   RETURN tg_objs;
 END;
 $$
-LANGUAGE 'plpgsql' VOLATILE STRICT;
+LANGUAGE 'plpgsql' STABLE STRICT;
 
 CREATE OR REPLACE FUNCTION topology.GetTopoGeomElementArray(tg topology.TopoGeometry)
   RETURNS topology.TopoElementArray
@@ -1048,7 +1048,7 @@ BEGIN
   RETURN ret;
 END;
 $$
-LANGUAGE 'plpgsql' VOLATILE STRICT;
+LANGUAGE 'plpgsql' STABLE STRICT;
 
 --} GetTopoGeomElementArray()
 
@@ -1119,7 +1119,7 @@ BEGIN
   RETURN;
 END;
 $$
-LANGUAGE 'plpgsql' VOLATILE STRICT;
+LANGUAGE 'plpgsql' STABLE STRICT;
 
 CREATE OR REPLACE FUNCTION topology.GetTopoGeomElements(tg topology.TopoGeometry)
   RETURNS SETOF topology.TopoElement
@@ -1138,7 +1138,7 @@ BEGIN
   RETURN;
 END;
 $$
-LANGUAGE 'plpgsql' VOLATILE STRICT;
+LANGUAGE 'plpgsql' STABLE STRICT;
 
 --} GetTopoGeomElements()
 
-- 
2.40.0