Paginator for the :many context?

[basilex]

Hi, All!
Is there a solution to paginate :many context?
Thanx a lot!

[videate-karim]

In my reading of the docs, you would do:

-- name: GetThings :many SELECT * FROM things WHERE field = $1 ORDER BY created_at desc LIMIT $2 OFFSET $3;

The generated function looks like this:

type GetThingsParams struct { Field string Limit int32 Offset int32 } type GetThingsRow struct { ID int32 Field string ... } func (q *Queries) GetThings(ctx context.Context, arg GetThingsParams) ([]GetThingRow, error) { ... }