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 +