summaryrefslogtreecommitdiffstats
path: root/sql
diff options
context:
space:
mode:
authorAlexander Sulfrian <alexander@sulfrian.net>2011-12-08 13:46:11 +0100
committerAlexander Sulfrian <alexander@sulfrian.net>2011-12-08 13:46:11 +0100
commit0787aec18d9b879791c5d6f9d75209d242aba708 (patch)
tree557d951dc4a48f68b153ea4c7a080bb969df5778 /sql
parent560cf50d38188093f31f39cb0f90eebbd4cbfb14 (diff)
downloadts3db_postgres-0787aec18d9b879791c5d6f9d75209d242aba708.tar.gz
ts3db_postgres-0787aec18d9b879791c5d6f9d75209d242aba708.tar.xz
ts3db_postgres-0787aec18d9b879791c5d6f9d75209d242aba708.zip
limit #,# is not supported by postgres
instead of limit #,# use limit with offset
Diffstat (limited to 'sql')
-rw-r--r--sql/client_get_by_serverid_limit.sql2
1 files changed, 1 insertions, 1 deletions
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:;