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.9 -r1.9.2.1
--- openacs-4/packages/file-storage/www/file-postgresql.xql	25 Sep 2003 13:55:04 -0000	1.9
+++ openacs-4/packages/file-storage/www/file-postgresql.xql	8 Dec 2003 15:12:09 -0000	1.9.2.1
@@ -17,7 +17,8 @@
        		r.title as name,
        		acs_permission__permission_p(:file_id,:user_id,'write') as write_p,
        		acs_permission__permission_p(:file_id,:user_id,'delete') as delete_p,
-       		acs_permission__permission_p(:file_id,:user_id,'admin') as admin_p
+       		acs_permission__permission_p(:file_id,:user_id,'admin') as admin_p,
+                content_item__get_path(o.object_id, :root_folder_id) as file_url
 	from   acs_objects o, cr_revisions r, cr_items i
 	where  o.object_id = :file_id
 	and    i.item_id   = o.object_id