Index: openacs-4/packages/news-aggregator/tcl/source-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/tcl/source-procs-postgresql.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/news-aggregator/tcl/source-procs-postgresql.xql 20 Mar 2004 14:06:45 -0000 1.3 +++ openacs-4/packages/news-aggregator/tcl/source-procs-postgresql.xql 30 May 2004 12:29:56 -0000 1.4 @@ -13,13 +13,19 @@ + + + where last_scanned < (now() - '00:48:00'::time) + + + select source_id, feed_url, last_modified from na_sources - where last_scanned < (now() - '00:48:00'::time) + $time_limit order by last_scanned asc $limit_sql