Trait sea_query::extension::postgres::PgExpr

source · 
pub trait PgExpr: Expression {
    // Provided methods
    fn concatenate<T>(self, right: T) -> SimpleExpr
       where T: Into<SimpleExpr> { ... }
    fn concat<T>(self, right: T) -> SimpleExpr
       where T: Into<SimpleExpr> { ... }
    fn matches<T>(self, expr: T) -> SimpleExpr
       where T: Into<SimpleExpr> { ... }
    fn contains<T>(self, expr: T) -> SimpleExpr
       where T: Into<SimpleExpr> { ... }
    fn contained<T>(self, expr: T) -> SimpleExpr
       where T: Into<SimpleExpr> { ... }
    fn ilike<L>(self, like: L) -> SimpleExpr
       where L: IntoLikeExpr { ... }
    fn not_ilike<L>(self, like: L) -> SimpleExpr
       where L: IntoLikeExpr { ... }
    fn get_json_field<T>(self, right: T) -> SimpleExpr
       where T: Into<SimpleExpr> { ... }
    fn cast_json_field<T>(self, right: T) -> SimpleExpr
       where T: Into<SimpleExpr> { ... }
}
Available on crate feature backend-postgres only.

Provided Methods§

source

fn concatenate<T>(self, right: T) -> SimpleExpr
where T: Into<SimpleExpr>,

Express an postgres concatenate (||) expression.

Examples
use sea_query::{extension::postgres::PgExpr, tests_cfg::*, *};

let query = Query::select()
    .columns([Font::Name, Font::Variant, Font::Language])
    .from(Font::Table)
    .and_where(Expr::val("a").concatenate("b").concat("c").concat("d"))
    .to_owned();

assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"SELECT "name", "variant", "language" FROM "font" WHERE 'a' || 'b' || 'c' || 'd'"#
);
source

fn concat<T>(self, right: T) -> SimpleExpr
where T: Into<SimpleExpr>,

Alias of PgExpr::concatenate

source

fn matches<T>(self, expr: T) -> SimpleExpr
where T: Into<SimpleExpr>,

Express an postgres fulltext search matches (@@) expression.

Examples
use sea_query::{*, tests_cfg::*, extension::postgres::PgExpr};

let query = Query::select()
    .columns([Font::Name, Font::Variant, Font::Language])
    .from(Font::Table)
    .and_where(Expr::val("a & b").matches("a b"))
    .and_where(Expr::col(Font::Name).matches("a b"))
    .to_owned();

assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"SELECT "name", "variant", "language" FROM "font" WHERE 'a & b' @@ 'a b' AND "name" @@ 'a b'"#
);
source

fn contains<T>(self, expr: T) -> SimpleExpr
where T: Into<SimpleExpr>,

Express an postgres fulltext search contains (@>) expression.

Examples
use sea_query::{*, tests_cfg::*, extension::postgres::PgExpr};

let query = Query::select()
    .columns([Font::Name, Font::Variant, Font::Language])
    .from(Font::Table)
    .and_where(Expr::val("a & b").contains("a b"))
    .and_where(Expr::col(Font::Name).contains("a b"))
    .to_owned();

assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"SELECT "name", "variant", "language" FROM "font" WHERE 'a & b' @> 'a b' AND "name" @> 'a b'"#
);
source

fn contained<T>(self, expr: T) -> SimpleExpr
where T: Into<SimpleExpr>,

Express an postgres fulltext search contained (<@) expression.

Examples
use sea_query::{*, tests_cfg::*, extension::postgres::PgExpr};

let query = Query::select()
    .columns([Font::Name, Font::Variant, Font::Language])
    .from(Font::Table)
    .and_where(Expr::val("a & b").contained("a b"))
    .and_where(Expr::col(Font::Name).contained("a b"))
    .to_owned();

assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"SELECT "name", "variant", "language" FROM "font" WHERE 'a & b' <@ 'a b' AND "name" <@ 'a b'"#
);
source

fn ilike<L>(self, like: L) -> SimpleExpr
where L: IntoLikeExpr,

Express a ILIKE expression.

Examples
use sea_query::{*, tests_cfg::*, extension::postgres::PgExpr};

let query = Query::select()
    .columns([Char::Character, Char::SizeW, Char::SizeH])
    .from(Char::Table)
    .and_where(Expr::col((Char::Table, Char::Character)).ilike("Ours'%"))
    .to_owned();

assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"SELECT "character", "size_w", "size_h" FROM "character" WHERE "character"."character" ILIKE E'Ours\'%'"#
);
source

fn not_ilike<L>(self, like: L) -> SimpleExpr
where L: IntoLikeExpr,

Express a NOT ILIKE expression

source

fn get_json_field<T>(self, right: T) -> SimpleExpr
where T: Into<SimpleExpr>,

Express a postgres retrieves JSON field as JSON value (->).

Examples
use sea_query::{extension::postgres::PgExpr, tests_cfg::*, *};

let query = Query::select()
    .column(Font::Variant)
    .from(Font::Table)
    .and_where(Expr::col(Font::Variant).get_json_field("a"))
    .to_owned();

assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"SELECT "variant" FROM "font" WHERE "variant" -> 'a'"#
);
source

fn cast_json_field<T>(self, right: T) -> SimpleExpr
where T: Into<SimpleExpr>,

Express a postgres retrieves JSON field and casts it to an appropriate SQL type (->>).

Examples
use sea_query::{extension::postgres::PgExpr, tests_cfg::*, *};

let query = Query::select()
    .column(Font::Variant)
    .from(Font::Table)
    .and_where(Expr::col(Font::Variant).cast_json_field("a"))
    .to_owned();

assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"SELECT "variant" FROM "font" WHERE "variant" ->> 'a'"#
);

Object Safety§

This trait is not object safe.

Implementors§