diff options
| author | Alexander Sulfrian <alexander@sulfrian.net> | 2011-12-08 13:46:11 +0100 |
|---|---|---|
| committer | Alexander Sulfrian <alexander@sulfrian.net> | 2011-12-08 13:46:11 +0100 |
| commit | 0787aec18d9b879791c5d6f9d75209d242aba708 (patch) | |
| tree | 557d951dc4a48f68b153ea4c7a080bb969df5778 | |
| parent | 560cf50d38188093f31f39cb0f90eebbd4cbfb14 (diff) | |
| download | ts3db_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
| -rw-r--r-- | sql/client_get_by_serverid_limit.sql | 2 |
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:; |