MobilityDB 1.3
Loading...
Searching...
No Matches
Functions
span_ops.c File Reference

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...
 

Detailed Description

Operators for span types.