Index: openacs-4/packages/cms/www/modules/items/revision-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/items/revision-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/cms/www/modules/items/revision-postgresql.xql	30 May 2001 22:56:27 -0000	1.2
+++ openacs-4/packages/cms/www/modules/items/revision-postgresql.xql	12 Jun 2001 04:13:46 -0000	1.3
@@ -16,7 +16,7 @@
        cr_mime_types 
      where 
        mime_type = cr_revisions.mime_type
-    ) mime_type_pretty,
+    ) as mime_type_pretty,
     to_char(publish_date,'Month DD, YYYY') as publish_date_pretty,
     content_length as content_size
   from 
@@ -96,5 +96,18 @@
       </querytext>
 </fullquery>
 
+<fullquery name="get_content">      
+      <querytext>
+
+      select 
+        content
+      from
+        cr_revisions
+      where
+        revision_id = :revision_id
+    
+      </querytext>
+</fullquery>
+
  
 </queryset>