Index: openacs.org-dev/packages/file-storage/tcl/file-storage-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs.org-dev/packages/file-storage/tcl/file-storage-procs-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs.org-dev/packages/file-storage/tcl/file-storage-procs-postgresql.xql	12 Jul 2002 12:05:37 -0000	1.2
+++ openacs.org-dev/packages/file-storage/tcl/file-storage-procs-postgresql.xql	12 Jul 2002 15:13:30 -0000	1.3
@@ -46,7 +46,11 @@
 
     <fullquery name="fs::get_folder_contents.select_folder_contents">
         <querytext>
-            select fc.*
+-- we use $n_past-days instead of :n_past_days becasuse he 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.
+	select fc.*
             from (select fs_objects.object_id,
                          fs_objects.name,
                          fs_objects.live_revision,