PostgreSQL Source Code  git master
btree_ts.c File Reference
#include "postgres.h"
#include <limits.h>
#include "btree_gist.h"
#include "btree_utils_num.h"
#include "utils/builtins.h"
#include "utils/datetime.h"
#include "utils/float.h"
Include dependency graph for btree_ts.c:

Go to the source code of this file.

Data Structures

struct  tsKEY
 

Macros

#define TimestampGetDatumFast(X)   PointerGetDatum(&(X))
 
#define penalty_check_max_float(val)
 

Functions

 PG_FUNCTION_INFO_V1 (gbt_ts_compress)
 
 PG_FUNCTION_INFO_V1 (gbt_tstz_compress)
 
 PG_FUNCTION_INFO_V1 (gbt_ts_fetch)
 
 PG_FUNCTION_INFO_V1 (gbt_ts_union)
 
 PG_FUNCTION_INFO_V1 (gbt_ts_picksplit)
 
 PG_FUNCTION_INFO_V1 (gbt_ts_consistent)
 
 PG_FUNCTION_INFO_V1 (gbt_ts_distance)
 
 PG_FUNCTION_INFO_V1 (gbt_tstz_consistent)
 
 PG_FUNCTION_INFO_V1 (gbt_tstz_distance)
 
 PG_FUNCTION_INFO_V1 (gbt_ts_penalty)
 
 PG_FUNCTION_INFO_V1 (gbt_ts_same)
 
static bool gbt_tsgt (const void *a, const void *b, FmgrInfo *flinfo)
 
static bool gbt_tsge (const void *a, const void *b, FmgrInfo *flinfo)
 
static bool gbt_tseq (const void *a, const void *b, FmgrInfo *flinfo)
 
static bool gbt_tsle (const void *a, const void *b, FmgrInfo *flinfo)
 
static bool gbt_tslt (const void *a, const void *b, FmgrInfo *flinfo)
 
static int gbt_tskey_cmp (const void *a, const void *b, FmgrInfo *flinfo)
 
static float8 gbt_ts_dist (const void *a, const void *b, FmgrInfo *flinfo)
 
 PG_FUNCTION_INFO_V1 (ts_dist)
 
Datum ts_dist (PG_FUNCTION_ARGS)
 
 PG_FUNCTION_INFO_V1 (tstz_dist)
 
Datum tstz_dist (PG_FUNCTION_ARGS)
 
static Timestamp tstz_to_ts_gmt (TimestampTz ts)
 
Datum gbt_ts_compress (PG_FUNCTION_ARGS)
 
Datum gbt_tstz_compress (PG_FUNCTION_ARGS)
 
Datum gbt_ts_fetch (PG_FUNCTION_ARGS)
 
Datum gbt_ts_consistent (PG_FUNCTION_ARGS)
 
Datum gbt_ts_distance (PG_FUNCTION_ARGS)
 
Datum gbt_tstz_consistent (PG_FUNCTION_ARGS)
 
Datum gbt_tstz_distance (PG_FUNCTION_ARGS)
 
Datum gbt_ts_union (PG_FUNCTION_ARGS)
 
Datum gbt_ts_penalty (PG_FUNCTION_ARGS)
 
Datum gbt_ts_picksplit (PG_FUNCTION_ARGS)
 
Datum gbt_ts_same (PG_FUNCTION_ARGS)
 

Variables

static const gbtree_ninfo tinfo
 

Macro Definition Documentation

◆ penalty_check_max_float

#define penalty_check_max_float (   val)
Value:
do { \
if ( val > FLT_MAX ) \
val = FLT_MAX; \
if ( val < -FLT_MAX ) \
val = -FLT_MAX; \
} while(false);
long val
Definition: informix.c:664

Definition at line 348 of file btree_ts.c.

Referenced by gbt_ts_penalty().

◆ TimestampGetDatumFast

#define TimestampGetDatumFast (   X)    PointerGetDatum(&(X))

Definition at line 39 of file btree_ts.c.

Referenced by gbt_ts_dist(), gbt_tseq(), gbt_tsge(), gbt_tsgt(), gbt_tskey_cmp(), gbt_tsle(), and gbt_tslt().

Function Documentation

◆ gbt_ts_compress()

Datum gbt_ts_compress ( PG_FUNCTION_ARGS  )

Definition at line 208 of file btree_ts.c.

References gbt_num_compress(), PG_GETARG_POINTER, and PG_RETURN_POINTER.

209 {
210  GISTENTRY *entry = (GISTENTRY *) PG_GETARG_POINTER(0);
211 
213 }
#define PG_RETURN_POINTER(x)
Definition: fmgr.h:351
#define PG_GETARG_POINTER(n)
Definition: fmgr.h:271
GISTENTRY * gbt_num_compress(GISTENTRY *entry, const gbtree_ninfo *tinfo)
static const gbtree_ninfo tinfo
Definition: btree_ts.c:130

◆ gbt_ts_consistent()

Datum gbt_ts_consistent ( PG_FUNCTION_ARGS  )

Definition at line 251 of file btree_ts.c.

References DatumGetPointer, gbt_num_consistent(), GIST_LEAF, sort-test::key, GISTENTRY::key, tsKEY::lower, GBT_NUMKEY_R::lower, PG_GETARG_POINTER, PG_GETARG_TIMESTAMP, PG_GETARG_UINT16, PG_RETURN_BOOL, tsKEY::upper, and GBT_NUMKEY_R::upper.

252 {
253  GISTENTRY *entry = (GISTENTRY *) PG_GETARG_POINTER(0);
254  Timestamp query = PG_GETARG_TIMESTAMP(1);
256 
257  /* Oid subtype = PG_GETARG_OID(3); */
258  bool *recheck = (bool *) PG_GETARG_POINTER(4);
259  tsKEY *kkk = (tsKEY *) DatumGetPointer(entry->key);
261 
262  /* All cases served by this function are exact */
263  *recheck = false;
264 
265  key.lower = (GBT_NUMKEY *) &kkk->lower;
266  key.upper = (GBT_NUMKEY *) &kkk->upper;
267 
269  gbt_num_consistent(&key, (void *) &query, &strategy, GIST_LEAF(entry), &tinfo, fcinfo->flinfo)
270  );
271 }
#define GIST_LEAF(entry)
Definition: gist.h:141
const GBT_NUMKEY * lower
#define PG_GETARG_TIMESTAMP(n)
Definition: timestamp.h:35
uint16 StrategyNumber
Definition: stratnum.h:22
const GBT_NUMKEY * upper
#define PG_GETARG_POINTER(n)
Definition: fmgr.h:271
bool gbt_num_consistent(const GBT_NUMKEY_R *key, const void *query, const StrategyNumber *strategy, bool is_leaf, const gbtree_ninfo *tinfo, FmgrInfo *flinfo)
Timestamp lower
Definition: btree_ts.c:16
Definition: btree_ts.c:14
Datum key
Definition: gist.h:131
char GBT_NUMKEY
int64 Timestamp
Definition: timestamp.h:38
#define PG_RETURN_BOOL(x)
Definition: fmgr.h:349
Timestamp upper
Definition: btree_ts.c:17
#define PG_GETARG_UINT16(n)
Definition: fmgr.h:267
#define DatumGetPointer(X)
Definition: postgres.h:549
static const gbtree_ninfo tinfo
Definition: btree_ts.c:130

◆ gbt_ts_dist()

static float8 gbt_ts_dist ( const void *  a,
const void *  b,
FmgrInfo flinfo 
)
static

Definition at line 114 of file btree_ts.c.

References Abs, DatumGetIntervalP, DirectFunctionCall2, get_float8_infinity(), i, INTERVAL_TO_SEC, timestamp_mi(), TIMESTAMP_NOT_FINITE, and TimestampGetDatumFast.

115 {
116  const Timestamp *aa = (const Timestamp *) a;
117  const Timestamp *bb = (const Timestamp *) b;
118  Interval *i;
119 
121  return get_float8_infinity();
122 
125  TimestampGetDatumFast(*bb)));
126  return (float8) Abs(INTERVAL_TO_SEC(i));
127 }
#define DatumGetIntervalP(X)
Definition: timestamp.h:29
static float8 get_float8_infinity(void)
Definition: float.h:90
Datum timestamp_mi(PG_FUNCTION_ARGS)
Definition: timestamp.c:2639
#define Abs(x)
Definition: c.h:917
#define TIMESTAMP_NOT_FINITE(j)
Definition: timestamp.h:122
double float8
Definition: c.h:492
int64 Timestamp
Definition: timestamp.h:38
#define TimestampGetDatumFast(X)
Definition: btree_ts.c:39
int i
#define INTERVAL_TO_SEC(ivp)
#define DirectFunctionCall2(func, arg1, arg2)
Definition: fmgr.h:617

◆ gbt_ts_distance()

Datum gbt_ts_distance ( PG_FUNCTION_ARGS  )

Definition at line 274 of file btree_ts.c.

References DatumGetPointer, gbt_num_distance(), GIST_LEAF, sort-test::key, GISTENTRY::key, tsKEY::lower, GBT_NUMKEY_R::lower, PG_GETARG_POINTER, PG_GETARG_TIMESTAMP, PG_RETURN_FLOAT8, tsKEY::upper, and GBT_NUMKEY_R::upper.

275 {
276  GISTENTRY *entry = (GISTENTRY *) PG_GETARG_POINTER(0);
277  Timestamp query = PG_GETARG_TIMESTAMP(1);
278 
279  /* Oid subtype = PG_GETARG_OID(3); */
280  tsKEY *kkk = (tsKEY *) DatumGetPointer(entry->key);
282 
283  key.lower = (GBT_NUMKEY *) &kkk->lower;
284  key.upper = (GBT_NUMKEY *) &kkk->upper;
285 
287  gbt_num_distance(&key, (void *) &query, GIST_LEAF(entry), &tinfo, fcinfo->flinfo)
288  );
289 }
#define GIST_LEAF(entry)
Definition: gist.h:141
const GBT_NUMKEY * lower
float8 gbt_num_distance(const GBT_NUMKEY_R *key, const void *query, bool is_leaf, const gbtree_ninfo *tinfo, FmgrInfo *flinfo)
#define PG_GETARG_TIMESTAMP(n)
Definition: timestamp.h:35
#define PG_RETURN_FLOAT8(x)
Definition: fmgr.h:356
const GBT_NUMKEY * upper
#define PG_GETARG_POINTER(n)
Definition: fmgr.h:271
Timestamp lower
Definition: btree_ts.c:16
Definition: btree_ts.c:14
Datum key
Definition: gist.h:131
char GBT_NUMKEY
int64 Timestamp
Definition: timestamp.h:38
Timestamp upper
Definition: btree_ts.c:17
#define DatumGetPointer(X)
Definition: postgres.h:549
static const gbtree_ninfo tinfo
Definition: btree_ts.c:130

◆ gbt_ts_fetch()

Datum gbt_ts_fetch ( PG_FUNCTION_ARGS  )

Definition at line 243 of file btree_ts.c.

References gbt_num_fetch(), PG_GETARG_POINTER, and PG_RETURN_POINTER.

244 {
245  GISTENTRY *entry = (GISTENTRY *) PG_GETARG_POINTER(0);
246 
248 }
#define PG_RETURN_POINTER(x)
Definition: fmgr.h:351
GISTENTRY * gbt_num_fetch(GISTENTRY *entry, const gbtree_ninfo *tinfo)
#define PG_GETARG_POINTER(n)
Definition: fmgr.h:271
static const gbtree_ninfo tinfo
Definition: btree_ts.c:130

◆ gbt_ts_penalty()

Datum gbt_ts_penalty ( PG_FUNCTION_ARGS  )

Definition at line 357 of file btree_ts.c.

References DatumGetPointer, sort-test::key, tsKEY::lower, penalty_check_max_float, penalty_num, PG_GETARG_POINTER, PG_RETURN_POINTER, and tsKEY::upper.

358 {
359  tsKEY *origentry = (tsKEY *) DatumGetPointer(((GISTENTRY *) PG_GETARG_POINTER(0))->key);
360  tsKEY *newentry = (tsKEY *) DatumGetPointer(((GISTENTRY *) PG_GETARG_POINTER(1))->key);
361  float *result = (float *) PG_GETARG_POINTER(2);
362 
363  double orgdbl[2],
364  newdbl[2];
365 
366  /*
367  * We are always using "double" timestamps here. Precision should be good
368  * enough.
369  */
370  orgdbl[0] = ((double) origentry->lower);
371  orgdbl[1] = ((double) origentry->upper);
372  newdbl[0] = ((double) newentry->lower);
373  newdbl[1] = ((double) newentry->upper);
374 
375  penalty_check_max_float(orgdbl[0]);
376  penalty_check_max_float(orgdbl[1]);
377  penalty_check_max_float(newdbl[0]);
378  penalty_check_max_float(newdbl[1]);
379 
380  penalty_num(result, orgdbl[0], orgdbl[1], newdbl[0], newdbl[1]);
381 
382  PG_RETURN_POINTER(result);
383 
384 }
#define PG_RETURN_POINTER(x)
Definition: fmgr.h:351
#define PG_GETARG_POINTER(n)
Definition: fmgr.h:271
Timestamp lower
Definition: btree_ts.c:16
Definition: btree_ts.c:14
#define penalty_num(result, olower, oupper, nlower, nupper)
Timestamp upper
Definition: btree_ts.c:17
#define DatumGetPointer(X)
Definition: postgres.h:549
#define penalty_check_max_float(val)
Definition: btree_ts.c:348

◆ gbt_ts_picksplit()

Datum gbt_ts_picksplit ( PG_FUNCTION_ARGS  )

Definition at line 388 of file btree_ts.c.

References gbt_num_picksplit(), PG_GETARG_POINTER, and PG_RETURN_POINTER.

389 {
393  &tinfo, fcinfo->flinfo
394  ));
395 }
#define PG_RETURN_POINTER(x)
Definition: fmgr.h:351
#define PG_GETARG_POINTER(n)
Definition: fmgr.h:271
GIST_SPLITVEC * gbt_num_picksplit(const GistEntryVector *entryvec, GIST_SPLITVEC *v, const gbtree_ninfo *tinfo, FmgrInfo *flinfo)
static const gbtree_ninfo tinfo
Definition: btree_ts.c:130

◆ gbt_ts_same()

Datum gbt_ts_same ( PG_FUNCTION_ARGS  )

Definition at line 398 of file btree_ts.c.

References gbt_num_same(), PG_GETARG_POINTER, and PG_RETURN_POINTER.

399 {
400  tsKEY *b1 = (tsKEY *) PG_GETARG_POINTER(0);
401  tsKEY *b2 = (tsKEY *) PG_GETARG_POINTER(1);
402  bool *result = (bool *) PG_GETARG_POINTER(2);
403 
404  *result = gbt_num_same((void *) b1, (void *) b2, &tinfo, fcinfo->flinfo);
405  PG_RETURN_POINTER(result);
406 }
#define PG_RETURN_POINTER(x)
Definition: fmgr.h:351
bool gbt_num_same(const GBT_NUMKEY *a, const GBT_NUMKEY *b, const gbtree_ninfo *tinfo, FmgrInfo *flinfo)
#define PG_GETARG_POINTER(n)
Definition: fmgr.h:271
Definition: btree_ts.c:14
static const gbtree_ninfo tinfo
Definition: btree_ts.c:130

◆ gbt_ts_union()

Datum gbt_ts_union ( PG_FUNCTION_ARGS  )

Definition at line 338 of file btree_ts.c.

References gbt_num_union(), palloc(), PG_GETARG_POINTER, and PG_RETURN_POINTER.

339 {
341  void *out = palloc(sizeof(tsKEY));
342 
343  *(int *) PG_GETARG_POINTER(1) = sizeof(tsKEY);
344  PG_RETURN_POINTER(gbt_num_union((void *) out, entryvec, &tinfo, fcinfo->flinfo));
345 }
#define PG_RETURN_POINTER(x)
Definition: fmgr.h:351
#define PG_GETARG_POINTER(n)
Definition: fmgr.h:271
Definition: btree_ts.c:14
void * palloc(Size size)
Definition: mcxt.c:949
static const gbtree_ninfo tinfo
Definition: btree_ts.c:130
void * gbt_num_union(GBT_NUMKEY *out, const GistEntryVector *entryvec, const gbtree_ninfo *tinfo, FmgrInfo *flinfo)

◆ gbt_tseq()

static bool gbt_tseq ( const void *  a,
const void *  b,
FmgrInfo flinfo 
)
static

Definition at line 66 of file btree_ts.c.

References DatumGetBool, DirectFunctionCall2, timestamp_eq(), and TimestampGetDatumFast.

67 {
68  const Timestamp *aa = (const Timestamp *) a;
69  const Timestamp *bb = (const Timestamp *) b;
70 
73  TimestampGetDatumFast(*bb)));
74 }
#define DatumGetBool(X)
Definition: postgres.h:393
Datum timestamp_eq(PG_FUNCTION_ARGS)
Definition: timestamp.c:2065
int64 Timestamp
Definition: timestamp.h:38
#define TimestampGetDatumFast(X)
Definition: btree_ts.c:39
#define DirectFunctionCall2(func, arg1, arg2)
Definition: fmgr.h:617

◆ gbt_tsge()

static bool gbt_tsge ( const void *  a,
const void *  b,
FmgrInfo flinfo 
)
static

Definition at line 55 of file btree_ts.c.

References DatumGetBool, DirectFunctionCall2, timestamp_ge(), and TimestampGetDatumFast.

56 {
57  const Timestamp *aa = (const Timestamp *) a;
58  const Timestamp *bb = (const Timestamp *) b;
59 
62  TimestampGetDatumFast(*bb)));
63 }
#define DatumGetBool(X)
Definition: postgres.h:393
Datum timestamp_ge(PG_FUNCTION_ARGS)
Definition: timestamp.c:2110
int64 Timestamp
Definition: timestamp.h:38
#define TimestampGetDatumFast(X)
Definition: btree_ts.c:39
#define DirectFunctionCall2(func, arg1, arg2)
Definition: fmgr.h:617

◆ gbt_tsgt()

static bool gbt_tsgt ( const void *  a,
const void *  b,
FmgrInfo flinfo 
)
static

Definition at line 44 of file btree_ts.c.

References DatumGetBool, DirectFunctionCall2, timestamp_gt(), and TimestampGetDatumFast.

45 {
46  const Timestamp *aa = (const Timestamp *) a;
47  const Timestamp *bb = (const Timestamp *) b;
48 
51  TimestampGetDatumFast(*bb)));
52 }
Datum timestamp_gt(PG_FUNCTION_ARGS)
Definition: timestamp.c:2092
#define DatumGetBool(X)
Definition: postgres.h:393
int64 Timestamp
Definition: timestamp.h:38
#define TimestampGetDatumFast(X)
Definition: btree_ts.c:39
#define DirectFunctionCall2(func, arg1, arg2)
Definition: fmgr.h:617

◆ gbt_tskey_cmp()

static int gbt_tskey_cmp ( const void *  a,
const void *  b,
FmgrInfo flinfo 
)
static

Definition at line 100 of file btree_ts.c.

References DatumGetInt32, DirectFunctionCall2, tsKEY::lower, timestamp_cmp(), TimestampGetDatumFast, and tsKEY::upper.

101 {
102  tsKEY *ia = (tsKEY *) (((const Nsrt *) a)->t);
103  tsKEY *ib = (tsKEY *) (((const Nsrt *) b)->t);
104  int res;
105 
107  if (res == 0)
109 
110  return res;
111 }
#define DatumGetInt32(X)
Definition: postgres.h:472
Datum timestamp_cmp(PG_FUNCTION_ARGS)
Definition: timestamp.c:2119
Timestamp lower
Definition: btree_ts.c:16
Definition: btree_ts.c:14
#define TimestampGetDatumFast(X)
Definition: btree_ts.c:39
Timestamp upper
Definition: btree_ts.c:17
#define DirectFunctionCall2(func, arg1, arg2)
Definition: fmgr.h:617

◆ gbt_tsle()

static bool gbt_tsle ( const void *  a,
const void *  b,
FmgrInfo flinfo 
)
static

Definition at line 77 of file btree_ts.c.

References DatumGetBool, DirectFunctionCall2, timestamp_le(), and TimestampGetDatumFast.

78 {
79  const Timestamp *aa = (const Timestamp *) a;
80  const Timestamp *bb = (const Timestamp *) b;
81 
84  TimestampGetDatumFast(*bb)));
85 }
#define DatumGetBool(X)
Definition: postgres.h:393
int64 Timestamp
Definition: timestamp.h:38
#define TimestampGetDatumFast(X)
Definition: btree_ts.c:39
Datum timestamp_le(PG_FUNCTION_ARGS)
Definition: timestamp.c:2101
#define DirectFunctionCall2(func, arg1, arg2)
Definition: fmgr.h:617

◆ gbt_tslt()

static bool gbt_tslt ( const void *  a,
const void *  b,
FmgrInfo flinfo 
)
static

Definition at line 88 of file btree_ts.c.

References DatumGetBool, DirectFunctionCall2, timestamp_lt(), and TimestampGetDatumFast.

89 {
90  const Timestamp *aa = (const Timestamp *) a;
91  const Timestamp *bb = (const Timestamp *) b;
92 
95  TimestampGetDatumFast(*bb)));
96 }
Datum timestamp_lt(PG_FUNCTION_ARGS)
Definition: timestamp.c:2083
#define DatumGetBool(X)
Definition: postgres.h:393
int64 Timestamp
Definition: timestamp.h:38
#define TimestampGetDatumFast(X)
Definition: btree_ts.c:39
#define DirectFunctionCall2(func, arg1, arg2)
Definition: fmgr.h:617

◆ gbt_tstz_compress()

Datum gbt_tstz_compress ( PG_FUNCTION_ARGS  )

Definition at line 217 of file btree_ts.c.

References DatumGetTimestampTz, gistentryinit, gmt, GISTENTRY::key, GISTENTRY::leafkey, tsKEY::lower, GISTENTRY::offset, GISTENTRY::page, palloc(), PG_GETARG_POINTER, PG_RETURN_POINTER, PointerGetDatum, GISTENTRY::rel, tstz_to_ts_gmt(), and tsKEY::upper.

218 {
219  GISTENTRY *entry = (GISTENTRY *) PG_GETARG_POINTER(0);
220  GISTENTRY *retval;
221 
222  if (entry->leafkey)
223  {
224  tsKEY *r = (tsKEY *) palloc(sizeof(tsKEY));
225  TimestampTz ts = DatumGetTimestampTz(entry->key);
226  Timestamp gmt;
227 
228  gmt = tstz_to_ts_gmt(ts);
229 
230  retval = palloc(sizeof(GISTENTRY));
231  r->lower = r->upper = gmt;
232  gistentryinit(*retval, PointerGetDatum(r),
233  entry->rel, entry->page,
234  entry->offset, false);
235  }
236  else
237  retval = entry;
238 
239  PG_RETURN_POINTER(retval);
240 }
Relation rel
Definition: gist.h:132
#define PG_RETURN_POINTER(x)
Definition: fmgr.h:351
int64 TimestampTz
Definition: timestamp.h:39
#define PointerGetDatum(X)
Definition: postgres.h:556
#define PG_GETARG_POINTER(n)
Definition: fmgr.h:271
Timestamp lower
Definition: btree_ts.c:16
Definition: btree_ts.c:14
Page page
Definition: gist.h:133
Datum key
Definition: gist.h:131
#define DatumGetTimestampTz(X)
Definition: timestamp.h:28
bool leafkey
Definition: gist.h:135
int64 Timestamp
Definition: timestamp.h:38
static Timestamp tstz_to_ts_gmt(TimestampTz ts)
Definition: btree_ts.c:200
#define gistentryinit(e, k, r, pg, o, l)
Definition: gist.h:215
Timestamp upper
Definition: btree_ts.c:17
void * palloc(Size size)
Definition: mcxt.c:949
OffsetNumber offset
Definition: gist.h:134
static const char gmt[]
Definition: localtime.c:53

◆ gbt_tstz_consistent()

Datum gbt_tstz_consistent ( PG_FUNCTION_ARGS  )

Definition at line 292 of file btree_ts.c.

References DatumGetPointer, gbt_num_consistent(), GIST_LEAF, sort-test::key, GISTENTRY::key, GBT_NUMKEY_R::lower, MAXALIGN, PG_GETARG_POINTER, PG_GETARG_TIMESTAMPTZ, PG_GETARG_UINT16, PG_RETURN_BOOL, gbtree_ninfo::size, tstz_to_ts_gmt(), and GBT_NUMKEY_R::upper.

293 {
294  GISTENTRY *entry = (GISTENTRY *) PG_GETARG_POINTER(0);
297 
298  /* Oid subtype = PG_GETARG_OID(3); */
299  bool *recheck = (bool *) PG_GETARG_POINTER(4);
300  char *kkk = (char *) DatumGetPointer(entry->key);
302  Timestamp qqq;
303 
304  /* All cases served by this function are exact */
305  *recheck = false;
306 
307  key.lower = (GBT_NUMKEY *) &kkk[0];
308  key.upper = (GBT_NUMKEY *) &kkk[MAXALIGN(tinfo.size)];
309  qqq = tstz_to_ts_gmt(query);
310 
312  gbt_num_consistent(&key, (void *) &qqq, &strategy, GIST_LEAF(entry), &tinfo, fcinfo->flinfo)
313  );
314 }
#define GIST_LEAF(entry)
Definition: gist.h:141
const GBT_NUMKEY * lower
int64 TimestampTz
Definition: timestamp.h:39
uint16 StrategyNumber
Definition: stratnum.h:22
const GBT_NUMKEY * upper
#define PG_GETARG_POINTER(n)
Definition: fmgr.h:271
bool gbt_num_consistent(const GBT_NUMKEY_R *key, const void *query, const StrategyNumber *strategy, bool is_leaf, const gbtree_ninfo *tinfo, FmgrInfo *flinfo)
Datum key
Definition: gist.h:131
char GBT_NUMKEY
int64 Timestamp
Definition: timestamp.h:38
static Timestamp tstz_to_ts_gmt(TimestampTz ts)
Definition: btree_ts.c:200
#define PG_RETURN_BOOL(x)
Definition: fmgr.h:349
#define MAXALIGN(LEN)
Definition: c.h:692
#define PG_GETARG_UINT16(n)
Definition: fmgr.h:267
#define DatumGetPointer(X)
Definition: postgres.h:549
#define PG_GETARG_TIMESTAMPTZ(n)
Definition: timestamp.h:36
static const gbtree_ninfo tinfo
Definition: btree_ts.c:130

◆ gbt_tstz_distance()

Datum gbt_tstz_distance ( PG_FUNCTION_ARGS  )

Definition at line 317 of file btree_ts.c.

References DatumGetPointer, gbt_num_distance(), GIST_LEAF, sort-test::key, GISTENTRY::key, GBT_NUMKEY_R::lower, MAXALIGN, PG_GETARG_POINTER, PG_GETARG_TIMESTAMPTZ, PG_RETURN_FLOAT8, gbtree_ninfo::size, tstz_to_ts_gmt(), and GBT_NUMKEY_R::upper.

318 {
319  GISTENTRY *entry = (GISTENTRY *) PG_GETARG_POINTER(0);
321 
322  /* Oid subtype = PG_GETARG_OID(3); */
323  char *kkk = (char *) DatumGetPointer(entry->key);
325  Timestamp qqq;
326 
327  key.lower = (GBT_NUMKEY *) &kkk[0];
328  key.upper = (GBT_NUMKEY *) &kkk[MAXALIGN(tinfo.size)];
329  qqq = tstz_to_ts_gmt(query);
330 
332  gbt_num_distance(&key, (void *) &qqq, GIST_LEAF(entry), &tinfo, fcinfo->flinfo)
333  );
334 }
#define GIST_LEAF(entry)
Definition: gist.h:141
const GBT_NUMKEY * lower
float8 gbt_num_distance(const GBT_NUMKEY_R *key, const void *query, bool is_leaf, const gbtree_ninfo *tinfo, FmgrInfo *flinfo)
int64 TimestampTz
Definition: timestamp.h:39
#define PG_RETURN_FLOAT8(x)
Definition: fmgr.h:356
const GBT_NUMKEY * upper
#define PG_GETARG_POINTER(n)
Definition: fmgr.h:271
Datum key
Definition: gist.h:131
char GBT_NUMKEY
int64 Timestamp
Definition: timestamp.h:38
static Timestamp tstz_to_ts_gmt(TimestampTz ts)
Definition: btree_ts.c:200
#define MAXALIGN(LEN)
Definition: c.h:692
#define DatumGetPointer(X)
Definition: postgres.h:549
#define PG_GETARG_TIMESTAMPTZ(n)
Definition: timestamp.h:36
static const gbtree_ninfo tinfo
Definition: btree_ts.c:130

◆ PG_FUNCTION_INFO_V1() [1/13]

PG_FUNCTION_INFO_V1 ( gbt_ts_compress  )

Referenced by ts_dist().

◆ PG_FUNCTION_INFO_V1() [2/13]

PG_FUNCTION_INFO_V1 ( gbt_tstz_compress  )

◆ PG_FUNCTION_INFO_V1() [3/13]

PG_FUNCTION_INFO_V1 ( gbt_ts_fetch  )

◆ PG_FUNCTION_INFO_V1() [4/13]

PG_FUNCTION_INFO_V1 ( gbt_ts_union  )

◆ PG_FUNCTION_INFO_V1() [5/13]

PG_FUNCTION_INFO_V1 ( gbt_ts_picksplit  )

◆ PG_FUNCTION_INFO_V1() [6/13]

PG_FUNCTION_INFO_V1 ( gbt_ts_consistent  )

◆ PG_FUNCTION_INFO_V1() [7/13]

PG_FUNCTION_INFO_V1 ( gbt_ts_distance  )

◆ PG_FUNCTION_INFO_V1() [8/13]

PG_FUNCTION_INFO_V1 ( gbt_tstz_consistent  )

◆ PG_FUNCTION_INFO_V1() [9/13]

PG_FUNCTION_INFO_V1 ( gbt_tstz_distance  )

◆ PG_FUNCTION_INFO_V1() [10/13]

PG_FUNCTION_INFO_V1 ( gbt_ts_penalty  )

◆ PG_FUNCTION_INFO_V1() [11/13]

PG_FUNCTION_INFO_V1 ( gbt_ts_same  )

◆ PG_FUNCTION_INFO_V1() [12/13]

PG_FUNCTION_INFO_V1 ( ts_dist  )

◆ PG_FUNCTION_INFO_V1() [13/13]

PG_FUNCTION_INFO_V1 ( tstz_dist  )

◆ ts_dist()

Datum ts_dist ( PG_FUNCTION_ARGS  )

Definition at line 147 of file btree_ts.c.

References abs_interval(), DatumGetIntervalP, Interval::day, DirectFunctionCall2, Interval::month, palloc(), PG_FUNCTION_INFO_V1(), PG_GETARG_DATUM, PG_GETARG_TIMESTAMP, PG_INT64_MAX, PG_RETURN_INTERVAL_P, Interval::time, timestamp_mi(), TIMESTAMP_NOT_FINITE, and tstz_dist().

148 {
151  Interval *r;
152 
154  {
155  Interval *p = palloc(sizeof(Interval));
156 
157  p->day = INT_MAX;
158  p->month = INT_MAX;
159  p->time = PG_INT64_MAX;
161  }
162  else
164  PG_GETARG_DATUM(0),
165  PG_GETARG_DATUM(1)));
167 }
#define PG_INT64_MAX
Definition: c.h:445
#define DatumGetIntervalP(X)
Definition: timestamp.h:29
#define PG_RETURN_INTERVAL_P(x)
Definition: timestamp.h:41
#define PG_GETARG_TIMESTAMP(n)
Definition: timestamp.h:35
#define PG_GETARG_DATUM(n)
Definition: fmgr.h:263
Datum timestamp_mi(PG_FUNCTION_ARGS)
Definition: timestamp.c:2639
int32 day
Definition: timestamp.h:47
#define TIMESTAMP_NOT_FINITE(j)
Definition: timestamp.h:122
TimeOffset time
Definition: timestamp.h:45
int32 month
Definition: timestamp.h:48
int64 Timestamp
Definition: timestamp.h:38
Interval * abs_interval(Interval *a)
void * palloc(Size size)
Definition: mcxt.c:949
#define DirectFunctionCall2(func, arg1, arg2)
Definition: fmgr.h:617

◆ tstz_dist()

Datum tstz_dist ( PG_FUNCTION_ARGS  )

Definition at line 171 of file btree_ts.c.

References abs_interval(), DatumGetIntervalP, Interval::day, DirectFunctionCall2, Interval::month, palloc(), PG_GETARG_DATUM, PG_GETARG_TIMESTAMPTZ, PG_INT64_MAX, PG_RETURN_INTERVAL_P, Interval::time, timestamp_mi(), and TIMESTAMP_NOT_FINITE.

Referenced by ts_dist().

172 {
175  Interval *r;
176 
178  {
179  Interval *p = palloc(sizeof(Interval));
180 
181  p->day = INT_MAX;
182  p->month = INT_MAX;
183  p->time = PG_INT64_MAX;
185  }
186 
188  PG_GETARG_DATUM(0),
189  PG_GETARG_DATUM(1)));
191 }
#define PG_INT64_MAX
Definition: c.h:445
#define DatumGetIntervalP(X)
Definition: timestamp.h:29
#define PG_RETURN_INTERVAL_P(x)
Definition: timestamp.h:41
int64 TimestampTz
Definition: timestamp.h:39
#define PG_GETARG_DATUM(n)
Definition: fmgr.h:263
Datum timestamp_mi(PG_FUNCTION_ARGS)
Definition: timestamp.c:2639
int32 day
Definition: timestamp.h:47
#define TIMESTAMP_NOT_FINITE(j)
Definition: timestamp.h:122
TimeOffset time
Definition: timestamp.h:45
int32 month
Definition: timestamp.h:48
Interval * abs_interval(Interval *a)
void * palloc(Size size)
Definition: mcxt.c:949
#define PG_GETARG_TIMESTAMPTZ(n)
Definition: timestamp.h:36
#define DirectFunctionCall2(func, arg1, arg2)
Definition: fmgr.h:617

◆ tstz_to_ts_gmt()

static Timestamp tstz_to_ts_gmt ( TimestampTz  ts)
inlinestatic

Definition at line 200 of file btree_ts.c.

Referenced by gbt_tstz_compress(), gbt_tstz_consistent(), and gbt_tstz_distance().

201 {
202  /* No timezone correction is needed, since GMT is offset 0 by definition */
203  return (Timestamp) ts;
204 }
int64 Timestamp
Definition: timestamp.h:38

Variable Documentation

◆ tinfo

const gbtree_ninfo tinfo
static
Initial value:
=
{
sizeof(Timestamp),
16,
}
static bool gbt_tslt(const void *a, const void *b, FmgrInfo *flinfo)
Definition: btree_ts.c:88
static bool gbt_tseq(const void *a, const void *b, FmgrInfo *flinfo)
Definition: btree_ts.c:66
int64 Timestamp
Definition: timestamp.h:38
static int gbt_tskey_cmp(const void *a, const void *b, FmgrInfo *flinfo)
Definition: btree_ts.c:100
static bool gbt_tsge(const void *a, const void *b, FmgrInfo *flinfo)
Definition: btree_ts.c:55
static float8 gbt_ts_dist(const void *a, const void *b, FmgrInfo *flinfo)
Definition: btree_ts.c:114
static bool gbt_tsgt(const void *a, const void *b, FmgrInfo *flinfo)
Definition: btree_ts.c:44
static bool gbt_tsle(const void *a, const void *b, FmgrInfo *flinfo)
Definition: btree_ts.c:77

Definition at line 130 of file btree_ts.c.