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 -r1.12 -r1.13
--- openacs-4/packages/news/sql/postgresql/news-create.sql	17 May 2003 10:49:52 -0000	1.12
+++ openacs-4/packages/news/sql/postgresql/news-create.sql	23 Aug 2003 19:20:32 -0000	1.13
@@ -492,16 +492,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 (v_publish_date - current_timestamp))
-		+ extract(hours from (v_publish_date - current_timestamp))/24,1))
-		|| '' days'';
+                || to_char(extract(days from (v_publish_date - current_timestamp))
+	    + extract(hours from (v_publish_date - current_timestamp))/24,''999D9'')
+	    || '' days'';
             else 
                 return ''going live in ''
-                || text(round(extract(days from (v_publish_date - current_timestamp))
-		+ extract(hours from (v_publish_date - current_timestamp))/24,1))
+                || to_char(extract(days from (v_publish_date - current_timestamp))
+		+ extract(hours from (v_publish_date - current_timestamp))/24,''999D9'')
 		|| '' days'' || '', archived in ''
-                || text(round(extract(days from (v_archive_date - current_timestamp))
-		+ extract(hours from (v_archive_date - current_timestamp))/24,1))
+                || to_char(extract(days from (v_archive_date - current_timestamp))
+		+ extract(hours from (v_archive_date - current_timestamp))/24,''999D9'')
                 || '' days'';
             end if;  
         else
@@ -511,8 +511,8 @@
             else
                 if v_archive_date - current_timestamp > 0 then
                      return ''published, archived in ''
-		     || text(round(extract(days from (v_archive_date - current_timestamp))
-		     + extract(hours from (v_archive_date - current_timestamp))/24,1))
+		     || to_char(extract(days from (v_archive_date - current_timestamp))
+		     + extract(hours from (v_archive_date - current_timestamp))/24,''999D9'')
 		     || '' days'';
                 else 
                     return ''archived'';
