Index: openacs-4/packages/acs-content-repository/tcl/publish-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/tcl/publish-procs-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-content-repository/tcl/publish-procs-postgresql.xql	7 Aug 2017 23:47:47 -0000	1.2
+++ openacs-4/packages/acs-content-repository/tcl/publish-procs-postgresql.xql	3 Sep 2024 15:37:31 -0000	1.3
@@ -3,52 +3,52 @@
 <queryset>
    <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
-<fullquery name="publish::handle::text.get_revision_id">      
+<fullquery name="publish::handle::text.get_revision_id">
       <querytext>
 
         select 1
 
       </querytext>
 </fullquery>
 
-<fullquery name="publish::handle::text.get_previous_content">      
+<fullquery name="publish::handle::text.get_previous_content">
       <querytext>
 
-                       select 
+                       select
                          content
-                       from 
+                       from
                          cr_revisions
-                       where 
+                       where
                          revision_id = :revision_id
 
       </querytext>
 </fullquery>
 
-<fullquery name="publish::write_multiple_blobs.wmb_get_blob_file">      
+<fullquery name="publish::write_multiple_blobs.wmb_get_blob_file">
       <querytext>
 
-      select case when i.storage_type = 'file' 
+      select case when i.storage_type = 'file'
                        then '[cr_fs_path]' || r.content
                   when i.storage_type = 'lob'
-                       then lob::text 
-                       else r.content end 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
+                       then lob::text
+                       else r.content end 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>
 
-<fullquery name="publish::write_content.get_previous_content">      
+<fullquery name="publish::write_content.get_previous_content">
       <querytext>
-      
-    select 
+
+    select
       content
-    from 
+    from
       cr_revisions
-    where 
+    where
       revision_id = :revision_id
-  
+
       </querytext>
 </fullquery>
- 
+
 </queryset>