Index: openacs-4/contrib/packages/bcms/tcl/bcms-revision-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/bcms/tcl/bcms-revision-procs-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/contrib/packages/bcms/tcl/bcms-revision-procs-postgresql.xql	9 Oct 2003 09:57:17 -0000	1.4
+++ openacs-4/contrib/packages/bcms/tcl/bcms-revision-procs-postgresql.xql	27 Oct 2003 10:09:10 -0000	1.5
@@ -33,10 +33,11 @@
 	<fullquery name="bcms::revision::list_revisions.get_revisions">
 		<querytext>
 			select x.revision_id, x.name, x.title, x.description, p.first_names, p.last_name, 
-				to_char(x.creation_date,'HH:MI AM MM/DD/YYYY') as creation_date, l.live_revision_id
+				to_char(x.last_modified,'HH:MI AM MM/DD/YYYY') as creation_date, l.live_revision_id
 				from ${table_name}x x, persons p, (select content_item__get_live_revision(:item_id) as live_revision_id) l
 			where x.creation_user = p.person_id
-			and x.item_id = :item_id;
+			and x.item_id = :item_id
+            order by x.last_modified desc;
 		</querytext>
 	</fullquery>