Index: openacs-4/contrib/packages/bcms/tcl/bcms-item-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/bcms/tcl/bcms-item-procs-postgresql.xql,v diff -u -r1.9 -r1.10 --- openacs-4/contrib/packages/bcms/tcl/bcms-item-procs-postgresql.xql 3 Nov 2003 14:08:11 -0000 1.9 +++ openacs-4/contrib/packages/bcms/tcl/bcms-item-procs-postgresql.xql 17 Dec 2003 03:50:05 -0000 1.10 @@ -161,17 +161,6 @@ - - - select item_id, name, parent_id, storage_type, content_type, storage_type, publish_status, - revision_id, title, content, description, publish_date, mime_type - from cr_items i, cr_revisions r where - i.item_id = r.item_id - and i.item_id = :item_id - and content_item__get_best_revision(:item_id) = r.revision_id - - - select i.item_id, i.name, i.publish_status, i.content_type, i.storage_type $addtnl_select