Index: openacs-4/packages/acs-content-repository/tcl/content-item-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/tcl/Attic/content-item-procs-postgresql.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-content-repository/tcl/content-item-procs-postgresql.xql	28 Aug 2020 14:51:34 -0000	1.1.2.1
@@ -0,0 +1,15 @@
+<?xml version="1.0"?>
+
+<queryset>
+  <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+  <fullquery name="content::item::content_is_null.cin_get_content">
+    <querytext>
+      select 't' from cr_revisions r, cr_items i
+      where r.revision_id = :revision_id
+      and i.item_id = r.item_id
+      and ((r.content is not null and i.storage_type in ('text','file')) or
+      (r.lob is not null and i.storage_type = 'lob'))
+    </querytext>
+  </fullquery>
+</queryset>