Index: openacs-4/packages/notifications/tcl/sweep-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/tcl/sweep-procs-postgresql.xql,v diff -u -r1.7 -r1.8 --- openacs-4/packages/notifications/tcl/sweep-procs-postgresql.xql 28 Aug 2003 09:41:58 -0000 1.7 +++ openacs-4/packages/notifications/tcl/sweep-procs-postgresql.xql 6 Sep 2006 18:11:56 -0000 1.8 @@ -33,6 +33,7 @@ left outer join notification_user_map using (notification_id, user_id) where sent_date is null and creation_date <= notif_date + and notif_date < current_timestamp and interval_id = :interval_id order by user_id, type_id, notif_date