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 + + +