![]() |
MobilityDB 1.3
|
Operators for set types. More...
#include <assert.h>
#include <postgres.h>
#include <meos.h>
#include <meos_internal.h>
#include "temporal/set.h"
#include "temporal/temporal.h"
#include "temporal/type_util.h"
Functions | |
bool | after_date_set (DateADT d, const Set *s) |
Return true if a date is after a 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_timestamptz_set (TimestampTz t, const Set *s) |
Return true if a timestamptz is after a set. More... | |
bool | before_date_set (DateADT d, const Set *s) |
Return true if a date is before a 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_timestamptz_set (TimestampTz t, const Set *s) |
Return true if a timestamptz is before a set. More... | |
bool | contained_bigint_set (int64 i, const Set *s) |
Return true if a big integer is contained in a set. More... | |
bool | contained_date_set (DateADT d, const Set *s) |
Return true if a date is contained in a set. More... | |
bool | contained_float_set (double d, const Set *s) |
Return true if a float is contained in a set. More... | |
bool | contained_int_set (int i, const Set *s) |
Return true if an integer is contained in a set. More... | |
bool | contained_text_set (const text *txt, const Set *s) |
Return true if a text is contained in a set. More... | |
bool | contained_timestamptz_set (TimestampTz t, const Set *s) |
Return true if a timestamptz is contained in a set. More... | |
bool | contains_set_bigint (const Set *s, int64 i) |
Return true if a set contains a big integer. More... | |
bool | contains_set_date (const Set *s, DateADT d) |
Return true if a set contains a date. More... | |
bool | contains_set_float (const Set *s, double d) |
Return true if a set contains a float. More... | |
bool | contains_set_int (const Set *s, int i) |
Return true if a set contains an integer. More... | |
bool | contains_set_text (const Set *s, text *txt) |
Return true if a set contains a text. More... | |
bool | contains_set_timestamptz (const Set *s, TimestampTz t) |
Return true if a set contains a timestamptz. More... | |
int64 | distance_bigintset_bigintset (const Set *s1, const Set *s2) |
Return the distance between two big integer sets. More... | |
int | distance_dateset_dateset (const Set *s1, const Set *s2) |
Return the distance in days between two date sets. More... | |
double | distance_floatset_floatset (const Set *s1, const Set *s2) |
Return the distance between two float sets. More... | |
int | distance_intset_intset (const Set *s1, const Set *s2) |
Return the distance between two integer sets. More... | |
int64 | distance_set_bigint (const Set *s, int64 i) |
Return the distance between a set and a big integer. More... | |
int | distance_set_date (const Set *s, DateADT d) |
Return the distance in days between a set and a date. More... | |
double | distance_set_float (const Set *s, double d) |
Return the distance between a set and a float. More... | |
int | distance_set_int (const Set *s, int i) |
Return the distance between a set and an integer. More... | |
double | distance_set_timestamptz (const Set *s, TimestampTz t) |
Return the distance in seconds between a set and a timestamptz as a double. More... | |
double | distance_tstzset_tstzset (const Set *s1, const Set *s2) |
Return the distance in seconds between two timestamptz sets. More... | |
Set * | intersection_bigint_set (int64 i, const Set *s) |
Return the intersection of a big integer and a set. More... | |
Set * | intersection_date_set (const DateADT d, const Set *s) |
Return the intersection of a date and a set. More... | |
Set * | intersection_float_set (double d, const Set *s) |
Return the intersection of a float and a set. More... | |
Set * | intersection_int_set (int i, const Set *s) |
Return the intersection of an integer and a set. More... | |
Set * | intersection_set_bigint (const Set *s, int64 i) |
Return the intersection of a set and a big integer. More... | |
Set * | intersection_set_date (const Set *s, DateADT d) |
Return the intersection of a set and a date. More... | |
Set * | intersection_set_float (const Set *s, double d) |
Return the intersection of a set and a float. More... | |
Set * | intersection_set_int (const Set *s, int i) |
Return the intersection of a set and an integer. More... | |
Set * | intersection_set_text (const Set *s, const text *txt) |
Return the intersection of a set and a text. More... | |
Set * | intersection_set_timestamptz (const Set *s, TimestampTz t) |
Return the intersection of a set and a timestamptz. More... | |
Set * | intersection_text_set (const text *txt, const Set *s) |
Return the intersection of a text and a set. More... | |
Set * | intersection_timestamptz_set (const TimestampTz t, const Set *s) |
Return the intersection of a timestamptz and a 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_float_set (double d, const Set *s) |
Return true if a float is to the left of a 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_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_text (const Set *s, text *txt) |
Return true if a set is to the left of a text. More... | |
bool | left_text_set (const text *txt, const Set *s) |
Return true if a text is to the left of a set. More... | |
Set * | minus_bigint_set (int64 i, const Set *s) |
Return the difference of a big integer and a set. More... | |
Set * | minus_date_set (DateADT d, const Set *s) |
Return the difference of a date and a set. More... | |
Set * | minus_float_set (double d, const Set *s) |
Return the difference of a float and a set. More... | |
Set * | minus_int_set (int i, const Set *s) |
Return the difference of an integer and a set. More... | |
Set * | minus_set_bigint (const Set *s, int64 i) |
Return the difference of a set and a big integer. More... | |
Set * | minus_set_date (const Set *s, DateADT d) |
Return the difference of a set and a date. More... | |
Set * | minus_set_float (const Set *s, double d) |
Return the difference of a set and a float. More... | |
Set * | minus_set_int (const Set *s, int i) |
Return the difference of a set and an integer. More... | |
Set * | minus_set_text (const Set *s, const text *txt) |
Return the difference of a set and a text. More... | |
Set * | minus_set_timestamptz (const Set *s, TimestampTz t) |
Return the difference of a set and a timestamptz. More... | |
Set * | minus_text_set (const text *txt, const Set *s) |
Return the difference of a text and a set. More... | |
Set * | minus_timestamptz_set (TimestampTz t, const Set *s) |
Return the difference of a timestamptz and 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_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_timestamptz_set (TimestampTz t, const Set *s) |
Return true if a timestamptz is not before a set. More... | |
bool | overbefore_date_set (DateADT d, const Set *s) |
Return true if a date is not after a 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_timestamptz_set (TimestampTz t, const Set *s) |
Return true if a timestamptz is not after a set @csqlfn Overleft_value_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_float_set (double d, const Set *s) |
Return true if a float does not extend to the right of a 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_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_text (const Set *s, text *txt) |
Return true if a set does not extend to the right of a text. 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_float_set (double d, const Set *s) |
Return true if a float does not extend to the left of a 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_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_text (const Set *s, text *txt) |
Return true if a set does not extend to the left of a text. 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_float_set (double d, const Set *s) |
Return true if a float is to the right of a 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_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_text (const Set *s, text *txt) |
Return true if a set is to the right of a text. More... | |
bool | right_text_set (const text *txt, const Set *s) |
Return true if a text is to the right of a set. More... | |
Set * | union_bigint_set (int64 i, const Set *s) |
Return the union of a big integer and a set. More... | |
Set * | union_date_set (const DateADT d, const Set *s) |
Return the union of a date and a set. More... | |
Set * | union_float_set (double d, const Set *s) |
Return the union of a float and a set. More... | |
Set * | union_int_set (int i, const Set *s) |
Return the union of an integer and a set. More... | |
Set * | union_set_bigint (const Set *s, int64 i) |
Return the union of a set and a big integer. More... | |
Set * | union_set_date (const Set *s, const DateADT d) |
Return the union of a set and a date. More... | |
Set * | union_set_float (const Set *s, double d) |
Return the union of a set and a float. More... | |
Set * | union_set_int (const Set *s, int i) |
Return the union of a set and an integer. More... | |
Set * | union_set_text (const Set *s, const text *txt) |
Return the union of a set and a text. More... | |
Set * | union_set_timestamptz (const Set *s, const TimestampTz t) |
Return the union of a set and a timestamptz. More... | |
Set * | union_text_set (const text *txt, const Set *s) |
Return the union of a text and a set. More... | |
Set * | union_timestamptz_set (const TimestampTz t, const Set *s) |
Return the union of a timestamptz and a set. More... | |
Operators for set types.