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

Position functions for set and span types. More...

Functions

bool after_date_set (DateADT d, const Set *s)
 Return true if a date is after a set. More...
 
bool after_date_span (DateADT d, const Span *s)
 Return true if a date is after a span. More...
 
bool after_date_spanset (DateADT d, const SpanSet *ss)
 Return true if a date is after a span set. More...
 
bool after_set_date (const Set *s, DateADT d)
 Return true if a set is after a date. More...
 
bool after_set_timestamptz (const Set *s, TimestampTz t)
 Return true if a set is after a timestamptz. More...
 
bool after_span_date (const Span *s, DateADT d)
 Return true if a span is after a date. More...
 
bool after_span_timestamptz (const Span *s, TimestampTz t)
 Return true if a span is after a timestamptz. More...
 
bool after_spanset_date (const SpanSet *ss, DateADT d)
 Return true if a span set is after a date. More...
 
bool after_spanset_timestamptz (const SpanSet *ss, TimestampTz t)
 Return true if a span set is after a timestamptz. More...
 
bool after_timestamptz_set (TimestampTz t, const Set *s)
 Return true if a timestamptz is after a set. More...
 
bool after_timestamptz_span (TimestampTz t, const Span *s)
 Return true if a timestamptz is after a span. More...
 
bool after_timestamptz_spanset (TimestampTz t, const SpanSet *ss)
 Return true if a timestamptz is after a span set. More...
 
bool before_date_set (DateADT d, const Set *s)
 Return true if a date is before a set. More...
 
bool before_date_span (DateADT d, const Span *s)
 Return true if a date is before a span. More...
 
bool before_date_spanset (DateADT d, const SpanSet *ss)
 Return true if a date is before a span set. More...
 
bool before_set_date (const Set *s, DateADT d)
 Return true if a set is before a date. More...
 
bool before_set_timestamptz (const Set *s, TimestampTz t)
 Return true if a set is before a timestamptz. More...
 
bool before_span_date (const Span *s, DateADT d)
 Return true if a span is before a date. More...
 
bool before_span_timestamptz (const Span *s, TimestampTz t)
 Return true if a span is before a timestamptz. More...
 
bool before_spanset_date (const SpanSet *ss, DateADT d)
 Return true if a span set is before a date. More...
 
bool before_spanset_timestamptz (const SpanSet *ss, TimestampTz t)
 Return true if a span set is before a timestamptz. More...
 
bool before_timestamptz_set (TimestampTz t, const Set *s)
 Return true if a timestamptz is before a set. More...
 
bool before_timestamptz_span (TimestampTz t, const Span *s)
 Return true if a timestamptz is before a span. More...
 
bool before_timestamptz_spanset (TimestampTz t, const SpanSet *ss)
 Return true if a timestamptz is before a span set. More...
 
bool left_bigint_set (int64 i, const Set *s)
 Return true if a big integer is to the left of a set. More...
 
bool left_bigint_span (int64 i, const Span *s)
 Return true if a big integer is to the left of a span. More...
 
bool left_bigint_spanset (int64 i, const SpanSet *ss)
 Return true if a big integer is to the left of a span set. More...
 
bool left_float_set (double d, const Set *s)
 Return true if a float is to the left of a set. More...
 
bool left_float_span (double d, const Span *s)
 Return true if a float is to the left of a span. More...
 
bool left_float_spanset (double d, const SpanSet *ss)
 Return true if a float is to the left of a span set. More...
 
bool left_int_set (int i, const Set *s)
 Return true if an integer is to the left of a set. More...
 
bool left_int_span (int i, const Span *s)
 Return true if an integer is to the left of a span. More...
 
bool left_int_spanset (int i, const SpanSet *ss)
 Return true if an integer is to the left of a span set. More...
 
bool left_set_bigint (const Set *s, int64 i)
 Return true if a set is to the left of a big integer. More...
 
bool left_set_float (const Set *s, double d)
 Return true if a set is to the left of a float. More...
 
bool left_set_int (const Set *s, int i)
 Return true if a set is to the left of an integer. More...
 
bool left_set_set (const Set *s1, const Set *s2)
 Return true if the first set is to the left of the second one. More...
 
bool left_set_text (const Set *s, text *txt)
 Return true if a set is to the left of a text. More...
 
bool left_span_bigint (const Span *s, int64 i)
 Return true if a span is to the left of a big integer. More...
 
bool left_span_float (const Span *s, double d)
 Return true if a span is to the left of a float. More...
 
bool left_span_int (const Span *s, int i)
 Return true if a span is to the left of an integer. More...
 
bool left_span_span (const Span *s1, const Span *s2)
 Return true if the first span is to the left of the second one. More...
 
bool left_span_spanset (const Span *s, const SpanSet *ss)
 Return true if a span is before a span set. More...
 
bool left_spanset_bigint (const SpanSet *ss, int64 i)
 Return true if a span set is to the left of a big integer. More...
 
bool left_spanset_float (const SpanSet *ss, double d)
 Return true if a span set is to the left of a float. More...
 
bool left_spanset_int (const SpanSet *ss, int i)
 Return true if a span set is to the left of an integer. More...
 
bool left_spanset_span (const SpanSet *ss, const Span *s)
 Return true if a span set is to the left a span. More...
 
bool left_spanset_spanset (const SpanSet *ss1, const SpanSet *ss2)
 Return true if the first span set is to the left of the second one. More...
 
bool left_text_set (const text *txt, const Set *s)
 Return true if a text is to the left of a set. More...
 
bool overafter_date_set (DateADT d, const Set *s)
 Return true if a date is not before a set. More...
 
bool overafter_date_span (DateADT d, const Span *s)
 Return true if a date is not before a span. More...
 
bool overafter_date_spanset (DateADT d, const SpanSet *ss)
 Return true if a date is not before a span set. More...
 
bool overafter_set_date (const Set *s, DateADT d)
 Return true if a set is not before a date. More...
 
bool overafter_set_timestamptz (const Set *s, TimestampTz t)
 Return true if a set is not before a timestamptz. More...
 
bool overafter_span_date (const Span *s, DateADT d)
 Return true if a span is not before a date. More...
 
bool overafter_span_timestamptz (const Span *s, TimestampTz t)
 Return true if a span is not before a timestamptz. More...
 
bool overafter_spanset_date (const SpanSet *ss, DateADT d)
 Return true if a span set is before a date. More...
 
bool overafter_spanset_timestamptz (const SpanSet *ss, TimestampTz t)
 Return true if a span set is before a timestamptz. More...
 
bool overafter_timestamptz_set (TimestampTz t, const Set *s)
 Return true if a timestamptz is not before a set. More...
 
bool overafter_timestamptz_span (TimestampTz t, const Span *s)
 Return true if a timestamptz is not before a span. More...
 
bool overafter_timestamptz_spanset (TimestampTz t, const SpanSet *ss)
 Return true if a timestamptz is not before a span set. More...
 
bool overbefore_date_set (DateADT d, const Set *s)
 Return true if a date is not after a set. More...
 
bool overbefore_date_span (DateADT d, const Span *s)
 Return true if a date is not after a span. More...
 
bool overbefore_date_spanset (DateADT d, const SpanSet *ss)
 Return true if a date is not after a span set. More...
 
bool overbefore_set_date (const Set *s, DateADT d)
 Return true if a set is not after a date. More...
 
bool overbefore_set_timestamptz (const Set *s, TimestampTz t)
 Return true if a set is not after a timestamptz. More...
 
bool overbefore_span_date (const Span *s, DateADT d)
 Return true if a span is not after a date. More...
 
bool overbefore_span_timestamptz (const Span *s, TimestampTz t)
 Return true if a span is not after a timestamptz. More...
 
bool overbefore_spanset_date (const SpanSet *ss, DateADT d)
 Return true if a span set is not after a date. More...
 
bool overbefore_spanset_timestamptz (const SpanSet *ss, TimestampTz t)
 Return true if a span set is not after a timestamptz. More...
 
bool overbefore_timestamptz_set (TimestampTz t, const Set *s)
 Return true if a timestamptz is not after a set @csqlfn Overleft_value_set() More...
 
bool overbefore_timestamptz_span (TimestampTz t, const Span *s)
 Return true if a timestamptz is not after a span. More...
 
bool overbefore_timestamptz_spanset (TimestampTz t, const SpanSet *ss)
 Return true if a timestamptz is not after a span set. More...
 
bool overleft_bigint_set (int64 i, const Set *s)
 Return true if a big integer does not extend to the right of a set. More...
 
bool overleft_bigint_span (int64 i, const Span *s)
 Return true if a big integer does not extend to the right of a span. More...
 
bool overleft_bigint_spanset (int64 i, const SpanSet *ss)
 Return true if a big integer does not extend to the right of a span set. More...
 
bool overleft_float_set (double d, const Set *s)
 Return true if a float does not extend to the right of a set. More...
 
bool overleft_float_span (double d, const Span *s)
 Return true if a float does not extend to the right of a span. More...
 
bool overleft_float_spanset (double d, const SpanSet *ss)
 Return true if a float does not extend to the right of a span set. More...
 
bool overleft_int_set (int i, const Set *s)
 Return true if an integer does not extend to the right of a set. More...
 
bool overleft_int_span (int i, const Span *s)
 Return true if an integer does not extend to the right of a span. More...
 
bool overleft_int_spanset (int i, const SpanSet *ss)
 Return true if an integer does not extend to the right of a span set. More...
 
bool overleft_set_bigint (const Set *s, int64 i)
 Return true if a set does not extend to the right of a big integer. More...
 
bool overleft_set_float (const Set *s, double d)
 Return true if a set does not extend to the right of a float. More...
 
bool overleft_set_int (const Set *s, int i)
 Return true if a set does not extend to the right of an integer. More...
 
bool overleft_set_set (const Set *s1, const Set *s2)
 Return true if the first set does not extend to the right of the second one. More...
 
bool overleft_set_text (const Set *s, text *txt)
 Return true if a set does not extend to the right of a text. More...
 
bool overleft_span_bigint (const Span *s, int64 i)
 Return true if a span does not extend to the right of a big integer. More...
 
bool overleft_span_float (const Span *s, double d)
 Return true if a span does not extend to the right of a float. More...
 
bool overleft_span_int (const Span *s, int i)
 Return true if a span does not extend to the right of an integer. More...
 
bool overleft_span_span (const Span *s1, const Span *s2)
 Return true if the first span does not extend to the right of the second one. More...
 
bool overleft_span_spanset (const Span *s, const SpanSet *ss)
 Return true if a span does not extend to the right of a span set. More...
 
bool overleft_spanset_bigint (const SpanSet *ss, int64 i)
 Return true if a span set does not extend to the right of a big integer. More...
 
bool overleft_spanset_float (const SpanSet *ss, double d)
 Return true if a span set does not extend to the right of a float. More...
 
bool overleft_spanset_int (const SpanSet *ss, int i)
 Return true if a span set does not extend to the right of an integer. More...
 
bool overleft_spanset_span (const SpanSet *ss, const Span *s)
 Return true if a span set does not extend to the right of a span. More...
 
bool overleft_spanset_spanset (const SpanSet *ss1, const SpanSet *ss2)
 Return true if the first span set does not extend to the right of the second one. More...
 
bool overleft_text_set (const text *txt, const Set *s)
 Return true if a text does not extend to the right of a set. More...
 
bool overright_bigint_set (int64 i, const Set *s)
 Return true if a big integer does not extend to the the left of a set. More...
 
bool overright_bigint_span (int64 i, const Span *s)
 Return true if a big integer does not extend to the left of a span. More...
 
bool overright_bigint_spanset (int64 i, const SpanSet *ss)
 Return true if a big integer does not extend to the left of a span set. More...
 
bool overright_float_set (double d, const Set *s)
 Return true if a float does not extend to the left of a set. More...
 
bool overright_float_span (double d, const Span *s)
 Return true if a float does not extend to the left of a span. More...
 
bool overright_float_spanset (double d, const SpanSet *ss)
 Return true if a float does not extend to the left of a span set. More...
 
bool overright_int_set (int i, const Set *s)
 Return true if an integer does not extend to the the left of a set. More...
 
bool overright_int_span (int i, const Span *s)
 Return true if an integer does not extend to the left of a span. More...
 
bool overright_int_spanset (int i, const SpanSet *ss)
 Return true if an integer does not extend to the left of a span set. More...
 
bool overright_set_bigint (const Set *s, int64 i)
 Return true if a set does not extend to the left of a big integer. More...
 
bool overright_set_float (const Set *s, double d)
 Return true if a set does not extend to the left of a float. More...
 
bool overright_set_int (const Set *s, int i)
 Return true if a set does not extend to the left of an integer. More...
 
bool overright_set_set (const Set *s1, const Set *s2)
 Return true if the first set does not extend to the left of the second one. More...
 
bool overright_set_text (const Set *s, text *txt)
 Return true if a set does not extend to the left of a text. More...
 
bool overright_span_bigint (const Span *s, int64 i)
 Return true if a span does not extend to the left of a big integer. More...
 
bool overright_span_float (const Span *s, double d)
 Return true if a span does not extend to the left of a float. More...
 
bool overright_span_int (const Span *s, int i)
 Return true if a span does not extend to the left of an integer. More...
 
bool overright_span_span (const Span *s1, const Span *s2)
 Return true if the first span does not extend to the left of the second one. More...
 
bool overright_span_spanset (const Span *s, const SpanSet *ss)
 Return true if a span does not extend to the left of a span set. More...
 
bool overright_spanset_bigint (const SpanSet *ss, int64 i)
 Return true if a span set does not extend to the left of a big integer. More...
 
bool overright_spanset_float (const SpanSet *ss, double d)
 Return true if a span set does not extend to the left of a float. More...
 
bool overright_spanset_int (const SpanSet *ss, int i)
 Return true if a span set does not extend to the left of an integer. More...
 
bool overright_spanset_span (const SpanSet *ss, const Span *s)
 Return true if a span set does not extend to the left of a span. More...
 
bool overright_spanset_spanset (const SpanSet *ss1, const SpanSet *ss2)
 Return true if the first span set does not extend to the left of the second one. More...
 
bool overright_text_set (const text *txt, const Set *s)
 Return true if a text does not extend to the left of a set. More...
 
bool right_bigint_set (int64 i, const Set *s)
 Return true if a big integer is to the right of a set. More...
 
bool right_bigint_span (int64 i, const Span *s)
 Return true if a big integer is to the right of a span. More...
 
bool right_bigint_spanset (int64 i, const SpanSet *ss)
 Return true if a big integer is to the right of a span set. More...
 
bool right_float_set (double d, const Set *s)
 Return true if a float is to the right of a set. More...
 
bool right_float_span (double d, const Span *s)
 Return true if a float is to the right of a span. More...
 
bool right_float_spanset (double d, const SpanSet *ss)
 Return true if a float is to the right of a span set. More...
 
bool right_int_set (int i, const Set *s)
 Return true if an integer is to the right of a set. More...
 
bool right_int_span (int i, const Span *s)
 Return true if an integer is to the right of a span. More...
 
bool right_int_spanset (int i, const SpanSet *ss)
 Return true if an integer is to the right of a span set. More...
 
bool right_set_bigint (const Set *s, int64 i)
 Return true if a set is to the right of a big integer. More...
 
bool right_set_float (const Set *s, double d)
 Return true if a set is to the right of a float. More...
 
bool right_set_int (const Set *s, int i)
 Return true if a set is to the right of an integer. More...
 
bool right_set_set (const Set *s1, const Set *s2)
 Return true if the first set is to the right of the second one. More...
 
bool right_set_text (const Set *s, text *txt)
 Return true if a set is to the right of a text. More...
 
bool right_span_bigint (const Span *s, int64 i)
 Return true if a span is to the right of a big integer. More...
 
bool right_span_float (const Span *s, double d)
 Return true if a span is to the right of a float. More...
 
bool right_span_int (const Span *s, int i)
 Return true if a span is to the right of an integer. More...
 
bool right_span_span (const Span *s1, const Span *s2)
 Return true if the first span is to right the of the second one. More...
 
bool right_span_spanset (const Span *s, const SpanSet *ss)
 Return true if a span is to the right of a span set. More...
 
bool right_spanset_bigint (const SpanSet *ss, int64 i)
 Return true if a span set is to the right of a big integer. More...
 
bool right_spanset_float (const SpanSet *ss, double d)
 Return true if a span set is to the right of a float. More...
 
bool right_spanset_int (const SpanSet *ss, int i)
 Return true if a span set is to the right of an integer. More...
 
bool right_spanset_span (const SpanSet *ss, const Span *s)
 Return true if a span set is to the right of a span. More...
 
bool right_spanset_spanset (const SpanSet *ss1, const SpanSet *ss2)
 Return true if the first span set is to the right of the second one. More...
 
bool right_text_set (const text *txt, const Set *s)
 Return true if a text is to the right of a set. More...
 

Detailed Description

Position functions for set and span types.