Index: openacs-4/packages/file-storage/www/index-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/www/Attic/index-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/file-storage/www/index-postgresql.xql 13 Aug 2001 01:07:52 -0000 1.1 +++ openacs-4/packages/file-storage/www/index-postgresql.xql 20 Aug 2001 17:30:00 -0000 1.2 @@ -12,9 +12,7 @@ r.mime_type as type, to_char(o.last_modified,'YYYY-MM-DD HH24:MI') as last_modified, -- dbms_lob.getlength(r.content) as content_size, - -- instead of above, we rely on CR to calculate for us - -- the size of r.content. - r.content_length as content_size, + lob_length(r.lob) as content_size, 1 as ordering_key from cr_items i left join cr_revisions r on (i.live_revision = r.revision_id), acs_objects o where i.item_id = o.object_id