Index: openacs-4/packages/glossary/www/illustration-bits-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/glossary/www/Attic/illustration-bits-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/glossary/www/illustration-bits-postgresql.xql	25 Oct 2001 01:52:19 -0000	1.1
+++ openacs-4/packages/glossary/www/illustration-bits-postgresql.xql	27 Oct 2001 00:11:04 -0000	1.2
@@ -5,10 +5,12 @@
 
 <fullquery name="output_illustration">      
       <querytext>
-      FIX ME LOB
-select content
-from cr_revisions
-where revision_id = :revision_id
+
+	select r.lob as content, i.storage_type
+        from   cr_revisions r, cr_items i
+	where r.item_id = i.item_id
+	and   r.revision_id = :revision_id
+
       </querytext>
 </fullquery>