MobilityDB 1.3
Loading...
Searching...
No Matches
Functions

Position functions for temporal types. More...

Functions

Datum After_tbox_tnumber (PG_FUNCTION_ARGS)
 Return true if a temporal box is after a temporal number @sqlfn temporal_after() More...
 
Datum After_temporal_temporal (PG_FUNCTION_ARGS)
 Return true if the first temporal value is after the second one @sqlfn temporal_after() More...
 
Datum After_temporal_tstzspan (PG_FUNCTION_ARGS)
 Return true if a temporal value is after a timestamptz span @sqlfn temporal_after() More...
 
Datum After_tnumber_tbox (PG_FUNCTION_ARGS)
 Return true if a temporal number is after a temporal box @sqlfn temporal_after() More...
 
Datum After_tnumber_tnumber (PG_FUNCTION_ARGS)
 Return true if the first temporal number is after the second one @sqlfn temporal_after() More...
 
Datum After_tstzspan_temporal (PG_FUNCTION_ARGS)
 Return true if a timestamptz span is after a temporal value @sqlfn temporal_after() More...
 
Datum Before_tbox_tnumber (PG_FUNCTION_ARGS)
 Return true if a temporal box is before a temporal number @sqlfn temporal_before() More...
 
Datum Before_temporal_temporal (PG_FUNCTION_ARGS)
 Return true if the first temporal value is before the second one @sqlfn temporal_before() More...
 
Datum Before_temporal_tstzspan (PG_FUNCTION_ARGS)
 Return true if a temporal value is before a timestamptz span @sqlfn temporal_before() More...
 
Datum Before_tnumber_tbox (PG_FUNCTION_ARGS)
 Return true if a temporal number is before a temporal box @sqlfn temporal_before() More...
 
Datum Before_tnumber_tnumber (PG_FUNCTION_ARGS)
 Return true if the first temporal number is before the second one @sqlfn temporal_before() More...
 
Datum Before_tstzspan_temporal (PG_FUNCTION_ARGS)
 Return true if a timestamptz span is before a temporal value @sqlfn temporal_before() More...
 
Datum Left_numspan_tnumber (PG_FUNCTION_ARGS)
 Return true if a number span is to the left of a temporal number @sqlfn temporal_left() More...
 
Datum Left_tbox_tnumber (PG_FUNCTION_ARGS)
 Return true if a temporal box is to the left of a temporal number @sqlfn temporal_left() More...
 
Datum Left_tnumber_numspan (PG_FUNCTION_ARGS)
 Return true if a temporal number is to the left of a number span @sqlfn temporal_left() More...
 
Datum Left_tnumber_tbox (PG_FUNCTION_ARGS)
 Return true if a temporal number is to the left of a temporal box @sqlfn temporal_left() More...
 
Datum Left_tnumber_tnumber (PG_FUNCTION_ARGS)
 Return true if the first temporal number is to the left of the second one @sqlfn temporal_left() More...
 
Datum Overafter_tbox_tnumber (PG_FUNCTION_ARGS)
 Return true if a temporal box is not before a temporal number @sqlfn temporal_overafter() More...
 
Datum Overafter_temporal_temporal (PG_FUNCTION_ARGS)
 Return true if the first temporal value is not before the second one @sqlfn temporal_overafter() More...
 
Datum Overafter_temporal_tstzspan (PG_FUNCTION_ARGS)
 Return true if a temporal value is not before a timestamptz span @sqlfn temporal_overafter() More...
 
Datum Overafter_tnumber_tbox (PG_FUNCTION_ARGS)
 Return true if a temporal number is not before a temporal box @sqlfn temporal_overafter() More...
 
Datum Overafter_tnumber_tnumber (PG_FUNCTION_ARGS)
 Return true if the first temporal number is not before the second one @sqlfn temporal_overafter() More...
 
Datum Overafter_tstzspan_temporal (PG_FUNCTION_ARGS)
 Return true if a timestamptz span is not before a temporal value @sqlfn temporal_overafter() More...
 
Datum Overbefore_tbox_tnumber (PG_FUNCTION_ARGS)
 Return true if a temporal box is not after a temporal number @sqlfn temporal_overbefore() More...
 
Datum Overbefore_temporal_temporal (PG_FUNCTION_ARGS)
 Return true if the first temporal value is not after the second one @sqlfn temporal_overbefore() More...
 
Datum Overbefore_temporal_tstzspan (PG_FUNCTION_ARGS)
 Return true if a temporal value is not after a timestamptz span @sqlfn temporal_overbefore() More...
 
Datum Overbefore_tnumber_tbox (PG_FUNCTION_ARGS)
 Return true if a temporal number is not after a temporal box @sqlfn temporal_overbefore() More...
 
Datum Overbefore_tnumber_tnumber (PG_FUNCTION_ARGS)
 Return true if the first temporal number is not after the second one @sqlfn temporal_overbefore() More...
 
Datum Overbefore_tstzspan_temporal (PG_FUNCTION_ARGS)
 Return true if a timestamptz span is not after a temporal value @sqlfn temporal_overbefore() More...
 
Datum Overleft_numspan_tnumber (PG_FUNCTION_ARGS)
 Return true if a number span does not extend to the right of a temporal number @sqlfn temporal_overleft() More...
 
Datum Overleft_tbox_tnumber (PG_FUNCTION_ARGS)
 Return true if a temporal box does not extend to the right of a temporal number @sqlfn temporal_overleft() More...
 
Datum Overleft_tnumber_numspan (PG_FUNCTION_ARGS)
 Return true if a temporal number does not extend to the right of a number span @sqlfn temporal_overleft() More...
 
Datum Overleft_tnumber_tbox (PG_FUNCTION_ARGS)
 Return true if a temporal number does not extend to the right of a temporal box @sqlfn temporal_overleft() More...
 
Datum Overleft_tnumber_tnumber (PG_FUNCTION_ARGS)
 Return true if the first temporal number does not extend to the right of the second one @sqlfn temporal_overleft() More...
 
Datum Overright_numspan_tnumber (PG_FUNCTION_ARGS)
 Return true if a number span does not extend to the left of a temporal number @sqlfn temporal_overright() More...
 
Datum Overright_tbox_tnumber (PG_FUNCTION_ARGS)
 Return true if a temporal box does not extend to the left of a temporal number @sqlfn temporal_overright() More...
 
Datum Overright_tnumber_numspan (PG_FUNCTION_ARGS)
 Return true if a temporal number does not extend to the left of a number span @sqlfn temporal_overright() More...
 
Datum Overright_tnumber_tbox (PG_FUNCTION_ARGS)
 Return true if a temporal number does not extend to the left of a temporal box @sqlfn temporal_overright() More...
 
Datum Overright_tnumber_tnumber (PG_FUNCTION_ARGS)
 Return true if the first temporal number does not extend to the left of the second one @sqlfn temporal_overright() More...
 
Datum Right_numspan_tnumber (PG_FUNCTION_ARGS)
 Return true if a number span is to the right of a temporal number @sqlfn temporal_right() More...
 
Datum Right_tbox_tnumber (PG_FUNCTION_ARGS)
 Return true if a temporal box is to the right of a temporal number @sqlfn temporal_right() More...
 
Datum Right_tnumber_numspan (PG_FUNCTION_ARGS)
 Return true if a temporal number is to the right of a number span @sqlfn temporal_right() More...
 
Datum Right_tnumber_tbox (PG_FUNCTION_ARGS)
 Return true if a temporal number is to the right of a temporal box @sqlfn temporal_right() More...
 
Datum Right_tnumber_tnumber (PG_FUNCTION_ARGS)
 Return true if the first temporal number is to the right of the second one @sqlfn temporal_right() More...
 

Detailed Description

Position functions for temporal types.