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_type_name(&self, ty: ScalarFieldType) -> Option<&'static str>

SQL type name this dialect casts a JSON-extracted value to for ty, or None when the raw text extraction is already the right type.

fn cast_expr_as<'a>(&self, expr: &'a str, ty: ScalarFieldType) -> Cow<'a, str>

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

fn cast_param_as<'a>( &self, placeholder: &'a str, ty: ScalarFieldType, ) -> Cow<'a, str>

Wrap a parameter placeholder so it is compared as ty.

fn cast_native_param(&self, placeholder: &str, native_type: &str) -> String

Wrap a parameter placeholder for a native-column equality condition.

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 fts_rank_sql( &self, document_expr: &str, query_param: &str, ) -> Result<String, UnsupportedOperator>

SQL for the full-text relevance of a document against a web-search query — the ordering half of ?search= (#1284).

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

SQL for POSIX-style regex match.

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, IsNotLoopback).

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 ltree_id_subquery_sql( &self, pg_op: &str, field_expr: &str, table: &str, path_column: &str, fk_column: Option<&str>, param: &str, ) -> Result<String, UnsupportedOperator>

Generate SQL for ID-based ltree operators (descendantOfId, ancestorOfId).

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 like_escape_clause(&self) -> &'static str

Trailing ESCAPE clause required to make escape_like_literal’s backslash escaping effective on this dialect, or "" when the dialect already treats \ as the escape character.

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.