Swift: Don't match the filter

Finds all rows that don't satisfy the filter.

• .not() expects you to use the raw PostgREST syntax for the filter names and values.

  .not("name", operator: .eq, value: "Paris")
  .not("arraycol", operator: .cs, value: #"\{"a","b"\}"#) // Use Postgres array \{\} for array column and 'cs' for contains.
  .not("rangecol", operator: .cs, value: "(1,2]") // Use Postgres range syntax for range column.
  .not("id", operator: .in, value: "(6,7)")  // Use Postgres list () and 'in' for in_ filter.
  .not("id", operator: .in, value: "(\(mylist.join(separator: ",")))")  // You can insert a Swift list array.
  

Examples

With `select()`

try await supabase.database
  .from("countries")
  .select()
  .not("name", operator: .is, value: "")
  .execute()