From 468053b47d99808f6ad3f049368e3970b564bfd8 Mon Sep 17 00:00:00 2001
From: mh <mh>
Date: Sat, 28 Dec 2002 03:21:38 +0000
Subject: [PATCH] change sql LIMIT usage from LIMIT #,# to LIMIT # OFFSET #,
 this is makes us postgresql 7.3 compatible, I hope this works for 7.2 and
 below as well.

---
 source/mir/storage/Database.java | 10 ++--------
 1 file changed, 2 insertions(+), 8 deletions(-)

diff --git a/source/mir/storage/Database.java b/source/mir/storage/Database.java
index 20bd66df..4af17692 100755
--- a/source/mir/storage/Database.java
+++ b/source/mir/storage/Database.java
@@ -56,7 +56,7 @@ import  mir.util.*;
  * Treiber, Host, User und Passwort, ueber den der Zugriff auf die
  * Datenbank erfolgt.
  *
- * @version $Id: Database.java,v 1.29 2002/12/23 03:18:02 mh Exp $
+ * @version $Id: Database.java,v 1.30 2002/12/28 03:21:38 mh Exp $
  * @author rk
  *
  */
@@ -504,13 +504,7 @@ public class Database implements StorageObject {
     }
     if (theAdaptor.hasLimit()) {
       if (limit > -1 && offset > -1) {
-        selectSql.append(" limit ");
-        if (theAdaptor.reverseLimit()) {
-          selectSql.append(limit).append(",").append(offset);
-        }
-        else {
-          selectSql.append(offset).append(",").append(limit);
-        }
+        selectSql.append(" LIMIT ").append(limit).append(" OFFSET ").append(offset);
       }
     }
 
-- 
2.11.0