From e0edc5713ab91a411e02f562e771c58cae953f7d Mon Sep 17 00:00:00 2001 From: miker Date: Wed, 6 Apr 2005 22:42:26 +0000 Subject: [PATCH] functions are now STABLE git-svn-id: svn://svn.open-ils.org/ILS/trunk@458 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Postgres/020.schema.functions.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/Open-ILS/src/sql/Postgres/020.schema.functions.sql b/Open-ILS/src/sql/Postgres/020.schema.functions.sql index 3222f277b6..444d3d779a 100644 --- a/Open-ILS/src/sql/Postgres/020.schema.functions.sql +++ b/Open-ILS/src/sql/Postgres/020.schema.functions.sql @@ -38,7 +38,7 @@ CREATE OR REPLACE FUNCTION actor.org_unit_descendants ( INT ) RETURNS SETOF acto AS t(keyid text, parent_keyid text, level int, branch text,pos int) JOIN actor.org_unit a ON a.id = t.keyid ORDER BY CASE WHEN a.parent_ou IS NULL THEN 0 ELSE 1 END, a.name; -$$ LANGUAGE SQL; +$$ LANGUAGE SQL STABLE; CREATE OR REPLACE FUNCTION actor.org_unit_ancestors ( INT ) RETURNS SETOF actor.org_unit AS $$ SELECT a.* @@ -46,7 +46,7 @@ CREATE OR REPLACE FUNCTION actor.org_unit_ancestors ( INT ) RETURNS SETOF actor. AS t(keyid text, parent_keyid text, level int, branch text,pos int) JOIN actor.org_unit a ON a.id = t.keyid ORDER BY CASE WHEN a.parent_ou IS NULL THEN 0 ELSE 1 END, a.name; -$$ LANGUAGE SQL; +$$ LANGUAGE SQL STABLE; @@ -61,5 +61,5 @@ CREATE OR REPLACE FUNCTION actor.org_unit_descendants ( INT,INT ) RETURNS SETOF AS t(keyid text, parent_keyid text, level int, branch text,pos int) JOIN actor.org_unit a ON a.id = t.keyid ORDER BY CASE WHEN a.parent_ou IS NULL THEN 0 ELSE 1 END, a.name; -$$ LANGUAGE SQL; +$$ LANGUAGE SQL STABLE; -- 2.43.2