From 0787aec18d9b879791c5d6f9d75209d242aba708 Mon Sep 17 00:00:00 2001 From: Alexander Sulfrian 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(-) 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