Table of Contents
period
: Constructor for period
timestampset
: Constructor for timestampset
periodset
: Constructor for periodset
timestamptz::time
: Cast a timestamptz
to another time type
timestampset::periodset
: Cast a timestampset
to a periodset
period::type
: Cast a period
to another type
tstzrange::period
: Cast a tstzrange
to a period
memSize
: Get the memory size in bytes
lower
: Get the lower bound
upper
: Get the upper bound
lower_inc
: Is the lower bound inclusive?
upper_inc
: Is the upper bound inclusive?
timespan
: Get the timespan
period
: Get the period on which the timestamp set or period set is defined ignoring the potential time gaps
numTimestamps
: Get the number of different timestamps
startTimestamp
: Get the start timestamp
endTimestamp
: Get the end timestamp
timestampN
: Get the n-th different timestamp
timestamps
: Get the different timestamps
numPeriods
: Get the number of periods
startPeriod
: Get the start period
endPeriod
: Get the end period
periodN
: Get the n-th period
periods
: Get the periods
shift
: Shift the time value by an interval
=
: Are the time values equal?
<>
: Are the time values different?
<
: Is the first time value less than the second one?
>
: Is the first time value greater than the second one?
<=
: Is the first time value less than or equal to the second one?
>=
: Is the first time value greater than or equal to the second one?
&&
: Do the time values overlap (have points in common)?
@>
: Does the first time value contain the second one?
<@
: Is the first time value contained by the second one?
-|-
: Is the first time value adjacent to the second one?
<<
: Is the first number or range value scritly left of the second one?
>>
: Is the first number or range value strictly right of the second one?
&<
: Is the first number or range value not to the right of the second one?
&>
: Is the first number or range value not to the left of the second one?
-|-
: Is the first number or range value adjacent to the second one?
<<#
: Is the first time value scritly before the second one?
#>>
: Is the first time value strictly after the second one?
&<#
: Is the first time value not after the second one?
#&>
: Is the first time value not before the second one?