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.4
--- 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	24 Feb 2005 13:33:23 -0000	1.4
@@ -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>