Index: openacs-4/packages/lorsm/www/admin/reorder-items-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lorsm/www/admin/reorder-items-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/lorsm/www/admin/reorder-items-postgresql.xql	9 Apr 2007 21:16:04 -0000	1.2
+++ openacs-4/packages/lorsm/www/admin/reorder-items-postgresql.xql	12 Dec 2008 14:25:36 -0000	1.3
@@ -2,16 +2,26 @@
 <queryset>
    <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
-<fullquery name="get_next_sort_order">
-<querytext>
-select sort_order from ims_cp_items where parent_item=:parent_item and sort_order > :sort_order order by sort_order limit 1
-</querytext>
-</fullquery>
+    <fullquery name="get_next_sort_order">
+        <querytext>
+            select sort_order
+            from ims_cp_items
+            where parent_item=:parent_item
+                and sort_order > :sort_order
+            order by sort_order
+            limit 1
+        </querytext>
+    </fullquery>
 
-<fullquery name="get_prev_sort_order">
-<querytext>
-select sort_order from ims_cp_items where parent_item=:parent_item and sort_order < :sort_order order by sort_order desc limit 1
-</querytext>
-</fullquery>
+    <fullquery name="get_prev_sort_order">
+        <querytext>
+            select sort_order
+            from ims_cp_items
+            where parent_item=:parent_item
+                and sort_order < :sort_order
+            order by sort_order desc
+            limit 1
+        </querytext>
+    </fullquery>
 
-</queryset>
\ No newline at end of file
+</queryset>