Index: openacs-4/packages/news-aggregator/tcl/news-aggregator-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/tcl/Attic/news-aggregator-procs-oracle.xql,v diff -u -N -r1.2 -r1.2.4.1 --- openacs-4/packages/news-aggregator/tcl/news-aggregator-procs-oracle.xql 28 Aug 2003 09:41:57 -0000 1.2 +++ openacs-4/packages/news-aggregator/tcl/news-aggregator-procs-oracle.xql 19 Apr 2004 10:06:20 -0000 1.2.4.1 @@ -56,4 +56,19 @@ + + + select q.* from ( + select deleted_p, item_id, i.title as item_title, i.description as item_description + from na_sources s, na_items i + where owner_id = :owner_id + and s.source_id = i.source_id + and i.$identifier = :$identifier + and feed_url = :feed_url + order by item_id + ) q where rownum = 1 + + + + Index: openacs-4/packages/news-aggregator/tcl/news-aggregator-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/tcl/Attic/news-aggregator-procs-postgresql.xql,v diff -u -N -r1.2 -r1.2.4.1 --- openacs-4/packages/news-aggregator/tcl/news-aggregator-procs-postgresql.xql 28 Aug 2003 09:41:57 -0000 1.2 +++ openacs-4/packages/news-aggregator/tcl/news-aggregator-procs-postgresql.xql 19 Apr 2004 10:06:20 -0000 1.2.4.1 @@ -68,4 +68,17 @@ + + + select deleted_p, item_id, i.title as item_title, i.description as item_description + from na_sources s, na_items i + where owner_id = :owner_id + and s.source_id = i.source_id + and i.$identifier = :$identifier + and feed_url = :feed_url + order by item_id + limit 1 + + + Index: openacs-4/packages/news-aggregator/tcl/news-aggregator-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/tcl/Attic/news-aggregator-procs.xql,v diff -u -N -r1.2 -r1.2.4.1 --- openacs-4/packages/news-aggregator/tcl/news-aggregator-procs.xql 28 Aug 2003 09:41:57 -0000 1.2 +++ openacs-4/packages/news-aggregator/tcl/news-aggregator-procs.xql 19 Apr 2004 10:06:20 -0000 1.2.4.1 @@ -29,18 +29,6 @@ - - - select deleted_p, item_id, i.title as item_title, i.description as item_description - from na_sources s, na_items i - where owner_id = :owner_id - and s.source_id = i.source_id - and i.$identifier = :$identifier - and feed_url = :feed_url - order by item_id - - - update na_sources