The original docs state that "range" takes a starting index and ending index and returns the values between them. This implies that it's using the primary ID. But it actually works more like limit + offset.
What is the new behavior?
I've updated the docs to explain how it works in greater detail.
What kind of change does this PR introduce?
Docs update
What is the current behavior?
These updates are based on feedback in the Supabase repo's issue #15222 (https://github.com/supabase/supabase/issues/15222)
The original docs state that "range" takes a starting index and ending index and returns the values between them. This implies that it's using the primary ID. But it actually works more like limit + offset.
What is the new behavior?
I've updated the docs to explain how it works in greater detail.