Index: openacs-4/packages/news/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/www/Attic/index-oracle.xql,v
diff -u -N
--- openacs-4/packages/news/www/index-oracle.xql	15 Oct 2001 13:41:03 -0000	1.1
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,48 +0,0 @@
-<?xml version="1.0"?>
-
-<queryset>
-   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
-
-<fullquery name="archived_p">      
-      <querytext>
-      
-    select case when count(*) = 0 then 0 else 1 end 
-    from   news_items_approved
-    where  publish_date < sysdate 
-    and    archive_date < sysdate
-    and    package_id = :package_id
-      </querytext>
-</fullquery>
-
- 
-<fullquery name="live_p">      
-      <querytext>
-      
-    select case when count(*) = 0 then 0 else 1 end 
-    from   news_items_approved
-    where  publish_date < sysdate 
-    and    (archive_date is null 
-            or archive_date > sysdate) 
-    and    package_id = :package_id
-      </querytext>
-</fullquery>
-
-
-<partialquery name="view_clause_live">      
-      <querytext>
-
-    publish_date < sysdate 
-    and (archive_date is null or archive_date > sysdate)      
-      </querytext>
-</partialquery>
-
-
-<partialquery name="view_clause_archived">      
-      <querytext>
-
-    publish_date < sysdate
-    and archive_date < sysdate
-      </querytext>
-</partialquery>
-
-</queryset>