Index: openacs-4/packages/file-storage/tcl/file-storage-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/tcl/file-storage-procs-postgresql.xql,v
diff -u -r1.29 -r1.29.2.1
--- openacs-4/packages/file-storage/tcl/file-storage-procs-postgresql.xql	17 Sep 2002 21:03:26 -0000	1.29
+++ openacs-4/packages/file-storage/tcl/file-storage-procs-postgresql.xql	21 Jan 2003 13:50:16 -0000	1.29.2.1
@@ -44,10 +44,12 @@
 
     <fullquery name="fs::get_folder_contents.select_folder_contents">
         <querytext>
--- we use $ n_past-days instead of :n_past_days becasuse he pgdriver
+
+-- we use $ n_past-days instead of :n_past_days because the pgdriver
 -- bind variable emulation puts single-quotes around the n_past_days
 -- integer. Postgresql tries to turn '-1' into a date datatype
--- so now()-'-1' fails but now()- -1 works fine.
+-- so now()-'-1' fails but now()- interval '-1' works fine.
+
 	select fc.*
             from (select fs_objects.object_id,
                          fs_objects.name,
@@ -59,7 +61,7 @@
                          fs_objects.key,
                          fs_objects.sort_key,
                          fs_objects.file_upload_name,
-                         case when fs_objects.last_modified >= (now() - $n_past_days) then 1 else 0 end as new_p,
+                         case when fs_objects.last_modified >= (now() - interval '$n_past_days days') then 1 else 0 end as new_p,
                          acs_permission__permission_p(fs_objects.object_id, :user_id, 'admin') as admin_p,
                          acs_permission__permission_p(fs_objects.object_id, :user_id, 'delete') as delete_p,
                          acs_permission__permission_p(fs_objects.object_id, :user_id, 'write') as write_p