Module expr 

PostgreSQL-specific expressions.

This module provides PostgreSQL dialect-specific SQL expressions and operators. For standard SQL expressions, use drizzle_core::expr.

Structs

PgArray

Wrapper for passing a Vec<T> as a single PostgreSQL array parameter.

Traits

ArrayExprExt

Extension trait providing method-based array operators for PostgreSQL expressions.

JsonExprExt

Extension trait providing method-based JSON operators for PostgreSQL expressions.

RegexExprExt

Extension trait providing method-based regex operators for PostgreSQL expressions.

Functions

array_contained

PostgreSQL <@ operator - array is contained by.

array_contains

PostgreSQL @> operator - array contains.

array_overlaps

PostgreSQL && operator - arrays overlap.

ilike

Case-insensitive LIKE pattern matching (PostgreSQL-specific)

json_get

PostgreSQL -> operator - get JSON object field by key, returns JSON.

json_get_idx

PostgreSQL -> operator with integer index - get JSON array element.

json_get_path

PostgreSQL #> operator - get JSON object at specified path, returns JSON.

json_get_path_text

PostgreSQL #>> operator - get JSON object at specified path as text.

json_get_text

PostgreSQL ->> operator - get JSON object field as text.

json_get_text_idx

PostgreSQL ->> operator with integer index - get JSON array element as text.

jsonb_contained

PostgreSQL <@ operator for JSONB - left JSON is contained by right JSON.

jsonb_contains

PostgreSQL @> operator for JSONB - left JSON contains right JSON.

jsonb_exists_all

PostgreSQL ?& operator for JSONB - do all of the keys exist?

jsonb_exists_any

PostgreSQL ?| operator for JSONB - do any of the keys exist?

jsonb_exists_key

PostgreSQL ? operator for JSONB - does the key exist in the JSON object?

not_ilike

Case-insensitive NOT LIKE pattern matching (PostgreSQL-specific)

regex_match

PostgreSQL ~ operator - case-sensitive regex match.

regex_match_ci

PostgreSQL ~* operator - case-insensitive regex match.

regex_not_match

PostgreSQL !~ operator - case-sensitive regex non-match.

regex_not_match_ci

PostgreSQL !~* operator - case-insensitive regex non-match.