Index: openacs-4/packages/categories/www/categories-browse-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/www/categories-browse-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/categories/www/categories-browse-postgresql.xql	7 May 2003 13:35:06 -0000	1.2
+++ openacs-4/packages/categories/www/categories-browse-postgresql.xql	19 May 2003 13:10:32 -0000	1.3
@@ -5,25 +5,23 @@
 
   <fullquery name="get_categorized_objects">
     <querytext>
-      select r.*
-      from (select n.object_id, n.object_name as object_name, o.creation_date,
-                   t.pretty_name as package_type, n.package_id, p.instance_name,
-                   row_number() over ($order_by_clause) as row_number
-            from acs_objects o, acs_named_objects n, apm_packages p, apm_package_types t,
-                 ($subtree_sql) s
-            where n.object_id = s.object_id
-            and o.object_id = n.object_id
-            and p.package_id = n.package_id
-            and t.package_key = p.package_key
-            and exists (select 1
-                        from acs_object_party_privilege_map oppm
-                        where oppm.object_id = n.object_id
+      select n.object_id, n.object_name as object_name, o.creation_date,
+                   t.pretty_name as package_type, n.package_id, p.instance_name
+        from acs_objects o, acs_named_objects n, apm_packages p, apm_package_types t,
+             ($subtree_sql) s
+       where n.object_id = s.object_id
+         and o.object_id = n.object_id
+         and p.package_id = n.package_id
+         and t.package_key = p.package_key
+         and exists (select 1
+                       from acs_object_party_privilege_map oppm
+                      where oppm.object_id = n.object_id
                         and oppm.party_id = :user_id
                         and oppm.privilege = 'read')
-            $letter_sql
-            $package_sql
-            $order_by_clause) r
-      where r.row_number between :first_row and :last_row
+             $letter_sql
+             $package_sql
+             $order_by_clause
+       limit $last_row offset $first_row
     </querytext>
   </fullquery>