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.2 -r1.3
--- openacs-4/packages/file-storage/www/index-postgresql.xql	20 Aug 2001 17:30:00 -0000	1.2
+++ openacs-4/packages/file-storage/www/index-postgresql.xql	22 Sep 2001 05:55:54 -0000	1.3
@@ -6,13 +6,12 @@
 <fullquery name="file_select">      
       <querytext>
 	select 	i.item_id as file_id,
-       		r.title as name,
+       		i.name as name,
        		i.live_revision,
-       		content_item__get_path(i.item_id,file_storage__get_root_folder(:package_id)) as path,
+       		file_storage__get_path(i.item_id,file_storage__get_root_folder(:package_id)) as path,
        		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,
-	        lob_length(r.lob) as content_size,
+	        r.content_length 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
@@ -23,7 +22,7 @@
 	select 	i.item_id as file_id,
        		f.label as name,
        		0,
-       		content_item__get_path(f.folder_id,null) as path,
+       		file_storage__get_path(f.folder_id,null) as path,
        		'Folder',
        		NULL,
        		0,