Index: openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-postgresql.xql,v diff -u -r1.2 -r1.3 --- openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-postgresql.xql 8 Feb 2002 07:27:34 -0000 1.2 +++ openacs-4/contrib/obsolete-packages/ticket-tracker-lite/www/ticket-postgresql.xql 26 Feb 2002 15:51:17 -0000 1.3 @@ -33,7 +33,7 @@ select * from (select p.first_names || ' ' || p.last_name as full_name, t.user_id, - case when a.user_id = null then 0 else 1 end + case when a.user_id is null then 0 else 1 end as already_assigned_p from ttl_v_users t left join (select user_id from ttl_assignments