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,
}

One PostgreSQL value, borrowed for 'a: a bound parameter or a decoded column.

Rust values convert into it with From (42_i32.into()), and it converts back with convert or TryFrom. Variants for optional crates (chrono, uuid, …) exist only with the matching feature.

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 the value into an OwnedPostgresValue, copying borrowed data.

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

Converts the value into a Rust type through FromPostgresValue.

Integers convert to other integer types when they fit, and text is parsed for numeric targets. An enum converts through its variant label and NUMERIC through its text form.

Examples

use drizzle_postgres::values::PostgresValue;

let value = PostgresValue::Integer(7);
let n: i64 = value.convert().unwrap();
assert_eq!(n, 7);

Errors

Returns DrizzleError::ConversionError when T cannot hold the stored value, for example text that does not parse as the integer type.

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

Like convert, but borrows the value (cloning data where T needs it).

Errors

Returns DrizzleError::ConversionError when T cannot hold the stored value.

Trait Implementations

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

fn clone(&self) -> Self

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() -> Self

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: ClauseAllowed<Source>, M: SubqueryType<'a, PostgresValue<'a>> + SelectSources,

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>

Renders this value as a scalar expression, borrowing it.

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

where Self: Sized,

Renders this value as a scalar expression, consuming it.

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

Renders this value as one element of a ConditionList.

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

where Self: Sized,

Consuming counterpart of Expr::to_condition_sql.

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

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

type SQLType = Array<<T as Expr<'a, PostgresValue<'a>>>::SQLType>

The SQL data type this expression evaluates to.

type Nullable = NonNull

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>

Renders this value as a scalar expression, borrowing it.

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

where Self: Sized,

Renders this value as a scalar expression, consuming it.

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

Renders this value as one element of a ConditionList.

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

where Self: Sized,

Consuming counterpart of Expr::to_condition_sql.

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>,

None is NULL.

Panics

Panics when T’s conversion fails (for example a JSON payload whose Serialize implementation errors), rather than storing NULL in place of the value.

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: &Self) -> bool

Equality operator ==.

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

Inequality operator !=.

impl SQLParam for PostgresValue<'_>

fn pagination_param(value: usize) -> Option<Self>

Binds LIMIT/OFFSET values as BIGINT parameters so paginated queries share one SQL text (and one cached prepared statement) across pages.

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

The dialect, at runtime.

type DialectMarker = PostgresDialect

The dialect, as a type (SQLiteDialect, PostgresDialect or MySQLDialect).

fn write_literal(&self, buf: &mut String) -> bool

Appends this value to buf as a SQL literal of this dialect.

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

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

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

Renders self as a SQL fragment.

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

where Self: Sized,

Renders self as a SQL fragment, consuming it.

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>>

Renders self as a SQL fragment.

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

where Self: Sized,

Renders self as a SQL fragment, consuming it.

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

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

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

Renders self as a SQL fragment.

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

where Self: Sized,

Renders self as a SQL fragment, consuming it.

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.