Index: openacs-4/packages/cms/www/modules/sitemap/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/sitemap/index-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/cms/www/modules/sitemap/index-postgresql.xql	25 Jul 2001 03:53:11 -0000	1.4
+++ openacs-4/packages/cms/www/modules/sitemap/index-postgresql.xql	22 Sep 2003 11:55:37 -0000	1.5
@@ -13,7 +13,7 @@
          else coalesce(v.title, i.name) end as title,
     case when r.item_id = :index_page_id then 't' 
                                          else 'f' end as is_index_page,
-    coalesce(round(v.content_length::float8 / 1000.0, 2)::float8::text, '-') as file_size
+    coalesce(round(v.content_length::numeric / 1000.0, 2)::float8::text, '-') as file_size
   from 
     cr_items i 
         LEFT OUTER JOIN 
@@ -53,7 +53,7 @@
     o.object_type, t.pretty_name as content_type,
     to_char(o.last_modified, 'MM/DD/YYYY HH24:MI') as last_modified_date,
     case when r.item_id = :index_page_id then 't' else 'f' end as is_index_page,
-    coalesce(round(v.content_length::float8 / 1000.0, 2)::float8::text, '-') as file_size
+    coalesce(round(v.content_length::numeric / 1000.0, 2)::float8::text, '-') as file_size
   from 
     cr_items i
         LEFT OUTER JOIN
Index: openacs-4/packages/cms/www/modules/templates/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/templates/index-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/cms/www/modules/templates/index-postgresql.xql	31 Aug 2001 02:28:40 -0000	1.2
+++ openacs-4/packages/cms/www/modules/templates/index-postgresql.xql	22 Sep 2003 11:55:37 -0000	1.3
@@ -35,7 +35,7 @@
   select
     t.template_id, i.name, 
     to_char(o.last_modified, 'MM/DD/YY HH:MI AM') as modified,
-    coalesce(round(r.content_length::float8 / 1000,2), 0)::float8::text || ' KB'::text as file_size
+    coalesce(round(r.content_length::numeric / 1000,2), 0)::float8::text || ' KB'::text as file_size
   from
     cr_templates t, acs_objects o, 
     cr_revisions r 
Index: openacs-4/packages/cms/www/modules/templates/revisions-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/templates/revisions-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/cms/www/modules/templates/revisions-postgresql.xql	31 Aug 2001 02:28:40 -0000	1.2
+++ openacs-4/packages/cms/www/modules/templates/revisions-postgresql.xql	22 Sep 2003 11:55:37 -0000	1.3
@@ -9,7 +9,7 @@
   select
     revision_id,
     to_char(o.creation_date, 'MM/DD/YY HH:MI AM') as modified,
-    (round(r.content_length::float8 / 1000.0,2)::float8::text || ' KB'::text) as file_size,
+    (round(r.content_length::numeric / 1000.0,2)::float8::text || ' KB'::text) as file_size,
     case when coalesce(p.person_id, 0) = 0 
             then '-' 
             else substr(p.first_names, 1, 1) || substr(p.last_name, 1, 1) end as modified_by,