Function SetOffset

pkg/transform/limit.go:51–63

SetOffset returns a Rule that sets (or replaces) the OFFSET clause of a SELECT statement. Use together with SetLimit to implement pagination. Parameters: - n: Number of rows to skip; must be >= 0. Returns an error for negative values. Returns ErrUnsupportedStatement for non-SELECT statements.

(n int)

//
// Returns ErrUnsupportedStatement for non-SELECT statements.
func SetOffset(n int) Rule {
	return RuleFunc(func(stmt ast.Statement) error {
		if n < 0 {
			return fmt.Errorf("SetOffset: value must be non-negative, got %d", n)
		}
		sel, err := getSelect(stmt, "SetOffset")
		if err != nil {
			return err
		}
		sel.Offset = &n
		return nil
	})
}

// RemoveLimit returns a Rule that removes the LIMIT clause from a SELECT statement,
// allowing the query to return an unbounded number of rows.