Index: openacs-4/packages/news/tcl/news-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/tcl/news-procs-postgresql.xql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/news/tcl/news-procs-postgresql.xql	10 Jul 2018 13:48:19 -0000	1.7
+++ openacs-4/packages/news/tcl/news-procs-postgresql.xql	3 Sep 2024 15:37:39 -0000	1.8
@@ -3,57 +3,33 @@
 <queryset>
    <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
-<fullquery name="news_items_archive.news_item_archive">      
+<fullquery name="news_items_archive.news_item_archive">
       <querytext>
 
           select news__archive(
 	      :id, -- item_id
 	      :when -- archive_date
 	  );
-	
+
       </querytext>
 </fullquery>
 
- 
-<fullquery name="news_items_make_permanent.news_item_make_permanent">      
+
+<fullquery name="news_items_make_permanent.news_item_make_permanent">
       <querytext>
 
           select news__make_permanent(:id);
-	
+
       </querytext>
 </fullquery>
 
- 
-<fullquery name="news_items_delete.news_item_delete">      
+
+<fullquery name="news_items_delete.news_item_delete">
       <querytext>
 
           select news__delete(:id);
-	
+
       </querytext>
 </fullquery>
 
-
-<fullquery name="news__rss_datasource.get_news_items">
-        <querytext>
-        select cn.*,
-        ci.item_id,
-        cr.content,
-        cr.title,
-        cr.mime_type,
-        cr.description,
-        to_char(o.last_modified, 'YYYY-MM-DD HH24:MI:SS') as last_modified
-        from cr_news cn,
-        cr_revisions cr,
-        cr_items ci,
-        acs_objects o
-        where cn.package_id=:summary_context_id
-        and cr.revision_id=cn.news_id
-        and cn.news_id=o.object_id
-        and cr.item_id=ci.item_id
-        and cr.revision_id=ci.live_revision
-        order by o.last_modified desc
-        limit $limit
-        </querytext>
-</fullquery>
- 
 </queryset>