Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql,v
diff -u -N -r1.40 -r1.40.2.1
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	17 May 2003 09:43:09 -0000	1.40
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-create.sql	24 Nov 2003 17:25:15 -0000	1.40.2.1
@@ -267,7 +267,7 @@
   p_item_id    alias for $1;
 begin
   return tree_sortkey from cr_items where item_id = p_item_id;
-end;' language 'plpgsql';
+end;' language 'plpgsql' stable strict;
 
 create function cr_items_tree_insert_tr () returns opaque as '
 declare
@@ -1004,7 +1004,7 @@
   p_keyword_id    alias for $1;
 begin
   return tree_sortkey from cr_keywords where keyword_id = p_keyword_id;
-end;' language 'plpgsql';
+end;' language 'plpgsql' stable strict;
 
 create function cr_keywords_tree_insert_tr () returns opaque as '
 declare