Index: openacs-4/packages/acs-content-repository/sql/postgresql/doc-package.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/doc-package.sql,v
diff -u -r1.4 -r1.4.10.1
--- openacs-4/packages/acs-content-repository/sql/postgresql/doc-package.sql	13 May 2001 18:17:01 -0000	1.4
+++ openacs-4/packages/acs-content-repository/sql/postgresql/doc-package.sql	24 Nov 2003 17:25:15 -0000	1.4.10.1
@@ -2,25 +2,9 @@
 -- Return function headers for packages
 ---------------------------------------
 
--- create or replace package doc
--- is
--- 
---   function get_proc_header (
---     proc_name    in varchar2,
---     package_name in varchar2
---   ) return varchar2;
--- 
---   function get_package_header (
---     package_name in varchar2
---   ) return varchar2;
--- 
--- end doc;
-
 -- show errors
 
--- create or replace package body doc
--- function get_proc_header
-create function doc__get_proc_header (varchar,varchar)
+create or replace function doc__get_proc_header (varchar,varchar)
 returns varchar as '
 declare
   proc_name              alias for $1;  
@@ -31,24 +15,17 @@
          where fname = (package_name || ''__'' || proc_name)::name 
          limit 1;
 
-end;' language 'plpgsql';
+end;' language 'plpgsql' stable;
 
 
--- function get_package_header
-create function doc__get_package_header (varchar)
+create or replace function doc__get_package_header (varchar)
 returns varchar as '
 declare
   package_name           alias for $1;  
 begin
 
         return '''';
-   
-end;' language 'plpgsql';
 
+end;' language 'plpgsql' immutable strict;
 
-
 -- show errors
-         
-      
-
-