 |
MobilityDB 1.3
|
|
MobilityDB 1.3
|
Aggregate functions for temporal types. More...
Functions | |
| Datum | Tbool_tand_combinefn (PG_FUNCTION_ARGS) |
| Combine function for temporal and aggregation of temporal booleans @sqlfn tAnd() More... | |
| Datum | Tbool_tand_transfn (PG_FUNCTION_ARGS) |
| Transition function for temporal and aggregation of temporal booleans @sqlfn tAnd() More... | |
| Datum | Tbool_tor_combinefn (PG_FUNCTION_ARGS) |
| Combine function for temporal or aggregation of temporal booleans @sqlfn tOr() More... | |
| Datum | Tbool_tor_transfn (PG_FUNCTION_ARGS) |
| Transition function for temporal or aggregation of temporal booleans @sqlfn tOr() More... | |
| Datum | Temporal_app_tinst_transfn (PG_FUNCTION_ARGS) |
| Transition function for append temporal instant aggregate @sqlfn appendInstant() More... | |
| Datum | Temporal_app_tseq_transfn (PG_FUNCTION_ARGS) |
| Transition function for append temporal sequence aggregate @sqlfn appendSequence() More... | |
| Datum | Temporal_append_finalfn (PG_FUNCTION_ARGS) |
| Final function for append temporal instant/sequence aggregate @sqlfn appendInstant(), appendSequence() More... | |
| Datum | Temporal_extent_transfn (PG_FUNCTION_ARGS) |
| Transition function for extent aggregation of temporal booleans and temporal texts @sqlfn extent() More... | |
| Datum | Temporal_merge_combinefn (PG_FUNCTION_ARGS) |
| Combine function for merge aggregate of temporal values @sqlfn merge() More... | |
| Datum | Temporal_merge_transfn (PG_FUNCTION_ARGS) |
| Transition function for merge aggregate of temporal values @sqlfn merge() More... | |
| Datum | Temporal_tagg_finalfn (PG_FUNCTION_ARGS) |
| Generic final function for temporal aggregation @sqlfn tCount(), merge(), ... More... | |
| Datum | Temporal_tcount_combinefn (PG_FUNCTION_ARGS) |
| Combine function for temporal count aggregation of temporal values @sqlfn tCount() More... | |
| Datum | Temporal_tcount_transfn (PG_FUNCTION_ARGS) |
| Transition function for temporal count aggregation of temporal values @sqlfn tCount() More... | |
| Datum | Temporal_wcount_transfn (PG_FUNCTION_ARGS) |
| Transition function for moving window count aggregation for temporal values @sqlfn wCount() More... | |
| Datum | Tfloat_tmax_combinefn (PG_FUNCTION_ARGS) |
| Combine function for temporal maximum aggregation of temporal floats values @sqlfn tMax() More... | |
| Datum | Tfloat_tmax_transfn (PG_FUNCTION_ARGS) |
| Transition function for temporal maximum aggregation of temporal floats @sqlfn tMax() More... | |
| Datum | Tfloat_tmin_combinefn (PG_FUNCTION_ARGS) |
| Combine function for temporal minimum aggregation of temporal floats @sqlfn tMin() More... | |
| Datum | Tfloat_tmin_transfn (PG_FUNCTION_ARGS) |
| Transition function for temporal minimum aggregation of temporal floats @sqlfn tMin() More... | |
| Datum | Tfloat_tsum_combinefn (PG_FUNCTION_ARGS) |
| Combine function for temporal sum aggregation of temporal floats @sqlfn tSum() More... | |
| Datum | Tfloat_tsum_transfn (PG_FUNCTION_ARGS) |
| Transition function for temporal sum aggregation of temporal floats @sqlfn tSum() More... | |
| Datum | Tfloat_wmax_transfn (PG_FUNCTION_ARGS) |
| Transition function for moving window maximun aggregation for temporal floats @sqlfn wMax() More... | |
| Datum | Tfloat_wmin_transfn (PG_FUNCTION_ARGS) |
| Transition function for moving window minimun aggregation for temporal floats @sqlfn wMin() More... | |
| Datum | Tfloat_wsum_transfn (PG_FUNCTION_ARGS) |
| Transition function for moving window sum aggregation for temporal floats @sqlfn wSum() More... | |
| Datum | Timestamptz_tcount_transfn (PG_FUNCTION_ARGS) |
| Transition function for temporal count aggregate of timestamptz values @sqlfn tCount() More... | |
| Datum | Tint_tmax_combinefn (PG_FUNCTION_ARGS) |
| Combine function for temporal maximum aggregation of temporal integers @sqlfn tMax() More... | |
| Datum | Tint_tmax_transfn (PG_FUNCTION_ARGS) |
| Transition function for temporal maximum aggregation of temporal integers @sqlfn tMax() More... | |
| Datum | Tint_tmin_combinefn (PG_FUNCTION_ARGS) |
| Combine function for temporal minimum aggregation of temporal integers @sqlfn tMin() More... | |
| Datum | Tint_tmin_transfn (PG_FUNCTION_ARGS) |
| Transition function for temporal minimum aggregation of temporal integers @sqlfn tMin() More... | |
| Datum | Tint_tsum_combinefn (PG_FUNCTION_ARGS) |
| Combine function for temporal sum aggregation of temporal integers @sqlfn tSum() More... | |
| Datum | Tint_tsum_transfn (PG_FUNCTION_ARGS) |
| Transition function for temporal sum aggregation of temporal integers @sqlfn tSum() More... | |
| Datum | Tint_wmax_transfn (PG_FUNCTION_ARGS) |
| Transition function for moving window maximun aggregation for temporal integers @sqlfn wMax() More... | |
| Datum | Tint_wmin_transfn (PG_FUNCTION_ARGS) |
| Transition function for moving window minimun aggregation for temporal integers @sqlfn wMin() More... | |
| Datum | Tint_wsum_transfn (PG_FUNCTION_ARGS) |
| Transition function for moving window sum aggregation for temporal integers @sqlfn wSum() More... | |
| Datum | Tnumber_extent_transfn (PG_FUNCTION_ARGS) |
| Transition function for extent aggregation for temporal numbers @sqlfn extent() More... | |
| Datum | Tnumber_tavg_combinefn (PG_FUNCTION_ARGS) |
| Combine function for temporal average aggregation of temporal numbers @sqlfn tAvg() More... | |
| Datum | Tnumber_tavg_finalfn (PG_FUNCTION_ARGS) |
| Final function for temporal average aggregation of temporal numbers @sqlfn tAvg() More... | |
| Datum | Tnumber_tavg_transfn (PG_FUNCTION_ARGS) |
| Transition function for temporal average aggregation of temporal numbers @sqlfn tAvg() More... | |
| Datum | Tnumber_twavg (PG_FUNCTION_ARGS) |
| Return the time-weighted average of a temporal number @sqlfn twAvg() More... | |
| Datum | Tnumber_wavg_transfn (PG_FUNCTION_ARGS) |
| Transition function for moving window average aggregation for temporal numbers @sqlfn wAvg() More... | |
| Datum | Tstzset_tcount_transfn (PG_FUNCTION_ARGS) |
| Transition function for temporal count aggregate of timestamptz sets @sqlfn tCount() More... | |
| Datum | Tstzspan_tcount_transfn (PG_FUNCTION_ARGS) |
| Transition function for temporal count aggregate of timestamptz spans @sqlfn tCount() More... | |
| Datum | Tstzspanset_tcount_transfn (PG_FUNCTION_ARGS) |
| Transition function for temporal count aggregate of timestamptz span sets @sqlfn tCount() More... | |
| Datum | Ttext_tmax_combinefn (PG_FUNCTION_ARGS) |
| Combine function for temporal maximum aggregation of temporal texts @sqlfn tMax() More... | |
| Datum | Ttext_tmax_transfn (PG_FUNCTION_ARGS) |
| Transition function for temporal maximum aggregation of temporal texts @sqlfn tMax() More... | |
| Datum | Ttext_tmin_combinefn (PG_FUNCTION_ARGS) |
| Combine function for temporal minimum aggregation of temporal texts @sqlfn tMin() More... | |
| Datum | Ttext_tmin_transfn (PG_FUNCTION_ARGS) |
| Transition function for temporal minimum aggregation of temporal texts @sqlfn tMin() More... | |
Aggregate functions for temporal types.
1.9.5