- changed status to resolved
problem with pagination in postgres
Issue #200
resolved
function TAnsiSQLGenerator.GeneratePagedQuery generate incorect sql syntax for postgres database
In postgres need use contruction LIMIT and OFFSET
perhaps should override function GeneratePagedQuery in class TPostgreSQLGenerator with code
function TPostgreSQLGenerator.GeneratePagedQuery(const sql: string; limit,
offset: Integer): string;
var
SqlStatement: string;
begin
SqlStatement := sql;
if EndsStr(';', SqlStatement) then
SetLength(SqlStatement, Length(SqlStatement) - 1);
if offset > 0 then
SqlStatement := SqlStatement + Format(' OFFSET %d', [offset]);
Result := SqlStatement + Format(' LIMIT %d%s',
[limit, GetSplitStatementSymbol]);
end;
Comments (4)
-
repo owner -
repo owner fixed issue
#200(generate correct statement for paged query for postgresql)→ <<cset c20ecc79655c>>
-
repo owner fixed issue
#200(generate correct statement for paged query for postgresql)→ <<cset ac3a39c2ae1f>>
-
repo owner fixed issue
#200(generate correct statement for paged query for postgresql)→ <<cset 1541ceeb56ab>>
- Log in to comment
fixed issue
#200(generate correct statement for paged query for postgresql)→ <<cset 5e1e3324c028>>