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 -r1.3 -r1.4
--- openacs-4/packages/curriculum-central/tcl/curriculum-central-procs-postgresql.xql 12 Jan 2006 07:15:23 -0000 1.3
+++ openacs-4/packages/curriculum-central/tcl/curriculum-central-procs-postgresql.xql 22 Feb 2006 06:28:38 -0000 1.4
@@ -70,4 +70,24 @@
+
+
+ SELECT name FROM cc_session
+ WHERE session_id = :session_id
+ AND package_id = :package_id
+
+
+
+
+
+ SELECT gan.name
+ FROM cc_uos_gradattr_name gan, cc_uos_gradattr_map gam,
+ cc_uos_gradattr ga, cc_uos_gradattr_set gas
+ WHERE gas.parent_uos_id = :uos_id
+ AND gas.latest_revision_id = gam.revision_id
+ AND gam.gradattr_id = ga.gradattr_id
+ AND ga.name_id = gan.name_id
+
+
+