Database
Column is a value
Match rows where a column IS null / true / false.
Filter rows using SQL's IS operator — the only correct way to test for NULL. The method is named is_ (trailing underscore) because is is a reserved word in Ruby's parser.
Signature
builder.is_(column, value)Parameters
| Name | Type | Required | Description |
|---|---|---|---|
column | String / Symbol | Required | Column name. |
value | nil / true / false / String | Required | Pass nil to test IS NULL (rewritten to the literal string "null" on the wire). true / false test IS TRUE / IS FALSE. A string is passed through verbatim. |
Returns
Returns
self (FilterRequestBuilder)
The same builder for chaining.
Example — find rows where a column is NULL
supabase
.from("users")
.select("id, email, deleted_at")
.is_("deleted_at", nil)
.execute
# => active (non-soft-deleted) usersExample — boolean column
supabase
.from("subscriptions")
.select("user_id, plan")
.is_("active", true)
.executeWhy `is_` and not `is`
is is a reserved word in Ruby's parser, so the method is is_. Internally, passing nil is rewritten to the literal string "null" so PostgREST receives column=is.null.