Index: openacs-4/packages/acs-kernel/sql/postgresql/utilities-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/utilities-create.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/acs-kernel/sql/postgresql/utilities-create.sql 20 Mar 2001 06:02:57 -0000 1.2 +++ openacs-4/packages/acs-kernel/sql/postgresql/utilities-create.sql 12 Jul 2003 01:10:36 -0000 1.3 @@ -8,30 +8,6 @@ -- @cvs-id utilities-create.sql,v 1.3 2000/11/02 17:55:51 yon Exp -- --- create or replace package util --- as --- function multiple_nextval( --- v_sequence_name in varchar2, --- v_count in integer) --- return varchar2; --- --- function computehash_raw( --- v_value IN varchar2 ) --- return raw; --- --- function computehash( --- v_value IN varchar2) --- return varchar2; --- --- function logical_negation ( --- true_or_false IN varchar2) --- return varchar2; --- end util; - --- show errors - --- create or replace package body util --- function multiple_nextval create function util__multiple_nextval (varchar,integer) returns varchar as ' declare @@ -52,47 +28,6 @@ end;' language 'plpgsql'; - -- This is for Password Hashing. - -- Make sure to run: 'loadjava -user username/password Security.class' - -- before running this. - -- Make sure you have javasyspriv and javauserpriv granted for the user. - --- function computehash_raw( v_value IN varchar2 ) --- return raw --- as language java --- name 'Security.computeSHA(java.lang.String) returns java.lang.byte[]'; - -create function RAWTOHEX(text) returns text as ' -declare - arg alias for $1; -begin - raise exception ''not implemented yet: depends on java code in acs classic''; - return ''''; -end;' language 'plpgsql'; - - -create function util__computehash_raw(text) returns text as ' -declare - arg alias for $1; -begin - raise exception ''not implemented yet: depends on java code in acs classic''; - return ''''; -end;' language 'plpgsql'; - - - -- The hashing function can be changed to MD5 by using computeMD5. - -create function util__computehash (varchar) returns varchar as ' -declare - v_value alias for $1; - v_hashed char(40); -begin - select RAWTOHEX(util__computehash_raw(v_value)) into v_hashed; - - return v_hashed; -end;' language 'plpgsql'; - - create function util__logical_negation (boolean) returns boolean as ' declare true_or_false alias for $1;