Revision 8329
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/util.sql | ||
|---|---|---|
| 848 | 848 |
RETURNS SETOF $$||view_||$$ AS |
| 849 | 849 |
$BODY1$ |
| 850 | 850 |
SELECT * FROM $$||util.type_qual_name(view_::text::regtype)||$$ |
| 851 |
WHERE $$||quote_ident(row_num_col)||$$ BETWEEN COALESCE($2, 0) AND COALESCE($2+$1, 2147483647)
|
|
| 851 |
WHERE $$||quote_ident(row_num_col)||$$ BETWEEN COALESCE($2, 0) AND COALESCE(COALESCE($2, 0)+$1, 2147483647)
|
|
| 852 | 852 |
$BODY1$ |
| 853 | 853 |
LANGUAGE sql STABLE |
| 854 | 854 |
COST 100 |
Also available in: Unified diff
schemas/util.sql: mk_subset_by_row_num_func(): regular subset function: Fixed bug where also need to COALESCE offset_ to 0 when it's added to the limit_