|
MobilityDB 1.3
|
Operators for span types. More...
#include <postgres.h>#include <utils/timestamp.h>#include <meos.h>#include <meos_internal.h>#include "temporal/span.h"#include "pg_temporal/meos_catalog.h"Functions | |
| Datum | Adjacent_span_span (PG_FUNCTION_ARGS) |
| Return true if two spans are adjacent @sqlfn span_adjacent() More... | |
| Datum | Adjacent_span_value (PG_FUNCTION_ARGS) |
| Return true if a span and a value are adjacent @sqlfn span_adjacent() More... | |
| Datum | Adjacent_value_span (PG_FUNCTION_ARGS) |
| Return true if a value and a span are adjacent @sqlfn span_adjacent() More... | |
| Datum | Contained_span_span (PG_FUNCTION_ARGS) |
| Return true if the first span is contained in the second one @sqlfn span_contained() More... | |
| Datum | Contained_value_span (PG_FUNCTION_ARGS) |
| Return true if a value is contained in a span @sqlfn span_contained() More... | |
| Datum | Contains_span_span (PG_FUNCTION_ARGS) |
| Return true if the first span contains the second one @sqlfn span_contains() More... | |
| Datum | Contains_span_value (PG_FUNCTION_ARGS) |
| Return true if a span contains a value @sqlfn span_contains() More... | |
| Datum | Distance_span_span (PG_FUNCTION_ARGS) |
| Return the distance between two spans @sqlfn span_distance() More... | |
| Datum | Distance_span_value (PG_FUNCTION_ARGS) |
| Return the distance between a span and a value @sqlfn span_distance() More... | |
| Datum | Distance_value_span (PG_FUNCTION_ARGS) |
| Return the distance between a value and a span @sqlfn span_distance() More... | |
| Datum | Distance_value_value (PG_FUNCTION_ARGS) |
| Return the distance between two values @sqlfn span_distance() More... | |
| Datum | Intersection_span_span (PG_FUNCTION_ARGS) |
| Return the intersection of two spans @sqlfn span_intersection() More... | |
| Datum | Intersection_span_value (PG_FUNCTION_ARGS) |
| Return the intersection of a span and a value @sqlfn span_intersection() More... | |
| Datum | Intersection_value_span (PG_FUNCTION_ARGS) |
| Return the intersection of a value and a span @sqlfn span_intersection() More... | |
| Datum | Left_span_span (PG_FUNCTION_ARGS) |
| Return true if the first span is to the left of the second one @sqlfn span_left() More... | |
| Datum | Left_span_value (PG_FUNCTION_ARGS) |
| Return true if a span is to the left of a value @sqlfn span_left() More... | |
| Datum | Left_value_span (PG_FUNCTION_ARGS) |
| Return true if a value is to the left of a span @sqlfn span_left() More... | |
| Datum | Minus_span_span (PG_FUNCTION_ARGS) |
| Return the difference of two spans @sqlfn time_minus() More... | |
| Datum | Minus_span_value (PG_FUNCTION_ARGS) |
| Return the difference of a span and a value @sqlfn span_intersection() More... | |
| Datum | Minus_value_span (PG_FUNCTION_ARGS) |
| Return the difference of a value and a span @sqlfn span_intersection() More... | |
| Datum | Overlaps_span_span (PG_FUNCTION_ARGS) |
| Return true if two spans overlap @sqlfn span_overlaps() More... | |
| Datum | Overleft_span_span (PG_FUNCTION_ARGS) |
| Return true if the first span does not extend to the right of the second one @sqlfn span_overleft() More... | |
| Datum | Overleft_span_value (PG_FUNCTION_ARGS) |
| Return true if a span does not extend to the right of a value @sqlfn span_overleft() More... | |
| Datum | Overleft_value_span (PG_FUNCTION_ARGS) |
| Return true if a value does not extend to the right of a span @sqlfn span_overleft() More... | |
| Datum | Overright_span_span (PG_FUNCTION_ARGS) |
| Return true if the first span does not extend to the left of the second one @sqlfn span_overright() More... | |
| Datum | Overright_span_value (PG_FUNCTION_ARGS) |
| Return true if a span does not extend to the left of a value @sqlfn span_overright() More... | |
| Datum | Overright_value_span (PG_FUNCTION_ARGS) |
| Return true if a value does not extend to the left of a span @sqlfn span_overright() More... | |
| Datum | Right_span_span (PG_FUNCTION_ARGS) |
| Return true if the first span is to the right of the second one @sqlfn span_right() More... | |
| Datum | Right_span_value (PG_FUNCTION_ARGS) |
| Return true if a span is to the right of a value @sqlfn span_right() More... | |
| Datum | Right_value_span (PG_FUNCTION_ARGS) |
| Return true if a value is to the right of a span @sqlfn span_right() More... | |
| Datum | Union_span_span (PG_FUNCTION_ARGS) |
| Return the union of two spans @sqlfn time_union() More... | |
| Datum | Union_span_value (PG_FUNCTION_ARGS) |
| Return the union of a span and a value @sqlfn time_union() More... | |
| Datum | Union_value_span (PG_FUNCTION_ARGS) |
| Return the union of a value and a span @sqlfn time_union() More... | |
Operators for span types.