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

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

Functions

Setintersection_bigint_set (int64 i, const Set *s)
 Return the intersection of a big integer and a set. More...
 
Setintersection_date_set (const DateADT d, const Set *s)
 Return the intersection of a date and a set. More...
 
Setintersection_float_set (double d, const Set *s)
 Return the intersection of a float and a set. More...
 
Setintersection_int_set (int i, const Set *s)
 Return the intersection of an integer and a set. More...
 
Setintersection_set_bigint (const Set *s, int64 i)
 Return the intersection of a set and a big integer. More...
 
Setintersection_set_date (const Set *s, DateADT d)
 Return the intersection of a set and a date. More...
 
Setintersection_set_float (const Set *s, double d)
 Return the intersection of a set and a float. More...
 
Setintersection_set_int (const Set *s, int i)
 Return the intersection of a set and an integer. More...
 
Setintersection_set_set (const Set *s1, const Set *s2)
 Return the intersection of two sets. More...
 
Setintersection_set_text (const Set *s, const text *txt)
 Return the intersection of a set and a text. More...
 
Setintersection_set_timestamptz (const Set *s, TimestampTz t)
 Return the intersection of a set and a timestamptz. More...
 
Spanintersection_span_bigint (const Span *s, int64 i)
 Return the intersection of a span and a big integer. More...
 
Spanintersection_span_date (const Span *s, DateADT d)
 Return the intersection of a span and a date. More...
 
Spanintersection_span_float (const Span *s, double d)
 Return the intersection of a span and a float. More...
 
Spanintersection_span_int (const Span *s, int i)
 Return the intersection of a span and an integer. More...
 
Spanintersection_span_span (const Span *s1, const Span *s2)
 Return the intersection of two spans. More...
 
SpanSetintersection_span_spanset (const Span *s, const SpanSet *ss)
 Return the intersection of a span and a span set. More...
 
Spanintersection_span_timestamptz (const Span *s, TimestampTz t)
 Return the intersection of a span and a timestamptz. More...
 
SpanSetintersection_spanset_bigint (const SpanSet *ss, int64 i)
 Return the intersection of a span set and a big integer. More...
 
SpanSetintersection_spanset_date (const SpanSet *ss, DateADT d)
 Return the intersection of a span set and a date. More...
 
SpanSetintersection_spanset_float (const SpanSet *ss, double d)
 Return the intersection of a span set and a float. More...
 
SpanSetintersection_spanset_int (const SpanSet *ss, int i)
 Return the intersection of a span set and an integer. 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...
 
SpanSetintersection_spanset_timestamptz (const SpanSet *ss, TimestampTz t)
 Return the intersection of a span set and a timestamptz. More...
 
Setintersection_text_set (const text *txt, const Set *s)
 Return the intersection of a text and a set. More...
 
Setintersection_timestamptz_set (const TimestampTz t, const Set *s)
 Return the intersection of a timestamptz and a set. More...
 
Setminus_bigint_set (int64 i, const Set *s)
 Return the difference of a big integer and a set. More...
 
SpanSetminus_bigint_span (int64 i, const Span *s)
 Return the difference of a big integer and a span. More...
 
SpanSetminus_bigint_spanset (int64 i, const SpanSet *ss)
 Return the difference of a big integer and a span set. More...
 
Setminus_date_set (DateADT d, const Set *s)
 Return the difference of a date and a set. More...
 
SpanSetminus_date_span (DateADT d, const Span *s)
 Return the difference of a date and a span. More...
 
SpanSetminus_date_spanset (DateADT d, const SpanSet *ss)
 Return the difference of a date and a span set. More...
 
Setminus_float_set (double d, const Set *s)
 Return the difference of a float and a set. More...
 
SpanSetminus_float_span (double d, const Span *s)
 Return the difference of a float and a span. More...
 
SpanSetminus_float_spanset (double d, const SpanSet *ss)
 Return the difference of a float and a span set. More...
 
Setminus_int_set (int i, const Set *s)
 Return the difference of an integer and a set. More...
 
SpanSetminus_int_span (int i, const Span *s)
 Return the difference of an integer and a span. More...
 
SpanSetminus_int_spanset (int i, const SpanSet *ss)
 Return the difference of an integer and a span set. More...
 
Setminus_set_bigint (const Set *s, int64 i)
 Return the difference of a set and a big integer. More...
 
Setminus_set_date (const Set *s, DateADT d)
 Return the difference of a set and a date. More...
 
Setminus_set_float (const Set *s, double d)
 Return the difference of a set and a float. More...
 
Setminus_set_int (const Set *s, int i)
 Return the difference of a set and an integer. More...
 
Setminus_set_set (const Set *s1, const Set *s2)
 Return the difference of two sets. More...
 
Setminus_set_text (const Set *s, const text *txt)
 Return the difference of a set and a text. More...
 
Setminus_set_timestamptz (const Set *s, TimestampTz t)
 Return the difference of a set and a timestamptz. More...
 
SpanSetminus_span_bigint (const Span *s, int64 i)
 Return the difference of a span and a big integer. More...
 
SpanSetminus_span_date (const Span *s, DateADT d)
 Return the difference of a span and a date. More...
 
SpanSetminus_span_float (const Span *s, double d)
 Return the difference of a span and a float. More...
 
SpanSetminus_span_int (const Span *s, int i)
 Return the difference of a span and an integer. 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_span_timestamptz (const Span *s, TimestampTz t)
 Return the difference of a span and a timestamptz. More...
 
SpanSetminus_spanset_bigint (const SpanSet *ss, int64 i)
 Return the difference of a span set and a big integer. More...
 
SpanSetminus_spanset_date (const SpanSet *ss, DateADT d)
 Return the difference of a span set and a date. More...
 
SpanSetminus_spanset_float (const SpanSet *ss, double d)
 Return the difference of a span set and a float. More...
 
SpanSetminus_spanset_int (const SpanSet *ss, int i)
 Return the difference of a span set and an integer. 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...
 
SpanSetminus_spanset_timestamptz (const SpanSet *ss, TimestampTz t)
 Return the difference of a span set and a timestamptz. More...
 
Setminus_text_set (const text *txt, const Set *s)
 Return the difference of a text and a set. More...
 
Setminus_timestamptz_set (TimestampTz t, const Set *s)
 Return the difference of a timestamptz and a set. More...
 
SpanSetminus_timestamptz_span (TimestampTz t, const Span *s)
 Return the difference of a timestamptz and a span. More...
 
SpanSetminus_timestamptz_spanset (TimestampTz t, const SpanSet *ss)
 Return the difference of a timestamptz and a span set. More...
 
Setunion_bigint_set (int64 i, const Set *s)
 Return the union of a big integer and a set. More...
 
SpanSetunion_bigint_span (const Span *s, int64 i)
 Return the union of a big integer and a span. More...
 
SpanSetunion_bigint_spanset (int64 i, SpanSet *ss)
 Return the union of a span set and a big integer. More...
 
Setunion_date_set (const DateADT d, const Set *s)
 Return the union of a date and a set. More...
 
SpanSetunion_date_span (const Span *s, DateADT d)
 Return the union of a date and a span. More...
 
SpanSetunion_date_spanset (DateADT d, SpanSet *ss)
 Return the union of a span set and a date. More...
 
Setunion_float_set (double d, const Set *s)
 Return the union of a float and a set. More...
 
SpanSetunion_float_span (const Span *s, double d)
 Return the union of a float and a span. More...
 
SpanSetunion_float_spanset (double d, SpanSet *ss)
 Return the union of a span set and a float. More...
 
Setunion_int_set (int i, const Set *s)
 Return the union of an integer and a set. More...
 
SpanSetunion_int_span (int i, const Span *s)
 Return the union of an integer and a span. More...
 
SpanSetunion_int_spanset (int i, SpanSet *ss)
 Return the union of a span set and an integer. More...
 
Setunion_set_bigint (const Set *s, int64 i)
 Return the union of a set and a big integer. More...
 
Setunion_set_date (const Set *s, const DateADT d)
 Return the union of a set and a date. More...
 
Setunion_set_float (const Set *s, double d)
 Return the union of a set and a float. More...
 
Setunion_set_int (const Set *s, int i)
 Return the union of a set and an integer. More...
 
Setunion_set_set (const Set *s1, const Set *s2)
 Return the union of two sets. More...
 
Setunion_set_text (const Set *s, const text *txt)
 Return the union of a set and a text. More...
 
Setunion_set_timestamptz (const Set *s, const TimestampTz t)
 Return the union of a set and a timestamptz. More...
 
SpanSetunion_span_bigint (const Span *s, int64 i)
 Return the union of a span and a big integer. More...
 
SpanSetunion_span_date (const Span *s, DateADT d)
 Return the union of a span and a date. More...
 
SpanSetunion_span_float (const Span *s, double d)
 Return the union of a span and a float. More...
 
SpanSetunion_span_int (const Span *s, int i)
 Return the union of a span and an integer. More...
 
SpanSetunion_span_span (const Span *s1, const Span *s2)
 Return the union of two spans. More...
 
SpanSetunion_span_spanset (const Span *s, const SpanSet *ss)
 Return the union of a span and a span set. More...
 
SpanSetunion_span_timestamptz (const Span *s, TimestampTz t)
 Return the union of a span and a timestamptz. More...
 
SpanSetunion_spanset_bigint (const SpanSet *ss, int64 i)
 Return the union of a span set and a big integer. More...
 
SpanSetunion_spanset_date (const SpanSet *ss, DateADT d)
 Return the union of a span set and a date. More...
 
SpanSetunion_spanset_float (const SpanSet *ss, double d)
 Return the union of a span set and a float. More...
 
SpanSetunion_spanset_int (const SpanSet *ss, int i)
 Return the union of a span set and an integer. 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...
 
SpanSetunion_spanset_timestamptz (const SpanSet *ss, TimestampTz t)
 Return the union of a span set and a timestamptz. More...
 
Setunion_text_set (const text *txt, const Set *s)
 Return the union of a text and a set. More...
 
Setunion_timestamptz_set (const TimestampTz t, const Set *s)
 Return the union of a timestamptz and a set. More...
 
SpanSetunion_timestamptz_span (TimestampTz t, const Span *s)
 Return the union of a timestamptz and a span. More...
 
SpanSetunion_timestamptz_spanset (TimestampTz t, SpanSet *ss)
 Return the union of a span set and a timestamptz. More...
 

Detailed Description

Set functions for set and span types.