Index: openacs-4/packages/notifications/tcl/sweep-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/tcl/Attic/sweep-procs-postgresql.xql,v diff -u -r1.5 -r1.6 --- openacs-4/packages/notifications/tcl/sweep-procs-postgresql.xql 4 Jul 2003 20:40:26 -0000 1.5 +++ openacs-4/packages/notifications/tcl/sweep-procs-postgresql.xql 4 Jul 2003 21:18:32 -0000 1.6 @@ -26,8 +26,7 @@ type_id, delivery_method_id, response_id, - notif_date, - notif_user + notif_date from notifications inner join notification_requests using (type_id, object_id) inner join acs_objects on (notification_requests.request_id = acs_objects.object_id) left outer join notification_user_map using (notification_id, user_id)