Struct PostgresDialect 

pub struct PostgresDialect;

PostgreSQL dialect for GenericWhereGenerator.

Trait Implementations

impl SqlDialect for PostgresDialect

fn name(&self) -> &'static str

Dialect name for error messages (e.g., "PostgreSQL", "MySQL").

fn quote_identifier(&self, name: &str) -> String

Quote a database identifier (table or column name).

fn json_extract_scalar(&self, column: &str, path: &[String]) -> String

Generate SQL to extract a scalar string from a JSON/JSONB column.

fn placeholder(&self, n: usize) -> String

Next parameter placeholder. Called with the current 1-based index.

fn cast_to_numeric<'a>(&self, expr: &'a str) -> Cow<'a, str>

Wrap a JSON-extracted scalar expression so it compares numerically.

fn cast_to_boolean<'a>(&self, expr: &'a str) -> Cow<'a, str>

Wrap a JSON-extracted scalar expression so it compares as a boolean.

fn cast_param_numeric<'a>(&self, placeholder: &'a str) -> Cow<'a, str>

Wrap a parameter placeholder for numeric comparison.

fn ilike_sql(&self, lhs: &str, rhs: &str) -> String

SQL fragment for case-insensitive LIKE.

fn json_array_length(&self, expr: &str) -> String

SQL expression for the length of a JSON array stored in expr.

fn array_contains_sql( &self, lhs: &str, rhs: &str, ) -> Result<String, UnsupportedOperator>

SQL for “array contains this element”.

fn array_contained_by_sql( &self, lhs: &str, rhs: &str, ) -> Result<String, UnsupportedOperator>

SQL for “element is contained by array”.

fn array_overlaps_sql( &self, lhs: &str, rhs: &str, ) -> Result<String, UnsupportedOperator>

SQL for “arrays overlap”.

fn fts_matches_sql( &self, expr: &str, param: &str, ) -> Result<String, UnsupportedOperator>

SQL for to_tsvector(expr) @@ to_tsquery(param).

fn fts_plain_query_sql( &self, expr: &str, param: &str, ) -> Result<String, UnsupportedOperator>

SQL for plain-text full-text search.

fn fts_phrase_query_sql( &self, expr: &str, param: &str, ) -> Result<String, UnsupportedOperator>

SQL for phrase full-text search.

fn fts_websearch_query_sql( &self, expr: &str, param: &str, ) -> Result<String, UnsupportedOperator>

SQL for web-search full-text search.

fn regex_sql( &self, lhs: &str, rhs: &str, case_insensitive: bool, negate: bool, ) -> Result<String, UnsupportedOperator>

SQL for POSIX-style regex match.

fn vector_distance_sql( &self, pg_op: &str, lhs: &str, rhs: &str, ) -> Result<String, UnsupportedOperator>

Generate SQL for a pgvector distance operator.

fn jaccard_distance_sql( &self, lhs: &str, rhs: &str, ) -> Result<String, UnsupportedOperator>

Generate SQL for Jaccard distance (::text[] <%> ::text[]).

fn inet_check_sql( &self, lhs: &str, check_name: &str, ) -> Result<String, UnsupportedOperator>

Generate SQL for an INET unary check (IsIPv4, IsIPv6, IsPrivate, IsPublic, IsLoopback).

fn inet_binary_sql( &self, pg_op: &str, lhs: &str, rhs: &str, ) -> Result<String, UnsupportedOperator>

Generate SQL for an INET binary operation (InSubnet, ContainsSubnet, ContainsIP, Overlaps).

fn ltree_binary_sql( &self, pg_op: &str, lhs: &str, rhs: &str, rhs_type: &str, ) -> Result<String, UnsupportedOperator>

Generate SQL for an LTree binary operator.

fn ltree_any_lquery_sql( &self, lhs: &str, placeholders: &[String], ) -> Result<String, UnsupportedOperator>

Generate SQL for ltree ? ARRAY[...] (MatchesAnyLquery).

fn ltree_depth_sql( &self, op: &str, lhs: &str, rhs: &str, ) -> Result<String, UnsupportedOperator>

Generate SQL for nlevel(ltree) OP param (depth comparison operators).

fn ltree_lca_sql( &self, lhs: &str, placeholders: &[String], ) -> Result<String, UnsupportedOperator>

Generate SQL for ltree = lca(ARRAY[...]) (Lca operator).

fn row_view_column_expr( &self, json_column: &str, field_name: &str, col_type: &RowViewColumnType, ) -> String

Generate a SQL expression that extracts a scalar field from a JSON column and casts it to the given RowViewColumnType.

fn generate_extended_sql( &self, operator: &ExtendedOperator, field_sql: &str, params: &mut Vec<Value>, ) -> Result<String>

Generate SQL for an extended rich-type operator.

fn like_sql(&self, lhs: &str, rhs: &str) -> String

SQL fragment for case-sensitive LIKE: lhs LIKE rhs.

fn concat_sql(&self, parts: &[&str]) -> String

String concatenation operator / function for building LIKE patterns.

fn always_false(&self) -> &'static str

SQL literal for “always false” (used for empty IN clauses, empty OR).

fn always_true(&self) -> &'static str

SQL literal for “always true” (used for empty AND).

fn neq_operator(&self) -> &'static str

SQL inequality operator. Default !=. SQL Server uses <>.

fn create_row_view_ddl( &self, view_name: &str, source_table: &str, columns: &[(String, String)], ) -> String

Generate the full DDL statement(s) to create a row-shaped view.