Index: openacs-4/packages/curriculum-central/tcl/curriculum-central-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/curriculum-central/tcl/curriculum-central-procs-postgresql.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/curriculum-central/tcl/curriculum-central-procs-postgresql.xql	20 Nov 2005 23:52:09 -0000	1.1
+++ openacs-4/packages/curriculum-central/tcl/curriculum-central-procs-postgresql.xql	4 Dec 2005 07:32:38 -0000	1.2
@@ -38,6 +38,24 @@
      </querytext>
    </fullquery>
 
+   <fullquery name="curriculum_central::non_staff_get_options.non_staff">
+     <querytext>
+       SELECT first_names || ' ' || last_name || ' (' || email || ')'  AS name,
+           user_id
+	   FROM   cc_users
+	   WHERE user_id NOT IN (SELECT staff_id FROM cc_staff)
+     </querytext>
+   </fullquery>
+
+   <fullquery name="curriculum_central::staff_get_options.staff">
+     <querytext>
+       SELECT s.title || ' ' || u.first_names || ' ' || u.last_name || ' (' || email || ')'  AS name,
+           staff_id
+	   FROM   cc_staff s, cc_users u
+	   WHERE s.staff_id = u.user_id
+     </querytext>
+   </fullquery>
+
    <fullquery name="curriculum_central::departments_get_options.departments">
      <querytext>
        SELECT department_name, department_id FROM cc_department