Struct pgrx::datum::Time

pub struct Time(/* private fields */);

A safe wrapper around Postgres TIME type, backed by a pg_sys::TimeADT integer value.

Implementations

impl Time

pub const ALLBALLS: Self = _

00:00:00

pub fn new( hour: u8, minute: u8, second: f64 ) -> Result<Time, DateTimeConversionError>

Construct a new Time from its constituent parts.

Errors

Returns a DateTimeConversionError if any part is outside the bounds for that part

pub fn new_unchecked(hour: u8, minute: u8, second: f64) -> Time

Construct a new Time from its constituent parts.

Elides the overhead of trapping errors for out-of-bounds parts

Panics

This function panics if any part is out-of-bounds

pub fn hour(&self) -> u8

Return the hour

pub fn minute(&self) -> u8

Return the minute

pub fn second(&self) -> f64

Return the second

pub fn microseconds(&self) -> u32

Return the microseconds part. This is not the time counted in microseconds, but the fractional seconds

pub fn to_hms_micro(&self) -> (u8, u8, u8, u32)

Return the hour, minute, second, and microseconds as a Rust tuple

pub fn into_inner(self) -> TimeADT

Return the backing pg_sys::TimeADT value.

Trait Implementations

impl Add<Date> for Time

type Output = Timestamp

The resulting type after applying the + operator.

fn add(self, rhs: Date) -> Self::Output

Performs the + operation.

impl Add<Interval> for Time

type Output = Time

The resulting type after applying the + operator.

fn add(self, rhs: Interval) -> Self::Output

Performs the + operation.

impl Add<Time> for Date

type Output = Timestamp

The resulting type after applying the + operator.

fn add(self, rhs: Time) -> Self::Output

Performs the + operation.

impl Add<Time> for Interval

type Output = Time

The resulting type after applying the + operator.

fn add(self, rhs: Time) -> Self::Output

Performs the + operation.

impl Clone for Time

fn clone(&self) -> Time

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Debug for Time

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for Time

fn deserialize<D>(deserializer: D) -> Result<Self, D::Error>

where D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl Display for Time

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

Uses the underlying “output” function to convert this type to a String

impl From<Interval> for Time

fn from(value: Interval) -> Self

Converts to this type from the input type.

impl From<Time> for Interval

fn from(value: Time) -> Self

Converts to this type from the input type.

impl From<Time> for TimeWithTimeZone

fn from(t: Time) -> TimeWithTimeZone

Converts to this type from the input type.

impl From<Time> for TimeADT

fn from(value: Time) -> Self

Converts to this type from the input type.

impl From<TimeWithTimeZone> for Time

fn from(value: TimeWithTimeZone) -> Self

Converts to this type from the input type.

impl From<Timestamp> for Time

fn from(value: Timestamp) -> Self

Converts to this type from the input type.

impl From<TimestampWithTimeZone> for Time

fn from(value: TimestampWithTimeZone) -> Self

Converts to this type from the input type.

impl From<i64> for Time

Create a Time from a pg_sys::TimeADT

Note that pg_sys::TimeADT is just an i64 as a number of microseconds. This impl currently allows creating a Time that cannot be constructed by SQL, such as at the time 37:42, which may yield logic bugs if used.

fn from(value: TimeADT) -> Self

Converts to this type from the input type.

impl FromDatum for Time

unsafe fn from_polymorphic_datum( datum: Datum, is_null: bool, _typoid: Oid ) -> Option<Time>

Like from_datum for instantiating polymorphic types which require preserving the dynamic type metadata.

const GET_TYPOID: bool = false

Should a type OID be fetched when calling from_datum?

unsafe fn from_datum(datum: Datum, is_null: bool) -> Option<Self>

where Self: Sized,

Safety

unsafe fn from_datum_in_memory_context( memory_context: PgMemoryContexts, datum: Datum, is_null: bool, typoid: Oid ) -> Option<Self>

where Self: Sized,

Default implementation switched to the specified memory context and then simply calls FromDatum::from_datum(...) from within that context.

unsafe fn try_from_datum( datum: Datum, is_null: bool, type_oid: Oid ) -> Result<Option<Self>, TryFromDatumError>

where Self: Sized + IntoDatum,

try_from_datum is a convenience wrapper around FromDatum::from_datum that returns a a Result around an Option, as a Datum can be null. It’s intended to be used in situations where the caller needs to know whether the type conversion succeeded or failed.

unsafe fn try_from_datum_in_memory_context( memory_context: PgMemoryContexts, datum: Datum, is_null: bool, type_oid: Oid ) -> Result<Option<Self>, TryFromDatumError>

where Self: Sized + IntoDatum,

A version of try_from_datum that switches to the given context to convert from Datum

impl FromStr for Time

fn from_str(s: &str) -> Result<Self, Self::Err>

Create this type from a string.

type Err = DateTimeConversionError

The associated error which can be returned from parsing.

impl HasExtractableParts for Time

const EXTRACT_FUNCTION: unsafe fn(_: FunctionCallInfo) -> Datum = {pgrx_pg_sys::extract_time as unsafe fn(*mut pgrx_pg_sys::FunctionCallInfoBaseData) -> pgrx_pg_sys::Datum}

fn extract_part(&self, field: DateTimeParts) -> Option<AnyNumeric>

Extract a DateTimeParts part from a date/time-like type

impl Hash for Time

fn hash<H: Hasher>(&self, state: &mut H)

Uses the underlying Postgres “hash” function for this type

fn hash_slice<H>(data: &[Self], state: &mut H)

where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher.

impl IntoDatum for Time

fn into_datum(self) -> Option<Datum>

fn type_oid() -> Oid

fn composite_type_oid(&self) -> Option<Oid>

fn array_type_oid() -> Oid

fn is_compatible_with(other: Oid) -> bool

Is a Datum of this type compatible with another Postgres type?

impl Ord for Time

fn cmp(&self, other: &Self) -> Ordering

Uses the underlying Postgres “_cmp()” function for this type

fn max(self, other: Self) -> Self

where Self: Sized,

Compares and returns the maximum of two values.

fn min(self, other: Self) -> Self

where Self: Sized,

Compares and returns the minimum of two values.

fn clamp(self, min: Self, max: Self) -> Self

where Self: Sized + PartialOrd,

Restrict a value to a certain interval.

impl PartialEq for Time

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

Uses the underlying Postgres “_eq()” function for this type

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

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

impl PartialOrd for Time

fn partial_cmp(&self, other: &Self) -> Option<Ordering>

This method returns an ordering between self and other values if one exists.

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

This method tests less than (for self and other) and is used by the < operator.

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

This method tests less than or equal to (for self and other) and is used by the <= operator.

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

This method tests greater than (for self and other) and is used by the > operator.

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

This method tests greater than or equal to (for self and other) and is used by the >= operator.

impl Serialize for Time

fn serialize<S>( &self, serializer: S ) -> Result<<S as Serializer>::Ok, <S as Serializer>::Error>

where S: Serializer,

Serialize this Time in ISO form, compatible with most JSON parsers

impl SqlTranslatable for Time

fn argument_sql() -> Result<SqlMapping, ArgumentError>

fn return_sql() -> Result<Returns, ReturnsError>

fn type_name() -> &'static str

fn variadic() -> bool

fn optional() -> bool

fn entity() -> FunctionMetadataTypeEntity

impl Sub<Interval> for Time

type Output = Time

The resulting type after applying the - operator.

fn sub(self, rhs: Interval) -> Self::Output

Performs the - operation.

impl Sub for Time

type Output = Interval

The resulting type after applying the - operator.

fn sub(self, rhs: Self) -> Self::Output

Performs the - operation.

impl ToIsoString for Time

fn to_iso_string(self) -> String

Encode of this date/time-like type into JSON string in ISO format using optionally preallocated buffer ‘buf’.

fn to_iso_string_with_timezone<Tz: AsRef<str>>( self, timezone: Tz ) -> Result<String, DateTimeConversionError>

Encode of this date/time-like type into JSON string in ISO format using optionally preallocated buffer ‘buf’.

impl TryFrom<Datum> for Time

type Error = TryFromIntError

The type returned in the event of a conversion error.

fn try_from(d: Datum) -> Result<Self, Self::Error>

Performs the conversion.

impl Copy for Time

impl Eq for Time