Index: openacs-4/packages/dotlrn-ecommerce/lib/tree-chunk-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/lib/tree-chunk-postgresql.xql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/dotlrn-ecommerce/lib/tree-chunk-postgresql.xql	16 Aug 2005 02:01:10 -0000	1.6
+++ openacs-4/packages/dotlrn-ecommerce/lib/tree-chunk-postgresql.xql	20 Aug 2005 18:27:54 -0000	1.7
@@ -20,7 +20,10 @@
 		select dc.course_id, dc.course_key, dc.course_name,
 			dc.assessment_id, dec.section_id, dec.section_name,
 			dec.product_id, dec.community_id, dc.course_info,
-			ci.item_id, v.maxparticipants, dec.show_participants_p, dec.show_sessions_p, dec.description
+			ci.item_id, v.maxparticipants, dec.show_participants_p, dec.show_sessions_p, dec.description, v.show_description_p
+
+		$discount_clause
+
 		from dotlrn_catalog dc,
 		cr_items ci
 		left join dotlrn_ecommerce_section dec
@@ -62,4 +65,12 @@
 	</querytext>
 	</fullquery>
 
+	<partialquery name="discount">
+	<querytext>
+            , (select count(*)
+	    from ec_sale_prices_current
+	    where product_id = dec.product_id) as has_discount_p
+	</querytext>
+	</partialquery>
+
 </queryset>