Python: Limit the query to a range

Limit the query result by starting at an offset (from) and ending at the offset (from + to). Only records within this range are returned. This respects the query order and if there is no order clause the range could behave unexpectedly.

The from and to values are 0-based and inclusive: range(1, 3) will include the second, third and fourth rows of the query.

Parameters

• start

  (Required)

  The starting index from which to limit the result.

• end

  (Required)

  The last index to which to limit the result.

• foreign_table

  (Optional)

  Set this to limit rows of foreign tables instead of the parent table.

Examples

With `select()`

response = supabase.table("countries").select("name").range(0, 1).execute()

On a foreign table

response = (
    supabase.table("countries")
    .select("name, cities(name)")
    .range(0, 1, foreign_table="cities")
    .execute()
)