From a918234e914c4d1e3e240d241cedbeb330d7d25a Mon Sep 17 00:00:00 2001 From: paca70 Date: Mon, 5 May 2003 16:13:45 +0000 Subject: [PATCH] Postgres limit fix --- lib/datalib.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/datalib.php b/lib/datalib.php index f62cd38d9c..e18c27f1c3 100644 --- a/lib/datalib.php +++ b/lib/datalib.php @@ -961,7 +961,7 @@ function get_users_listing($sort, $dir="ASC", $page=1, $recordsperpage=20, $sear $limit = "LIMIT $page,$recordsperpage"; break; case "postgres7": - $limit = "LIMIT $recordsperpage OFFSET ".($page * $recordsperpage); + $limit = "LIMIT $recordsperpage OFFSET ".($page); break; default: $limit = "LIMIT $recordsperpage,$page"; -- 2.39.5