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
| Name | Type | Required | Description |
|---|---|---|---|
column | String / Symbol | Required | Column name. |
value | Any | Required | Value 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)
.executeExample — timestamp comparison
supabase
.from("orders")
.select("*")
.gt("created_at", "2026-01-01T00:00:00Z")
.execute