Index: openacs-4/packages/search/sql/postgresql/search-packages-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/postgresql/search-packages-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/search/sql/postgresql/search-packages-create.sql	2 Jul 2002 01:52:39 -0000	1.2
+++ openacs-4/packages/search/sql/postgresql/search-packages-create.sql	30 Nov 2002 17:46:00 -0000	1.3
@@ -24,15 +24,15 @@
 create function search_observer__dequeue(integer,timestamp,varchar)
 returns integer as '
 declare
-    p_object_id			alias for $1;
-    p_event_date		alias for $2;
-    p_event			alias for $3;
+    p_object_id                 alias for $1;
+    p_event_date                alias for $2;
+    p_event                     alias for $3;
 begin
 
     delete from search_observer_queue 
     where object_id = p_object_id 
     and event = p_event
-    and event_date = p_event_date;
+    and to_char(event_date,''yyyy-mm-dd hh24:mi:ss.us-tz'') = to_char(p_event_date,''yyyy-mm-dd hh24:mi:ss.us-tz'');
 
     return 0;
 
