Index: openacs-4/packages/file-storage/tcl/file-storage-rss-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/tcl/file-storage-rss-procs-postgresql.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/file-storage/tcl/file-storage-rss-procs-postgresql.xql 4 Mar 2005 23:13:30 -0000 1.3
+++ openacs-4/packages/file-storage/tcl/file-storage-rss-procs-postgresql.xql 3 Sep 2024 15:37:38 -0000 1.4
@@ -14,38 +14,6 @@
between parent.tree_sortkey
and tree_right(parent.tree_sortkey))
-
+
-
-
- select * from (
- select o.object_id as item_id,
- o.title,
- o.name,
- o.file_upload_name,
- o.type,
- o.content_size,
- to_char(r.publish_date,'YYYY-MM-DD HH24:MI:SS') as publish_date_ansi,
- r.description,
- r.revision_id
- from fs_objects o,
- cr_revisions r
- where $parent_clause
- and type != 'folder'
- and $revisions_clause
- order by last_modified desc
- ) as v limit $max_items
-
-
-
-
-
- select (max(last_modified)-to_date('1970-01-01','YYYY-MM-DD'))*60*60*24 as last_update
- from fs_rss_subscrs s, fs_objects f
- where s.subscr_id = :summary_context_id
- and f.parent_id = s.folder_id
- and f.type != 'folder'
-
-
-
-
\ No newline at end of file
+