More elegant way to compare enum in postgres?

[phungleson]

Basically I have enum type = 'TYPE_A' and 'TYPE_B' I would like to query all records where record.type = 'TYPE_A'

This throw error operator does not exist: type = text

.and_where(Expr::col(X::Type).eq(type_.clone()))

This doesn't work as SimpleExpr is not Into<Value>

.and_where(
            Expr::col(X::Type).eq(Func::cast_as(type_.clone(), Alias::new(TYPE)))
)

Only this work.

.and_where(
            Func::cast_as(type_.clone(), Alias::new(TYPE))
                .equals(Expr::col(X::Type)),
)

I wonder if we should make second case Expr::col(X::Type).eq(Func::cast_as(type_.clone(), Alias::new(TYPE))) work?

[billy1624]

Hey @phungleson, you can do it with as_enum method

• https://docs.rs/sea-query/0.20.0/sea_query/expr/struct.Expr.html#method.as_enum

let query = Query::select()
    .expr(Expr::col(Char::FontSize).as_enum(Alias::new("text")))
    .from(Char::Table)
    .to_owned();

assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"SELECT CAST("font_size" AS text) FROM "character""#
);

let query = Query::insert()
    .into_table(Char::Table)
    .columns(vec![Char::FontSize])
    .exprs_panic(vec![Expr::val("large").as_enum(Alias::new("FontSizeEnum"))])
    .to_owned();

assert_eq!(
    query.to_string(PostgresQueryBuilder),
    r#"INSERT INTO "character" ("font_size") VALUES (CAST('large' AS FontSizeEnum))"#
);