![]() |
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.