Index: openacs-4/packages/news/sql/postgresql/news-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/sql/postgresql/news-create.sql,v
diff -u -N -r1.7 -r1.7.2.1
--- openacs-4/packages/news/sql/postgresql/news-create.sql	26 Oct 2001 10:15:03 -0000	1.7
+++ openacs-4/packages/news/sql/postgresql/news-create.sql	2 Apr 2002 14:18:48 -0000	1.7.2.1
@@ -504,16 +504,16 @@
 	    -- to get the same result as Oracle (eg, 2.4 days)
             if v_archive_date is null then 
                 return ''going live in ''
-                || text(round(extract(days from interval (v_publish_date - current_timestamp))
-		+ extract(hours from interval (v_publish_date - current_timestamp))/24,1))
+                || text(round(extract(days from (v_publish_date - current_timestamp))
+		+ extract(hours from (v_publish_date - current_timestamp))/24,1))
 		|| '' days'';
             else 
                 return ''going live in ''
-                || text(round(extract(days from interval (v_publish_date - current_timestamp))
-		+ extract(hours from interval (v_publish_date - current_timestamp))/24,1))
+                || text(round(extract(days from (v_publish_date - current_timestamp))
+		+ extract(hours from (v_publish_date - current_timestamp))/24,1))
 		|| '' days'' || '', archived in ''
-                || text(round(extract(days from interval (v_archive_date - current_timestamp))
-		+ extract(hours from interval (v_archive_date - current_timestamp))/24,1))
+                || text(round(extract(days from (v_archive_date - current_timestamp))
+		+ extract(hours from (v_archive_date - current_timestamp))/24,1))
                 || '' days'';
             end if;  
         else
@@ -523,8 +523,8 @@
             else
                 if v_archive_date - current_timestamp > 0 then
                      return ''published, archived in ''
-		     || text(round(extract(days from interval (v_archive_date - current_timestamp))
-		     + extract(hours from interval (v_archive_date - current_timestamp))/24,1))
+		     || text(round(extract(days from (v_archive_date - current_timestamp))
+		     + extract(hours from (v_archive_date - current_timestamp))/24,1))
 		     || '' days'';
                 else 
                     return ''archived'';
