PostgrestFilterBuilder | /mod.ts | postgrest@1.1.0

class PostgrestFilterBuilder

Re-export

import { PostgrestFilterBuilder } from "https://deno.land/x/postgrest@1.1.0/mod.ts";

Type Parameters

Properties

deprecated

adj

deprecated

nxl

deprecated

nxr

deprecated

Methods

containedBy(column: keyof T, value: string | T[keyof T][] | object): this

Finds all rows whose json, array, or range value on the stated column is contained by the specified value.

contains(column: keyof T, value: string | T[keyof T][] | object): this

Finds all rows whose json, array, or range value on the stated column contains the values specified in value.

eq(column: keyof T, value: T[keyof T]): this

Finds all rows whose value on the stated column exactly matches the specified value.

filter(

column: keyof T,

operator: FilterOperator,

value: any,

): this

Finds all rows whose column satisfies the filter.

deprecated

fts(

column: keyof T,

query: string,

unnamed 2?: { config?: string; },

): this

Finds all rows whose tsvector value on the stated column matches to_tsquery(query).

gt(column: keyof T, value: T[keyof T]): this

Finds all rows whose value on the stated column is greater than the specified value.

gte(column: keyof T, value: T[keyof T]): this

Finds all rows whose value on the stated column is greater than or equal to the specified value.

ilike(column: keyof T, pattern: string): this

Finds all rows whose value in the stated column matches the supplied pattern (case insensitive).

in(column: keyof T, values: T[keyof T][]): this

Finds all rows whose value on the stated column is found on the specified values.

is(column: keyof T, value: boolean | null): this

A check for exact equality (null, true, false), finds all rows whose value on the stated column exactly match the specified value.

like(column: keyof T, pattern: string): this

Finds all rows whose value in the stated column matches the supplied pattern (case sensitive).

lt(column: keyof T, value: T[keyof T]): this

Finds all rows whose value on the stated column is less than the specified value.

lte(column: keyof T, value: T[keyof T]): this

Finds all rows whose value on the stated column is less than or equal to the specified value.

match(query: Record<string, unknown>): this

Finds all rows whose columns match the specified query object.

neq(column: keyof T, value: T[keyof T]): this

Finds all rows whose value on the stated column doesn't match the specified value.

not(

column: keyof T,

operator: FilterOperator,

value: any,

): this

Finds all rows which doesn't satisfy the filter.

or(filters: string, unnamed 1?: { foreignTable?: string; }): this

Finds all rows satisfying at least one of the filters.

overlaps(column: keyof T, value: string | T[keyof T][]): this

Finds all rows whose array or range value on the stated column overlaps (has a value in common) with the specified value.

deprecated

phfts(

column: keyof T,

query: string,

unnamed 2?: { config?: string; },

): this

Finds all rows whose tsvector value on the stated column matches phraseto_tsquery(query).

deprecated

plfts(

column: keyof T,

query: string,

unnamed 2?: { config?: string; },

): this

Finds all rows whose tsvector value on the stated column matches plainto_tsquery(query).

rangeAdjacent(column: keyof T, range: string): this

Finds all rows whose range value on the stated column is adjacent to the specified range.

rangeGt(column: keyof T, range: string): this

Finds all rows whose range value on the stated column is strictly to the right of the specified range.

rangeGte(column: keyof T, range: string): this

Finds all rows whose range value on the stated column does not extend to the left of the specified range.

rangeLt(column: keyof T, range: string): this

Finds all rows whose range value on the stated column is strictly to the left of the specified range.

rangeLte(column: keyof T, range: string): this

Finds all rows whose range value on the stated column does not extend to the right of the specified range.

textSearch(

column: keyof T,

query: string,

unnamed 2?: { config?: string; type?:

| "plain"

| "phrase"

| "websearch"

| null

; },

): this

Finds all rows whose text or tsvector value on the stated column matches the tsquery in query.

deprecated

wfts(

column: keyof T,

query: string,

unnamed 2?: { config?: string; },

): this

Finds all rows whose tsvector value on the stated column matches websearch_to_tsquery(query).