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