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

Bin and tile functions for temporal types. More...

#include "temporal/temporal_tile.h"
#include <assert.h>
#include <postgres.h>
#include <utils/array.h>
#include <funcapi.h>
#include <meos.h>
#include <meos_internal.h>
#include "temporal/span.h"
#include "temporal/tbox.h"
#include "temporal/temporal.h"
#include "temporal/type_util.h"
#include "geo/tgeo_spatialfuncs.h"
#include "pg_temporal/meos_catalog.h"
#include "pg_temporal/type_util.h"

Functions

Datum Date_bin (PG_FUNCTION_ARGS)
 Return a span bin in a bin list for date spans @sqlfn getTimeBin() More...
 
bool span_bin_state_get (SpanBinState *state, Span *span)
 Get the current bin of the bins. More...
 
SpanBinStatespan_bin_state_make (const void *to_split, const Span *s, Datum size, Datum origin)
 Create the initial state for tiling operations. More...
 
void span_bin_state_next (SpanBinState *state)
 Increment the current state to the next bin of the bins. More...
 
void span_bin_state_set (Datum lower, Datum size, meosType basetype, meosType spantype, Span *span)
 Generate an integer or float span bin from a bin list. More...
 
Datum Span_bins (PG_FUNCTION_ARGS)
 Return an array of spans obtained by splitting a span with respect to value or time bins @sqlfn bins() More...
 
Datum Spanset_bins (PG_FUNCTION_ARGS)
 Return an array of spans obtained by splitting a spanset with respect to value or time bins @sqlfn bins() More...
 
Datum Tbox_get_time_tile (PG_FUNCTION_ARGS)
 Return a tile in a multidimensional grid for temporal numbers @sqlfn tile() More...
 
Datum Tbox_get_value_tile (PG_FUNCTION_ARGS)
 Return a tile in a multidimensional grid for temporal numbers @sqlfn tile() More...
 
Datum Tbox_get_value_time_tile (PG_FUNCTION_ARGS)
 Return a tile in a multidimensional grid for temporal numbers @sqlfn tile() More...
 
Datum Tbox_get_value_time_tile_ext (FunctionCallInfo fcinfo, bool valuetile, bool timetile)
 Return a tile in a multidimensional grid for temporal numbers (external function) More...
 
Datum Tbox_time_tiles (PG_FUNCTION_ARGS)
 Return the tile list of a temporal box @sqlfn valueTimeTiles() More...
 
Datum Tbox_value_tiles (PG_FUNCTION_ARGS)
 Return the tile list of a temporal box @sqlfn valueTimeTiles() More...
 
Datum Tbox_value_time_tiles (PG_FUNCTION_ARGS)
 Return the tile list of a temporal box @sqlfn valueTimeTiles() More...
 
Datum Tbox_value_time_tiles_ext (FunctionCallInfo fcinfo, bool valuetiles, bool timetiles)
 Return the tiles of a temporal box. More...
 
SpanBinStatetemporal_time_bin_init (const Temporal *temp, const Interval *duration, TimestampTz torigin, int *nbins)
 Set the state with a temporal value and a time bin for splitting or obtaining a set of spans. More...
 
Datum Temporal_time_bins (PG_FUNCTION_ARGS)
 Return the value spans of a temporal number split with respect to value bins @sqlfn timeSpans() More...
 
Datum Temporal_time_split (PG_FUNCTION_ARGS)
 Return the fragments of a temporal value split according to time bins @sqlfn timeSplit() More...
 
Datum Timestamptz_bin (PG_FUNCTION_ARGS)
 Return a span bin in a bin list for timestamptz spans @sqlfn getTimeBin() More...
 
Datum Tnumber_time_boxes (PG_FUNCTION_ARGS)
 Return the temporal boxes of a temporal number split with respect to time bins @sqlfn timeBoxes() More...
 
Datum Tnumber_value_bins (PG_FUNCTION_ARGS)
 Return the value spans of a temporal number split with respect to value bins @sqlfn valueSpans() More...
 
Datum Tnumber_value_boxes (PG_FUNCTION_ARGS)
 Return the temporal boxes of a temporal number split with respect to value bins @sqlfn valueBoxes() More...
 
Datum Tnumber_value_split (PG_FUNCTION_ARGS)
 Return the fragments of a temporal number split according to value bins @sqlfn valueSplit() More...
 
Datum Tnumber_value_time_boxes (PG_FUNCTION_ARGS)
 Return the temporal boxes of a temporal number split with respect to a value and time grid @sqlfn valueTimeBoxes() More...
 
Datum Tnumber_value_time_boxes_ext (FunctionCallInfo fcinfo, bool valueboxes, bool timeboxes)
 Return the temporal boxes of a temporal number split with respect to a value and/or time grid (external function) More...
 
Datum Tnumber_value_time_split (PG_FUNCTION_ARGS)
 Return the fragments of a temporal number split according to value and time bins @sqlfn valueTimeSplit() More...
 
Datum Tnumber_value_time_split_ext (FunctionCallInfo fcinfo, bool valuesplit, bool timesplit)
 Return the fragments of a temporal number split according to value and time bins. More...
 
Datum Value_bin (PG_FUNCTION_ARGS)
 Return a span bin in a bin list for number spans @sqlfn getValueBin() More...
 

Detailed Description

Bin and tile functions for temporal types.

Note
The time bin functions are inspired from TimescaleDB. https://docs.timescale.com/latest/api#time_bucket