Python: Limit the query to a range

Limit the query result by starting at an offset (start) and ending at the offset (end). 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 start and end 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()
)