Index: openacs-4/packages/file-storage/sql/postgresql/file-storage-views-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/sql/postgresql/file-storage-views-create.sql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/file-storage/sql/postgresql/file-storage-views-create.sql	17 May 2004 15:15:13 -0000	1.9
+++ openacs-4/packages/file-storage/sql/postgresql/file-storage-views-create.sql	29 Jun 2004 10:18:23 -0000	1.10
@@ -76,9 +76,10 @@
       case
         when cr_items.content_type = 'content_folder' then cr_folders.label
         when cr_items.content_type = 'content_extlink' then cr_extlinks.label
-        else coalesce(cr_revisions.title,cr_items.name)
+        else cr_items.name
       end as name,
       cr_items.name as file_upload_name,
+      cr_revisions.title,
       cr_revisions.mime_type,
       acs_objects.last_modified,
       cr_extlinks.url,
@@ -88,7 +89,7 @@
         when cr_items.content_type = 'content_folder' then 0
         else 1
       end as sort_key,
-	cr_mime_types.label as pretty_type
+      cr_mime_types.label as pretty_type
 
     from cr_items left join cr_extlinks on (cr_items.item_id = cr_extlinks.extlink_id)