supabase-rb-rb
Database

Column is greater than a value

Match rows where a column is greater than a value.

Filter rows where column > value. Chains onto any verb builder.

Signature

builder.gt(column, value)

Parameters

NameTypeRequiredDescription
columnString / SymbolRequiredColumn name.
valueAnyRequiredValue to compare against. Works with numbers, dates, timestamps — PostgREST passes the comparison through to PostgreSQL.

Returns

Returns
self (FilterRequestBuilder)

The same builder for chaining.

Example — numeric comparison

supabase
  .from("countries")
  .select("name, population")
  .gt("population", 50_000_000)
  .execute

Example — timestamp comparison

supabase
  .from("orders")
  .select("*")
  .gt("created_at", "2026-01-01T00:00:00Z")
  .execute

On this page