Index: openacs-4/packages/news/tcl/news-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/tcl/news-procs-oracle.xql,v
diff -u -r1.4 -r1.4.4.1
--- openacs-4/packages/news/tcl/news-procs-oracle.xql	30 Sep 2003 12:10:08 -0000	1.4
+++ openacs-4/packages/news/tcl/news-procs-oracle.xql	15 Feb 2005 20:12:28 -0000	1.4.4.1
@@ -49,5 +49,29 @@
       </querytext>
 </fullquery>
 
+
+<fullquery name="news__rss_datasource.get_news_items">
+        <querytext>
+    select * from (
+        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
+     ) where rownum <= $limit
+        </querytext>
+</fullquery>
  
 </queryset>
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.3 -r1.3.4.1
--- openacs-4/packages/news/tcl/news-procs-postgresql.xql	30 Nov 2002 17:39:09 -0000	1.3
+++ openacs-4/packages/news/tcl/news-procs-postgresql.xql	15 Feb 2005 20:12:28 -0000	1.3.4.1
@@ -44,5 +44,27 @@
       </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>
Index: openacs-4/packages/news/tcl/news-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/tcl/news-procs.xql,v
diff -u -r1.4.4.1 -r1.4.4.2
--- openacs-4/packages/news/tcl/news-procs.xql	4 Feb 2005 19:56:12 -0000	1.4.4.1
+++ openacs-4/packages/news/tcl/news-procs.xql	15 Feb 2005 20:12:28 -0000	1.4.4.2
@@ -29,26 +29,4 @@
         </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>