Index: openacs-4/packages/file-storage/www/folder-chunk-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/www/folder-chunk-postgresql.xql,v
diff -u -r1.1 -r1.1.2.1
--- openacs-4/packages/file-storage/www/folder-chunk-postgresql.xql	17 Sep 2002 21:03:27 -0000	1.1
+++ openacs-4/packages/file-storage/www/folder-chunk-postgresql.xql	21 Jan 2003 13:50:27 -0000	1.1.2.1
@@ -8,12 +8,13 @@
                          fs_objects.name,
                          fs_objects.live_revision,
                          fs_objects.type,
-                         to_char(fs_objects.last_modified, 'Month DD YYYY HH24:MI') as last_modified,
+                         to_char(fs_objects.last_modified, 'YYYY-MM-DD HH24:MI:SS') as last_modified,      
                          fs_objects.content_size,
                          fs_objects.url,
                          fs_objects.key,
                          fs_objects.sort_key,
 			 fs_objects.file_upload_name,
+                         case when fs_objects.last_modified >= (now() - interval '$n_past_days days') then 1 else 0 end as new_p
                          case when fs_objects.last_modified >= (now() - $n_past_days) then 1 else 0 end as new_p
                   from fs_objects
                   where fs_objects.parent_id = :folder_id