Index: openacs-4/packages/dotlrn/www/manage-memberships-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/Attic/manage-memberships-postgresql.xql,v diff -u -r1.2.2.2 -r1.2.2.3 --- openacs-4/packages/dotlrn/www/manage-memberships-postgresql.xql 15 Dec 2005 10:38:26 -0000 1.2.2.2 +++ openacs-4/packages/dotlrn/www/manage-memberships-postgresql.xql 24 Nov 2006 10:39:39 -0000 1.2.2.3 @@ -110,7 +110,7 @@ select dotlrn_class_instances_full.* from dotlrn_class_instances_full where dotlrn_class_instances_full.join_policy <> 'closed' - and active_end_date > (select sysdate from dual) + and (active_end_date > (select sysdate from dual) or active_end_date is null) and not exists (select 1 from dotlrn_member_rels_full where dotlrn_member_rels_full.user_id = :user_id