MobilityDB 1.1
Functions

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

Collaboration diagram for Set functions:

Functions

Spanbbox_union_span_span (const Span *s1, const Span *s2)
 Return the union of the spans. More...
 
bool intersection_bigintset_bigint (const Set *s, int64 i, int64 *result)
 Return the intersection of a set and a value. More...
 
bool intersection_bigintspan_bigint (const Span *s, int64 i, int64 *result)
 Return the intersection of a span and a value. More...
 
bool intersection_bigintspanset_bigint (const SpanSet *ss, int64 i, int64 *result)
 Return the intersection of a span set and a value. More...
 
bool intersection_floatset_float (const Set *s, double d, double *result)
 Return the intersection of a set and a value. More...
 
bool intersection_floatspan_float (const Span *s, double d, double *result)
 Return the intersection of a span and a value. More...
 
bool intersection_floatspanset_float (const SpanSet *ss, double d, double *result)
 Return the intersection of a span set and a value. More...
 
bool intersection_intset_int (const Set *s, int i, int *result)
 Return the intersection of a set and a value. More...
 
bool intersection_intspan_int (const Span *s, int i, int *result)
 Return the intersection of a span and a value. More...
 
bool intersection_intspanset_int (const SpanSet *ss, int i, int *result)
 Return the intersection of a span set and a value. More...
 
bool intersection_period_timestamp (const Span *p, TimestampTz t, TimestampTz *result)
 Return the intersection of a period and a timestamp. More...
 
bool intersection_periodset_timestamp (const SpanSet *ps, TimestampTz t, TimestampTz *result)
 Return the intersection of a period set and a timestamp. More...
 
Setintersection_set_set (const Set *s1, const Set *s2)
 Return the intersection of two sets. More...
 
Spanintersection_span_span (const Span *s1, const Span *s2)
 Return the intersection of two spans. More...
 
SpanSetintersection_spanset_span (const SpanSet *ss, const Span *s)
 Return the intersection of a span set and a span. More...
 
SpanSetintersection_spanset_spanset (const SpanSet *ss1, const SpanSet *ss2)
 Return the intersection of two span sets. More...
 
bool intersection_textset_text (const Set *s, const text *txt, text **result)
 Return the intersection of a set and a value. More...
 
bool intersection_timestampset_timestamp (const Set *ts, TimestampTz t, TimestampTz *result)
 Return the intersection of a timestamp set and a timestamp. More...
 
bool minus_bigint_bigintset (int64 i, const Set *s, int64 *result)
 Return the difference of a value and a set. More...
 
bool minus_bigint_bigintspan (int64 i, const Span *s, int64 *result)
 Return the difference of a value and a span. More...
 
bool minus_bigint_bigintspanset (int64 i, const SpanSet *ss, int64 *result)
 Return the difference of a value and a span set. More...
 
Setminus_bigintset_bigint (const Set *s, int64 i)
 Return the difference of a set and a value. More...
 
SpanSetminus_bigintspan_bigint (const Span *s, int64 i)
 Return the difference of a span and a value. More...
 
SpanSetminus_bigintspanset_bigint (const SpanSet *ss, int64 i)
 Return the difference of a span set and a value. More...
 
bool minus_float_floatset (double d, const Set *s, double *result)
 Return the intersection of a value and a span set. More...
 
bool minus_float_floatspan (double d, const Span *s, double *result)
 Return the difference of a value and a span. More...
 
bool minus_float_floatspanset (double d, const SpanSet *ss, double *result)
 Return the difference of a value and a span set. More...
 
Setminus_floatset_float (const Set *s, double d)
 Return the difference of a set and a value. More...
 
SpanSetminus_floatspan_float (const Span *s, double d)
 Return the difference of a span and a value. More...
 
SpanSetminus_floatspanset_float (const SpanSet *ss, double d)
 Return the difference of a span set and a value. More...
 
bool minus_int_intset (int i, const Set *s, int *result)
 Return the difference of a value and a set. More...
 
bool minus_int_intspan (int i, const Span *s, int *result)
 Return the difference of a value and a span. More...
 
bool minus_int_intspanset (int i, const SpanSet *ss, int *result)
 Return the difference of a value and a span set. More...
 
Setminus_intset_int (const Set *s, int i)
 Return the difference of a set and a value. More...
 
SpanSetminus_intspan_int (const Span *s, int i)
 Return the difference of a span and a value. More...
 
SpanSetminus_intspanset_int (const SpanSet *ss, int i)
 Return the difference of a span set and a value. More...
 
SpanSetminus_period_timestamp (const Span *p, TimestampTz t)
 Return the difference of a period and a timestamp. More...
 
SpanSetminus_periodset_timestamp (const SpanSet *ps, TimestampTz t)
 Return the difference of a period set and a timestamp. More...
 
Setminus_set_set (const Set *s1, const Set *s2)
 Return the difference of two sets. More...
 
SpanSetminus_span_span (const Span *s1, const Span *s2)
 Return the difference of two spans. More...
 
SpanSetminus_span_spanset (const Span *s, const SpanSet *ss)
 Return the difference of a span and a span set. More...
 
SpanSetminus_spanset_span (const SpanSet *ss, const Span *s)
 Return the difference of a span set and a span. More...
 
SpanSetminus_spanset_spanset (const SpanSet *ss1, const SpanSet *ss2)
 Return the difference of two span sets. More...
 
bool minus_text_textset (const text *txt, const Set *s, text **result)
 Return the intersection of a value and a span set. More...
 
Setminus_textset_text (const Set *s, const text *txt)
 Return the difference of a set and a value. More...
 
bool minus_timestamp_period (TimestampTz t, const Span *p, TimestampTz *result)
 Return the difference of a timestamp and a period. More...
 
bool minus_timestamp_periodset (TimestampTz t, const SpanSet *ps, TimestampTz *result)
 Return the difference of a timestamp and a period set. More...
 
Setminus_timestampset_timestamp (const Set *ts, TimestampTz t)
 Return the difference of a timestamp set and a timestamp. More...
 
bool union_bigintset_bigint (const Set *s, int64 i)
 Return the union of a set and a value. More...
 
bool union_bigintspan_bigint (const Span *s, int64 i)
 Return the union of a span and a value. More...
 
bool union_bigintspanset_bigint (const SpanSet *ss, int64 i)
 Return the union of a span set and a value. More...
 
bool union_floatset_float (const Set *s, double d)
 Return the union of a set and a value. More...
 
bool union_floatspan_float (const Span *s, double d)
 Return the union of a span and a value. More...
 
bool union_floatspanset_float (const SpanSet *ss, double d)
 Return the union of a span set and a value. More...
 
bool union_intset_int (const Set *s, int i)
 Return the union of a set and a value. More...
 
bool union_intspan_int (const Span *s, int i)
 Return the union of a span and a value. More...
 
bool union_intspanset_int (const SpanSet *ss, int i)
 Return the union of a span set and a value. More...
 
SpanSetunion_period_timestamp (const Span *p, TimestampTz t)
 Return the union of a period and a timestamp. More...
 
SpanSetunion_periodset_timestamp (SpanSet *ps, TimestampTz t)
 Return the union of a period set and a timestamp. More...
 
Setunion_set_set (const Set *s1, const Set *s2)
 Return the union of two sets. More...
 
SpanSetunion_span_span (const Span *s1, const Span *s2)
 Return the union of two spans. More...
 
SpanSetunion_spanset_span (const SpanSet *ss, const Span *s)
 Return the union of a span set and a span. More...
 
SpanSetunion_spanset_spanset (const SpanSet *ss1, const SpanSet *ss2)
 Return the union of two span sets. More...
 
bool union_textset_text (const Set *s, text *txt)
 Return the union of a set and a value. More...
 
Setunion_timestamp_timestampset (const TimestampTz t, const Set *ts)
 Return the union of a timestamp and a timestamp set. More...
 
Setunion_timestampset_timestamp (const Set *ts, const TimestampTz t)
 Return the union of a timestamp set and a timestamp. More...
 

Detailed Description

Set functions for set and span types.