Index: openacs-4/packages/contacts/sql/postgresql/contacts-search-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/sql/postgresql/contacts-search-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/contacts/sql/postgresql/contacts-search-create.sql	14 Jun 2005 06:08:28 -0000	1.2
+++ openacs-4/packages/contacts/sql/postgresql/contacts-search-create.sql	14 Jun 2005 06:21:48 -0000	1.3
@@ -61,35 +61,6 @@
         unique(search_id,user_id)
 );
 
-create or replace function contact_search__log (integer,integer)
-returns integer as '
-declare
-    p_search_id                     alias for $1;
-    p_user_id                       alias for $2;
-    v_last_search_id                integer;
-    v_exists_p
-begin
-       v_exists_p := ''1''::boolean from contact_search_log where search_id = p_search_id and user_id = p_user_id;
-
-       if v_exists_p then
-         update contact_searches
-            set n_searches = n_searches + 1,
-                last_search = now()
-          where search_id = p_search_id
-            and user_id = p_user_id;
-       else
-         insert into contact_searches
-         (search_id,user_id,n_searches,last_search)
-         values
-         (p_search_id,p_user_id,''1'':integer,now());
-       end if;
-
-    return ''1'';
-end;' language 'plpgsql';
-
-
-
-
 select define_function_args ('contact_search__new', 'search_id,title,owner_id,all_or_any,object_type,deleted_p,creation_date,creation_user,creation_ip,context_id');
 
 create or replace function contact_search__new (integer,varchar,integer,varchar,varchar,boolean,timestamptz,integer,varchar,integer)
