Index: openacs-4/packages/assessment/www/show_items-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/Attic/show_items-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/assessment/www/show_items-postgresql.xql	7 Jun 2004 15:10:41 -0000	1.2
+++ openacs-4/packages/assessment/www/show_items-postgresql.xql	20 Jul 2004 18:11:15 -0000	1.3
@@ -1,12 +1,12 @@
 <?xml version="1.0"?>
 <queryset>
-	<rdbms><type>postgresql</type><version>7.1</version></rdbms>
+	<rdbms><type>postgresql</type><version>7.4</version></rdbms>
 
 	<fullquery name="query_all_items">
 		<querytext>
-			select as_items.item_id, as_items.item_text, as_items.required_p, as_item_display_types.presentation_type 
-			from as_items, as_item_display_types where as_items.item_display_type_id=as_item_display_types.item_display_type_id        
+			select as_itemsx.as_item_id, as_itemsx.name, as_itemx.title
+			from as_itemsx
 		</querytext>
 	</fullquery>
 
-</queryset>
\ No newline at end of file
+</queryset>