Index: openacs-4/packages/cms/www/modules/items/publish-status-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/items/publish-status-postgresql.xql,v diff -u -r1.2 -r1.2.14.1 --- openacs-4/packages/cms/www/modules/items/publish-status-postgresql.xql 9 Jun 2001 01:06:04 -0000 1.2 +++ openacs-4/packages/cms/www/modules/items/publish-status-postgresql.xql 31 May 2005 04:59:44 -0000 1.2.14.1 @@ -7,11 +7,7 @@ select - coalesce(initcap(publish_status), 'Production') as publish_status, - coalesce(to_char(start_when, 'MM/DD/YY HH:MI AM'), 'Immediate') as start_when, - coalesce(to_char(end_when, 'MM/DD/YY HH:MI AM'), 'Indefinite') as end_when, - content_item__is_publishable(:item_id) as is_publishable, - live_revision + publish_status, start_when, end_when from cr_items i left outer join cr_release_periods r using (item_id) where @@ -21,21 +17,6 @@ - - - - select - content_item__is_publishable( item_id ) as is_publishable, - live_revision - from - cr_items - where - item_id = :item_id - - - - -