Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql,v
diff -u -r1.20 -r1.21
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql	9 Jun 2001 01:06:04 -0000	1.20
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-item.sql	14 Jun 2001 00:23:21 -0000	1.21
@@ -430,8 +430,8 @@
   is_published__item_id                alias for $1;  
 begin
 
-  select
-    1
+  return
+    count(*) > 0
   from
     cr_items
   where
@@ -440,12 +440,6 @@
     publish_status = ''live''
   and
     item_id = is_published__item_id;
-
-  if NOT FOUND then 
-     return ''f'';
-  else 
-     return ''t'';
-  end if;
  
 end;' language 'plpgsql';
 
@@ -493,10 +487,6 @@
 
   end LOOP;
 
-  if NOT FOUND then 
-     return ''f'';
-  end if;
-
   -- validate relations
   -- make sure the # of ext links of each type fall between min_n and max_n
   for v_rel_type in select
@@ -529,10 +519,6 @@
     end if;
   end loop;
 
-  if NOT FOUND then 
-     return ''f'';
-  end if;
-
   -- validate publishing workflows
   -- make sure any ''publishing_wf'' associated with this item are finished
   -- KG: logic is wrong here.  Only the latest workflow matters, and even