Enum Value 

pub enum Value {
    Null,
    Bool(bool),
    Int8(i8),
    Int16(i16),
    Int32(i32),
    Int64(i64),
    Float32(f32),
    Float64(f64),
    Decimal(Decimal),
    String(String),
    Bytes(Vec<u8>),
    Date(NaiveDate),
    Time(NaiveTime),
    DateTime(NaiveDateTime),
    DateTimeTz(DateTime<Utc>),
    Uuid(Uuid),
    Json(Value),
    Array(Vec<Value>),
    Interval(i64),
    Bit(Vec<u8>),
    Enum(String),
    Geometry(Vec<u8>),
    Geography(Vec<u8>),
    Range {
        lower: Option<Box<Value>>,
        upper: Option<Box<Value>>,
        lower_inclusive: bool,
        upper_inclusive: bool,
    },
    Composite(HashMap<String, Value>),
    Custom {
        type_name: String,
        data: Vec<u8>,
    },
}

SQL value type that can hold any database value

Variants

Null

SQL NULL

Bool(bool)

Boolean value

Int8(i8)

8-bit signed integer (TINYINT)

Int16(i16)

16-bit signed integer (SMALLINT)

Int32(i32)

32-bit signed integer (INTEGER)

Int64(i64)

64-bit signed integer (BIGINT)

Float32(f32)

32-bit floating point (REAL)

Float64(f64)

64-bit floating point (DOUBLE PRECISION)

Decimal(Decimal)

Arbitrary precision decimal (NUMERIC, DECIMAL)

String(String)

Text string (VARCHAR, TEXT, CHAR)

Bytes(Vec<u8>)

Binary data (BYTEA, BLOB, VARBINARY)

Date(NaiveDate)

Date without time (DATE)

Time(NaiveTime)

Time without date (TIME)

DateTime(NaiveDateTime)

Timestamp without timezone (TIMESTAMP)

DateTimeTz(DateTime<Utc>)

Timestamp with timezone (TIMESTAMPTZ)

Uuid(Uuid)

UUID

Json(Value)

JSON value

Array(Vec<Value>)

Array of values

Interval(i64)

Interval (stored as microseconds)

Bit(Vec<u8>)

Bit string

Enum(String)

Enum value (stored as string)

Geometry(Vec<u8>)

Geometry (WKB format)

Geography(Vec<u8>)

Geography (WKB format)

Range

Range type (e.g., int4range, tsrange)

Fields

lower: Option<Box<Value>>

upper: Option<Box<Value>>

lower_inclusive: bool

upper_inclusive: bool

Composite(HashMap<String, Value>)

Composite/row type

Custom

Custom type (vendor-specific)

Fields

type_name: String

data: Vec<u8>

Implementations

impl Value

pub const fn is_null(&self) -> bool

Check if value is NULL

pub fn sql_type(&self) -> &'static str

Get SQL type name

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

Try to convert to bool

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

Try to convert to i64

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

Try to convert to f64

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

Try to convert to string

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

Try to convert to bytes

pub fn as_uuid(&self) -> Option<Uuid>

Try to convert to UUID

pub fn as_json(&self) -> Option<&Value>

Try to convert to JSON

pub fn as_string(&self) -> Option<String>

Convert to owned string representation

Trait Implementations

impl Clone for Value

fn clone(&self) -> Value

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for Value

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for Value

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl From<&str> for Value

fn from(v: &str) -> Self

Converts to this type from the input type.

impl From<DateTime<Utc>> for Value

fn from(v: DateTime<Utc>) -> Self

Converts to this type from the input type.

impl From<Decimal> for Value

fn from(v: Decimal) -> Self

Converts to this type from the input type.

impl From<NaiveDate> for Value

fn from(v: NaiveDate) -> Self

Converts to this type from the input type.

impl From<NaiveDateTime> for Value

fn from(v: NaiveDateTime) -> Self

Converts to this type from the input type.

impl From<NaiveTime> for Value

fn from(v: NaiveTime) -> Self

Converts to this type from the input type.

impl<T: Into<Value>> From<Option<T>> for Value

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

Converts to this type from the input type.

impl From<String> for Value

fn from(v: String) -> Self

Converts to this type from the input type.

impl From<Uuid> for Value

fn from(v: Uuid) -> Self

Converts to this type from the input type.

impl From<Value> for Value

fn from(v: Value) -> Self

Converts to this type from the input type.

impl<T: Into<Value>> From<Vec<T>> for Value

fn from(v: Vec<T>) -> Self

Converts to this type from the input type.

impl From<Vec<u8>> for Value

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

Converts to this type from the input type.

impl From<bool> for Value

Implement From traits for common types

fn from(v: bool) -> Self

Converts to this type from the input type.

impl From<f32> for Value

fn from(v: f32) -> Self

Converts to this type from the input type.

impl From<f64> for Value

fn from(v: f64) -> Self

Converts to this type from the input type.

impl From<i16> for Value

fn from(v: i16) -> Self

Converts to this type from the input type.

impl From<i32> for Value

fn from(v: i32) -> Self

Converts to this type from the input type.

impl From<i64> for Value

fn from(v: i64) -> Self

Converts to this type from the input type.

impl From<i8> for Value

fn from(v: i8) -> Self

Converts to this type from the input type.

impl PartialEq for Value

fn eq(&self, other: &Value) -> bool

Tests for self and other values to be equal, and is used by ==.

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

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl Serialize for Value

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl StructuralPartialEq for Value