Revision 10991
Added by Aaron Marcuse-Kubitza about 11 years ago
| schemas/util.sql | ||
|---|---|---|
| 1409 | 1409 |
WHERE $$||quote_ident(row_num_col)||$$ BETWEEN |
| 1410 | 1410 |
util.offset2row_num( $2, $$||row_num__min__fn||$$()) |
| 1411 | 1411 |
AND util.limit2row_num ($1, $2, $$||row_num__min__fn||$$()) |
| 1412 |
ORDER BY $$||quote_ident(row_num_col)||$$ |
|
| 1412 | 1413 |
$BODY1$ |
| 1413 | 1414 |
LANGUAGE sql STABLE |
| 1414 | 1415 |
COST 100 |
Also available in: Unified diff
bugfix: schemas/util.sql: mk_subset_by_row_num_func(): need explicit ORDER BY on the row_num_col, to prevent PostgreSQL from sorting the rows in reverse (they will be sorted because of the index scan, but the direction is otherwise indeterminate)