Index: openacs-4/packages/news-aggregator/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/www/Attic/index-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/news-aggregator/www/index-postgresql.xql	28 Aug 2003 09:41:57 -0000	1.2
+++ openacs-4/packages/news-aggregator/www/index-postgresql.xql	20 Mar 2004 11:12:29 -0000	1.3
@@ -3,25 +3,34 @@
 <queryset>
    <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
-<fullquery name="items">
-      <querytext>
-	select s.source_id, 
-               s.link, 
-               s.description,
-               s.title, 
-               to_char(creation_date, 'YYYY-MM-DD HH24:MI:SS') as last_scanned,
-               to_char(creation_date, 'YYYY-MM-DD HH24') as sort_date,
-	       feed_url, 
-	       item_id, 
-               i.title as item_title, 
-               i.link as item_link, 
-               i.description as item_description
-        from na_sources s, na_items i
-	where owner_id = :user_id AND deleted_p = '0'
-        and   s.source_id = i.source_id
-	order by creation_date desc
-	limit $limit
-</querytext>
+<fullquery name="saved_items">
+	<querytext>
+		select item_id
+		from na_saved_items
+		where aggregator_id = :aggregator_id
+	</querytext>
 </fullquery>
 
+<fullquery name="aggregator_info">
+	<querytext>
+          select aggregator_name, 
+                 description as aggregator_description, 
+                 public_p
+          from   na_aggregators
+          where  aggregator_id = :aggregator_id
+	</querytext>
+</fullquery>
+
+<fullquery name="purges">
+    <querytext>
+        select
+		top, bottom
+	from
+		na_purges
+	where
+		aggregator_id = :aggregator_id
+ 	order by top desc, bottom desc
+    </querytext>
+</fullquery>
+
 </queryset>