Index: openacs-4/packages/ams/tcl/ams-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ams/tcl/ams-procs-postgresql.xql,v
diff -u -N -r1.11 -r1.12
--- openacs-4/packages/ams/tcl/ams-procs-postgresql.xql	10 Jun 2005 09:43:22 -0000	1.11
+++ openacs-4/packages/ams/tcl/ams-procs-postgresql.xql	22 Jul 2005 07:49:17 -0000	1.12
@@ -170,5 +170,15 @@
          order by alam.sort_order
   </querytext>
 </fullquery>
+  
+  <fullquery name="ams::value.select_value">
+    <querytext>
+      select ams_attribute_value__value(av.attribute_id,av.value_id) as value, widget,attribute_name,av.attribute_id
+      from ams_attribute_values av, ams_attributes aa 
+      where object_id = :object_id
+      and av.attribute_id = aa.attribute_id
+      $where_clause
+    </querytext>
+  </fullquery>
 
 </queryset>