Enum PostgresValue 

pub enum PostgresValue<'a> {
    Smallint(i16),
    Integer(i32),
    Bigint(i64),
    Real(f32),
    DoublePrecision(f64),
    Text(Cow<'a, str>),
    Bytea(Cow<'a, [u8]>),
    Boolean(bool),
    Enum(Box<dyn PostgresEnum>),
    Array(Vec<Self>),
    Null,
}

Represents a PostgreSQL value.

This enum provides type-safe value handling for PostgreSQL operations.

Examples

use drizzle_postgres::values::PostgresValue;

// Integer conversion
let int_val: PostgresValue<'_> = 42i32.into();
assert!(matches!(int_val, PostgresValue::Integer(42)));

// String conversion
let str_val: PostgresValue<'_> = "hello".into();
assert!(matches!(str_val, PostgresValue::Text(_)));

// Boolean conversion
let bool_val: PostgresValue<'_> = true.into();
assert!(matches!(bool_val, PostgresValue::Boolean(true)));

Variants

Smallint(i16)

SMALLINT values (16-bit signed integer)

Integer(i32)

INTEGER values (32-bit signed integer)

Bigint(i64)

BIGINT values (64-bit signed integer)

Real(f32)

REAL values (32-bit floating point)

DoublePrecision(f64)

DOUBLE PRECISION values (64-bit floating point)

Text(Cow<'a, str>)

TEXT, VARCHAR, CHAR values

Bytea(Cow<'a, [u8]>)

BYTEA values (binary data)

Boolean(bool)

BOOLEAN values

Enum(Box<dyn PostgresEnum>)

Native PostgreSQL ENUM values

Array(Vec<Self>)

Array of any PostgreSQL type

Null

NULL value

Implementations

impl PostgresValue<'_>

pub const fn is_null(&self) -> bool

Returns true if this value is NULL.

pub const fn as_bool(&self) -> Option<bool>

Returns the boolean value if this is BOOLEAN.

pub const fn as_i16(&self) -> Option<i16>

Returns the i16 value if this is SMALLINT.

pub const fn as_i32(&self) -> Option<i32>

Returns the i32 value if this is INTEGER.

pub const fn as_i64(&self) -> Option<i64>

Returns the i64 value if this is BIGINT.

pub const fn as_f32(&self) -> Option<f32>

Returns the f32 value if this is REAL.

pub const fn as_f64(&self) -> Option<f64>

Returns the f64 value if this is DOUBLE PRECISION.

pub fn as_str(&self) -> Option<&str>

Returns the text value if this is TEXT.

pub fn as_bytes(&self) -> Option<&[u8]>

Returns the bytea value if this is BYTEA.

pub fn as_enum(&self) -> Option<&dyn PostgresEnum>

Returns the enum value if this is a PostgreSQL enum.

pub fn as_array(&self) -> Option<&[Self]>

Returns the array elements if this is an ARRAY.

pub fn into_owned(self) -> OwnedPostgresValue

Converts this value into an owned representation.

pub fn convert<T: FromPostgresValue>(self) -> Result<T, DrizzleError>

Convert this PostgreSQL value to a Rust type using the FromPostgresValue trait.

Errors

Returns DrizzleError::ConversionError when the stored variant’s native type does not match the target type T.

pub fn convert_ref<T: FromPostgresValue>(&self) -> Result<T, DrizzleError>

Convert a reference to this PostgreSQL value to a Rust type.

Errors

Returns DrizzleError::ConversionError when the stored variant’s native type does not match the target type T.

Trait Implementations

impl<'a> Clone for PostgresValue<'a>

fn clone(&self) -> PostgresValue<'a>

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl<'a> Debug for PostgresValue<'a>

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl<'a> Default for PostgresValue<'a>

fn default() -> PostgresValue<'a>

Returns the “default value” for a type.

impl Display for PostgresValue<'_>

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl<'a, S, State, T, M, R, G> Expr<'a, PostgresValue<'a>> for SelectBuilder<'a, S, State, T, M, R, G>

where State: ExecutableState, M: SubqueryType<'a, PostgresValue<'a>>,

type SQLType = <M as SubqueryType<'a, PostgresValue<'a>>>::SQLType

The SQL data type this expression evaluates to.

type Nullable = Null

Whether this expression can be NULL.

type Aggregate = Scalar

Whether this is an aggregate (COUNT, SUM) or scalar expression.

fn to_expr_sql(&self) -> SQL<'a, V>

Render this value as a scalar expression by reference.

fn into_expr_sql(self) -> SQL<'a, V>

where Self: Sized,

Render this value as a scalar expression, consuming it when useful.

impl<'a> From<&'a Arc<String>> for PostgresValue<'a>

fn from(value: &'a Arc<String>) -> Self

Converts to this type from the input type.

impl<'a> From<&'a Arc<Vec<u8>>> for PostgresValue<'a>

fn from(value: &'a Arc<Vec<u8>>) -> Self

Converts to this type from the input type.

impl<'a> From<&'a Arc<str>> for PostgresValue<'a>

fn from(value: &'a Arc<str>) -> Self

Converts to this type from the input type.

impl<'a> From<&'a Box<String>> for PostgresValue<'a>

fn from(value: &'a Box<String>) -> Self

Converts to this type from the input type.

impl<'a> From<&'a Box<Vec<u8>>> for PostgresValue<'a>

fn from(value: &'a Box<Vec<u8>>) -> Self

Converts to this type from the input type.

impl<'a> From<&'a Box<str>> for PostgresValue<'a>

fn from(value: &'a Box<str>) -> Self

Converts to this type from the input type.

impl<'a> From<&'a OwnedPostgresValue> for PostgresValue<'a>

fn from(value: &'a OwnedPostgresValue) -> Self

Converts to this type from the input type.

impl<'a> From<&'a PostgresValue<'a>> for Cow<'a, PostgresValue<'a>>

fn from(value: &'a PostgresValue<'a>) -> Self

Converts to this type from the input type.

impl<'a> From<&'a Rc<String>> for PostgresValue<'a>

fn from(value: &'a Rc<String>) -> Self

Converts to this type from the input type.

impl<'a> From<&'a Rc<Vec<u8>>> for PostgresValue<'a>

fn from(value: &'a Rc<Vec<u8>>) -> Self

Converts to this type from the input type.

impl<'a> From<&'a Rc<str>> for PostgresValue<'a>

fn from(value: &'a Rc<str>) -> Self

Converts to this type from the input type.

impl<'a> From<&'a String> for PostgresValue<'a>

fn from(value: &'a String) -> Self

Converts to this type from the input type.

impl<'a> From<&'a [PostgresValue<'a>]> for PostgresValue<'a>

fn from(value: &'a [Self]) -> Self

Converts to this type from the input type.

impl<'a> From<&'a [u8]> for PostgresValue<'a>

fn from(value: &'a [u8]) -> Self

Converts to this type from the input type.

impl<'a> From<&'a bool> for PostgresValue<'a>

fn from(value: &'a bool) -> Self

Converts to this type from the input type.

impl<'a> From<&'a f32> for PostgresValue<'a>

fn from(value: &'a f32) -> Self

Converts to this type from the input type.

impl<'a> From<&'a f64> for PostgresValue<'a>

fn from(value: &'a f64) -> Self

Converts to this type from the input type.

impl<'a> From<&'a i8> for PostgresValue<'a>

fn from(value: &'a i8) -> Self

Converts to this type from the input type.

impl<'a> From<&'a i16> for PostgresValue<'a>

fn from(value: &'a i16) -> Self

Converts to this type from the input type.

impl<'a> From<&'a i32> for PostgresValue<'a>

fn from(value: &'a i32) -> Self

Converts to this type from the input type.

impl<'a> From<&'a i64> for PostgresValue<'a>

fn from(value: &'a i64) -> Self

Converts to this type from the input type.

impl<'a> From<&'a isize> for PostgresValue<'a>

fn from(value: &'a isize) -> Self

Converts to this type from the input type.

impl<'a> From<&'a str> for PostgresValue<'a>

fn from(value: &'a str) -> Self

Converts to this type from the input type.

impl<'a> From<&'a u8> for PostgresValue<'a>

fn from(value: &'a u8) -> Self

Converts to this type from the input type.

impl<'a> From<&'a u16> for PostgresValue<'a>

fn from(value: &'a u16) -> Self

Converts to this type from the input type.

impl<'a> From<&'a u32> for PostgresValue<'a>

fn from(value: &'a u32) -> Self

Converts to this type from the input type.

impl<'a> From<&'a u64> for PostgresValue<'a>

fn from(value: &'a u64) -> Self

Converts to this type from the input type.

impl<'a> From<&'a usize> for PostgresValue<'a>

fn from(value: &'a usize) -> Self

Converts to this type from the input type.

impl<'a> From<&PostgresValue<'a>> for OwnedPostgresValue

fn from(value: &PostgresValue<'a>) -> Self

Converts to this type from the input type.

impl From<Arc<String>> for PostgresValue<'_>

fn from(value: Arc<String>) -> Self

Converts to this type from the input type.

impl From<Arc<Vec<u8>>> for PostgresValue<'_>

fn from(value: Arc<Vec<u8>>) -> Self

Converts to this type from the input type.

impl From<Arc<str>> for PostgresValue<'_>

fn from(value: Arc<str>) -> Self

Converts to this type from the input type.

impl From<Box<String>> for PostgresValue<'_>

fn from(value: Box<String>) -> Self

Converts to this type from the input type.

impl From<Box<Vec<u8>>> for PostgresValue<'_>

fn from(value: Box<Vec<u8>>) -> Self

Converts to this type from the input type.

impl From<Box<str>> for PostgresValue<'_>

fn from(value: Box<str>) -> Self

Converts to this type from the input type.

impl<'a> From<Cow<'a, [u8]>> for PostgresValue<'a>

fn from(value: Cow<'a, [u8]>) -> Self

Converts to this type from the input type.

impl<'a> From<Cow<'a, str>> for PostgresValue<'a>

fn from(value: Cow<'a, str>) -> Self

Converts to this type from the input type.

impl<T> From<Option<T>> for PostgresValue<'_>

where T: TryInto<Self>,

fn from(value: Option<T>) -> Self

Converts to this type from the input type.

impl From<OwnedPostgresValue> for PostgresValue<'_>

fn from(value: OwnedPostgresValue) -> Self

Converts to this type from the input type.

impl<'a> From<PostgresValue<'a>> for OwnedPostgresValue

fn from(value: PostgresValue<'a>) -> Self

Converts to this type from the input type.

impl<'a> From<PostgresValue<'a>> for SQL<'a, PostgresValue<'a>>

fn from(value: PostgresValue<'a>) -> Self

Converts to this type from the input type.

impl<'a> From<PostgresValue<'a>> for Cow<'a, PostgresValue<'a>>

fn from(value: PostgresValue<'a>) -> Self

Converts to this type from the input type.

impl From<Rc<String>> for PostgresValue<'_>

fn from(value: Rc<String>) -> Self

Converts to this type from the input type.

impl From<Rc<Vec<u8>>> for PostgresValue<'_>

fn from(value: Rc<Vec<u8>>) -> Self

Converts to this type from the input type.

impl From<Rc<str>> for PostgresValue<'_>

fn from(value: Rc<str>) -> Self

Converts to this type from the input type.

impl From<String> for PostgresValue<'_>

fn from(value: String) -> Self

Converts to this type from the input type.

impl<'a, T> From<T> for PostgresValue<'a>

where T: DrizzlePostgresColumn,

fn from(value: T) -> Self

Converts to this type from the input type.

impl<'a> From<Vec<&'a str>> for PostgresValue<'a>

fn from(value: Vec<&'a str>) -> Self

Converts to this type from the input type.

impl From<Vec<PostgresValue<'_>>> for PostgresValue<'_>

fn from(value: Vec<Self>) -> Self

Converts to this type from the input type.

impl From<Vec<String>> for PostgresValue<'_>

fn from(value: Vec<String>) -> Self

Converts to this type from the input type.

impl From<Vec<bool>> for PostgresValue<'_>

fn from(value: Vec<bool>) -> Self

Converts to this type from the input type.

impl From<Vec<f32>> for PostgresValue<'_>

fn from(value: Vec<f32>) -> Self

Converts to this type from the input type.

impl From<Vec<f64>> for PostgresValue<'_>

fn from(value: Vec<f64>) -> Self

Converts to this type from the input type.

impl From<Vec<i16>> for PostgresValue<'_>

fn from(value: Vec<i16>) -> Self

Converts to this type from the input type.

impl From<Vec<i32>> for PostgresValue<'_>

fn from(value: Vec<i32>) -> Self

Converts to this type from the input type.

impl From<Vec<i64>> for PostgresValue<'_>

fn from(value: Vec<i64>) -> Self

Converts to this type from the input type.

impl From<Vec<u8>> for PostgresValue<'_>

fn from(value: Vec<u8>) -> Self

Converts to this type from the input type.

impl From<bool> for PostgresValue<'_>

fn from(value: bool) -> Self

Converts to this type from the input type.

impl From<f32> for PostgresValue<'_>

fn from(value: f32) -> Self

Converts to this type from the input type.

impl From<f64> for PostgresValue<'_>

fn from(value: f64) -> Self

Converts to this type from the input type.

impl From<i8> for PostgresValue<'_>

fn from(value: i8) -> Self

Converts to this type from the input type.

impl From<i16> for PostgresValue<'_>

fn from(value: i16) -> Self

Converts to this type from the input type.

impl From<i32> for PostgresValue<'_>

fn from(value: i32) -> Self

Converts to this type from the input type.

impl From<i64> for PostgresValue<'_>

fn from(value: i64) -> Self

Converts to this type from the input type.

impl From<isize> for PostgresValue<'_>

fn from(value: isize) -> Self

Converts to this type from the input type.

impl From<u8> for PostgresValue<'_>

fn from(value: u8) -> Self

Converts to this type from the input type.

impl From<u16> for PostgresValue<'_>

fn from(value: u16) -> Self

Converts to this type from the input type.

impl From<u32> for PostgresValue<'_>

fn from(value: u32) -> Self

Converts to this type from the input type.

impl From<u64> for PostgresValue<'_>

fn from(value: u64) -> Self

Converts to this type from the input type.

impl From<usize> for PostgresValue<'_>

fn from(value: usize) -> Self

Converts to this type from the input type.

impl<'a> PartialEq for PostgresValue<'a>

fn eq(&self, other: &PostgresValue<'a>) -> bool

Equality operator ==.

fn ne(&self, other: &Rhs) -> bool

Inequality operator !=.

impl SQLParam for PostgresValue<'_>

const DIALECT: Dialect = drizzle_core::dialect::Dialect::PostgreSQL

The SQL dialect for this parameter type

type DialectMarker = PostgresDialect

Type-level dialect marker for compile-time dispatch.

impl<'a> StructuralPartialEq for PostgresValue<'a>

impl<'a, Table, Query> ToSQL<'a, PostgresValue<'a>> for CTEView<'a, Table, Query>

where Query: ToSQL<'a, PostgresValue<'a>>,

fn to_sql(&self) -> SQL<'a, PostgresValue<'a>>

fn into_sql(self) -> SQL<'a, V>

where Self: Sized,

Consume self and return SQL without cloning. Default delegates to to_sql() (which clones). Types that own their SQL (like SQL and SQLExpr) override this to avoid the clone.

impl<'a, State> ToSQL<'a, PostgresValue<'a>> for RefreshMaterializedView<'a, State>

fn to_sql(&self) -> SQL<'a, PostgresValue<'a>>

fn into_sql(self) -> SQL<'a, V>

where Self: Sized,

Consume self and return SQL without cloning. Default delegates to to_sql() (which clones). Types that own their SQL (like SQL and SQLExpr) override this to avoid the clone.

impl<'a, Schema, State, Table, Marker, Row, Grouped> ToSQL<'a, PostgresValue<'a>> for QueryBuilder<'a, Schema, State, Table, Marker, Row, Grouped>

fn to_sql(&self) -> SQL<'a, PostgresValue<'a>>

fn into_sql(self) -> SQL<'a, V>

where Self: Sized,

Consume self and return SQL without cloning. Default delegates to to_sql() (which clones). Types that own their SQL (like SQL and SQLExpr) override this to avoid the clone.

impl<'a, T> ToSQL<'a, PostgresValue<'a>> for PgArray<T>

where T: Into<PostgresValue<'a>> + Clone,

fn to_sql(&self) -> SQL<'a, PostgresValue<'a>>

fn into_sql(self) -> SQL<'a, V>

where Self: Sized,

Consume self and return SQL without cloning. Default delegates to to_sql() (which clones). Types that own their SQL (like SQL and SQLExpr) override this to avoid the clone.

impl<'a> TryFrom<&'a PostgresValue<'a>> for &'a str

type Error = DrizzleError

The type returned in the event of a conversion error.

fn try_from(value: &'a PostgresValue<'a>) -> Result<Self, Self::Error>

Performs the conversion.

impl<'a> TryFrom<&'a PostgresValue<'a>> for &'a [u8]

type Error = DrizzleError

The type returned in the event of a conversion error.

fn try_from(value: &'a PostgresValue<'a>) -> Result<Self, Self::Error>

Performs the conversion.

impl<'a> TryFrom<&'a PostgresValue<'a>> for &'a [PostgresValue<'a>]

type Error = DrizzleError

The type returned in the event of a conversion error.

fn try_from(value: &'a PostgresValue<'a>) -> Result<Self, Self::Error>

Performs the conversion.

impl<'a> TryFrom<PostgresValue<'a>> for i16

type Error = DrizzleError

The type returned in the event of a conversion error.

fn try_from(value: PostgresValue<'a>) -> Result<Self, Self::Error>

Performs the conversion.

impl<'a> TryFrom<PostgresValue<'a>> for i32

type Error = DrizzleError

The type returned in the event of a conversion error.

fn try_from(value: PostgresValue<'a>) -> Result<Self, Self::Error>

Performs the conversion.

impl<'a> TryFrom<PostgresValue<'a>> for i64

type Error = DrizzleError

The type returned in the event of a conversion error.

fn try_from(value: PostgresValue<'a>) -> Result<Self, Self::Error>

Performs the conversion.

impl<'a> TryFrom<PostgresValue<'a>> for f32

type Error = DrizzleError

The type returned in the event of a conversion error.

fn try_from(value: PostgresValue<'a>) -> Result<Self, Self::Error>

Performs the conversion.

impl<'a> TryFrom<PostgresValue<'a>> for f64

type Error = DrizzleError

The type returned in the event of a conversion error.

fn try_from(value: PostgresValue<'a>) -> Result<Self, Self::Error>

Performs the conversion.

impl<'a> TryFrom<PostgresValue<'a>> for bool

type Error = DrizzleError

The type returned in the event of a conversion error.

fn try_from(value: PostgresValue<'a>) -> Result<Self, Self::Error>

Performs the conversion.

impl<'a> TryFrom<PostgresValue<'a>> for String

type Error = DrizzleError

The type returned in the event of a conversion error.

fn try_from(value: PostgresValue<'a>) -> Result<Self, Self::Error>

Performs the conversion.

impl<'a> TryFrom<PostgresValue<'a>> for Box<String>

type Error = DrizzleError

The type returned in the event of a conversion error.

fn try_from(value: PostgresValue<'a>) -> Result<Self, Self::Error>

Performs the conversion.

impl<'a> TryFrom<PostgresValue<'a>> for Rc<String>

type Error = DrizzleError

The type returned in the event of a conversion error.

fn try_from(value: PostgresValue<'a>) -> Result<Self, Self::Error>

Performs the conversion.

impl<'a> TryFrom<PostgresValue<'a>> for Arc<String>

type Error = DrizzleError

The type returned in the event of a conversion error.

fn try_from(value: PostgresValue<'a>) -> Result<Self, Self::Error>

Performs the conversion.

impl<'a> TryFrom<PostgresValue<'a>> for Box<str>

type Error = DrizzleError

The type returned in the event of a conversion error.

fn try_from(value: PostgresValue<'a>) -> Result<Self, Self::Error>

Performs the conversion.

impl<'a> TryFrom<PostgresValue<'a>> for Rc<str>

type Error = DrizzleError

The type returned in the event of a conversion error.

fn try_from(value: PostgresValue<'a>) -> Result<Self, Self::Error>

Performs the conversion.

impl<'a> TryFrom<PostgresValue<'a>> for Arc<str>

type Error = DrizzleError

The type returned in the event of a conversion error.

fn try_from(value: PostgresValue<'a>) -> Result<Self, Self::Error>

Performs the conversion.

impl<'a> TryFrom<PostgresValue<'a>> for Vec<u8>

type Error = DrizzleError

The type returned in the event of a conversion error.

fn try_from(value: PostgresValue<'a>) -> Result<Self, Self::Error>

Performs the conversion.

impl<'a> TryFrom<PostgresValue<'a>> for Box<Vec<u8>>

type Error = DrizzleError

The type returned in the event of a conversion error.

fn try_from(value: PostgresValue<'a>) -> Result<Self, Self::Error>

Performs the conversion.

impl<'a> TryFrom<PostgresValue<'a>> for Rc<Vec<u8>>

type Error = DrizzleError

The type returned in the event of a conversion error.

fn try_from(value: PostgresValue<'a>) -> Result<Self, Self::Error>

Performs the conversion.

impl<'a> TryFrom<PostgresValue<'a>> for Arc<Vec<u8>>

type Error = DrizzleError

The type returned in the event of a conversion error.

fn try_from(value: PostgresValue<'a>) -> Result<Self, Self::Error>

Performs the conversion.

impl<'a> TryFrom<PostgresValue<'a>> for Vec<PostgresValue<'a>>

type Error = DrizzleError

The type returned in the event of a conversion error.

fn try_from(value: PostgresValue<'a>) -> Result<Self, Self::Error>

Performs the conversion.