From 0787aec18d9b879791c5d6f9d75209d242aba708 Mon Sep 17 00:00:00 2001
From: Alexander Sulfrian <alexander@sulfrian.net>
Date: Thu, 8 Dec 2011 13:46:11 +0100
Subject: limit #,# is not supported by postgres

instead of limit #,# use limit with offset
---
 sql/client_get_by_serverid_limit.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'sql/client_get_by_serverid_limit.sql')

diff --git a/sql/client_get_by_serverid_limit.sql b/sql/client_get_by_serverid_limit.sql
index a10d88d..d022e4f 100644
--- a/sql/client_get_by_serverid_limit.sql
+++ b/sql/client_get_by_serverid_limit.sql
@@ -1 +1 @@
-select * from clients where server_id=:server_id: limit :start:, :duration:;
\ No newline at end of file
+select * from clients where server_id=:server_id: limit :duration: offset :start:;
-- 
cgit v1.2.3

