Index: openacs-4/packages/acs-subsite/www/shared/portrait-bits-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/shared/Attic/portrait-bits-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/acs-subsite/www/shared/portrait-bits-postgresql.xql	6 May 2001 14:30:08 -0000	1.4
+++ openacs-4/packages/acs-subsite/www/shared/portrait-bits-postgresql.xql	12 May 2001 05:09:48 -0000	1.5
@@ -5,9 +5,10 @@
 <fullquery name="output_portrait">
         <querytext>
 
-        select lob, storage_type
-        from cr_revisions
-        where revision_id = :revision_id
+        select r.lob, 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>