Index: openacs-4/packages/news/sql/oracle/news-views-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/sql/oracle/news-views-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/news/sql/oracle/news-views-create.sql	24 Feb 2005 18:03:04 -0000	1.1
+++ openacs-4/packages/news/sql/oracle/news-views-create.sql	22 Dec 2009 22:24:02 -0000	1.2
@@ -13,9 +13,8 @@
     cn.package_id, 
     cr.title as publish_title,
     cn.lead as publish_lead,
-    content.blob_to_string(cr.content) as publish_body,
-    cr.content as content,
-    decode(cr.mime_type, 'text/html','t','f') as html_p,
+    cr.content as publish_body,
+    cr.mime_type as publish_format,
     to_char(cr.publish_date, 'Mon dd, yyyy') as pretty_publish_date,
     cr.publish_date,
     ao.creation_user,
@@ -46,8 +45,8 @@
     cn.archive_date,
     cr.title as publish_title,
     cn.lead as publish_lead,
-    content.blob_to_string(cr.content) as publish_body,
-    decode(cr.mime_type, 'text/html','t','f') as html_p,
+    cr.content as publish_body,
+    cr.mime_type as publish_format,
     ao.creation_user,
     ps.first_names || ' ' || ps.last_name as item_creator,
     ao.creation_date,
@@ -111,11 +110,11 @@
     ci.live_revision,
     cr.title as publish_title,
     cn.lead as publish_lead,
-    content.blob_to_string(cr.content) as publish_body,
+    cr.content as publish_body,
     cr.publish_date,
     cn.archive_date,
     cr.description as log_entry,
-    decode(cr.mime_type,'text/html','t','f') as html_p,
+    cr.mime_type as publish_format,
     cr.mime_type as mime_type,
     cn.package_id,
     ao.creation_date as creation_date,
@@ -175,8 +174,8 @@
     revision_id,        
     cr.title as publish_title,
     cn.lead as publish_lead,
-    content.blob_to_string(cr.content) as publish_body,
-    decode(cr.mime_type,'text/html','t','f') as html_p,
+    cr.content as publish_body,
+    cr.mime_type as publish_format,
     cr.publish_date,
     cn.archive_date,
     news.status(cr.publish_date, cn.archive_date) as status,
