Index: openacs-4/packages/file-storage/www/file-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/www/Attic/file-postgresql.xql,v
diff -u -r1.13 -r1.14
--- openacs-4/packages/file-storage/www/file-postgresql.xql	27 Mar 2004 18:22:55 -0000	1.13
+++ openacs-4/packages/file-storage/www/file-postgresql.xql	17 May 2004 15:15:14 -0000	1.14
@@ -33,12 +33,14 @@
        		person__name(o.creation_user) as author,
                 o.creation_user as author_id,
        		r.mime_type as type,
+       		m.label as pretty_type,
                 to_char(o.last_modified,'YYYY-MM-DD HH24:MI:SS') as last_modified_ansi,
        		r.description,
        		acs_permission__permission_p(r.revision_id,:user_id,'admin') as admin_p,
        		acs_permission__permission_p(r.revision_id,:user_id,'delete') as delete_p,
-       		r.content_length as content_size
-	from   acs_objects o, cr_revisions r, cr_items i
+       		coalesce(r.content_length,0) as content_size
+	from   acs_objects o, cr_items i,cr_revisions r
+       		left join cr_mime_types m on r.mime_type=m.mime_type
 	where o.object_id = r.revision_id
 	  and r.item_id = i.item_id
 	  and r.item_id = :file_id