PostgreSQL Source Code  git master
btree_inet.c
Go to the documentation of this file.
1 /*
2  * contrib/btree_gist/btree_inet.c
3  */
4 #include "postgres.h"
5 
6 #include "btree_gist.h"
7 #include "btree_utils_num.h"
8 #include "catalog/pg_type.h"
9 #include "utils/builtins.h"
10 #include "utils/inet.h"
11 
12 typedef struct inetkey
13 {
14  double lower;
15  double upper;
17 
18 /*
19 ** inet ops
20 */
27 
28 
29 static bool
30 gbt_inetgt(const void *a, const void *b, FmgrInfo *flinfo)
31 {
32  return (*((const double *) a) > *((const double *) b));
33 }
34 static bool
35 gbt_inetge(const void *a, const void *b, FmgrInfo *flinfo)
36 {
37  return (*((const double *) a) >= *((const double *) b));
38 }
39 static bool
40 gbt_ineteq(const void *a, const void *b, FmgrInfo *flinfo)
41 {
42  return (*((const double *) a) == *((const double *) b));
43 }
44 static bool
45 gbt_inetle(const void *a, const void *b, FmgrInfo *flinfo)
46 {
47  return (*((const double *) a) <= *((const double *) b));
48 }
49 static bool
50 gbt_inetlt(const void *a, const void *b, FmgrInfo *flinfo)
51 {
52  return (*((const double *) a) < *((const double *) b));
53 }
54 
55 static int
56 gbt_inetkey_cmp(const void *a, const void *b, FmgrInfo *flinfo)
57 {
58  inetKEY *ia = (inetKEY *) (((const Nsrt *) a)->t);
59  inetKEY *ib = (inetKEY *) (((const Nsrt *) b)->t);
60 
61  if (ia->lower == ib->lower)
62  {
63  if (ia->upper == ib->upper)
64  return 0;
65 
66  return (ia->upper > ib->upper) ? 1 : -1;
67  }
68 
69  return (ia->lower > ib->lower) ? 1 : -1;
70 }
71 
72 
73 static const gbtree_ninfo tinfo =
74 {
75  gbt_t_inet,
76  sizeof(double),
77  16, /* sizeof(gbtreekey16) */
78  gbt_inetgt,
79  gbt_inetge,
80  gbt_ineteq,
81  gbt_inetle,
82  gbt_inetlt,
84  NULL
85 };
86 
87 
88 /**************************************************
89  * inet ops
90  **************************************************/
91 
92 
93 Datum
95 {
96  GISTENTRY *entry = (GISTENTRY *) PG_GETARG_POINTER(0);
97  GISTENTRY *retval;
98 
99  if (entry->leafkey)
100  {
101  inetKEY *r = (inetKEY *) palloc(sizeof(inetKEY));
102  bool failure = false;
103 
104  retval = palloc(sizeof(GISTENTRY));
105  r->lower = convert_network_to_scalar(entry->key, INETOID, &failure);
106  Assert(!failure);
107  r->upper = r->lower;
108  gistentryinit(*retval, PointerGetDatum(r),
109  entry->rel, entry->page,
110  entry->offset, false);
111  }
112  else
113  retval = entry;
114 
115  PG_RETURN_POINTER(retval);
116 }
117 
118 
119 Datum
121 {
122  GISTENTRY *entry = (GISTENTRY *) PG_GETARG_POINTER(0);
123  Datum dquery = PG_GETARG_DATUM(1);
125 
126  /* Oid subtype = PG_GETARG_OID(3); */
127  bool *recheck = (bool *) PG_GETARG_POINTER(4);
128  inetKEY *kkk = (inetKEY *) DatumGetPointer(entry->key);
130  double query;
131  bool failure = false;
132 
133  query = convert_network_to_scalar(dquery, INETOID, &failure);
134  Assert(!failure);
135 
136  /* All cases served by this function are inexact */
137  *recheck = true;
138 
139  key.lower = (GBT_NUMKEY *) &kkk->lower;
140  key.upper = (GBT_NUMKEY *) &kkk->upper;
141 
142  PG_RETURN_BOOL(gbt_num_consistent(&key, (void *) &query,
143  &strategy, GIST_LEAF(entry), &tinfo, fcinfo->flinfo));
144 }
145 
146 
147 Datum
149 {
151  void *out = palloc(sizeof(inetKEY));
152 
153  *(int *) PG_GETARG_POINTER(1) = sizeof(inetKEY);
154  PG_RETURN_POINTER(gbt_num_union((void *) out, entryvec, &tinfo, fcinfo->flinfo));
155 }
156 
157 
158 Datum
160 {
161  inetKEY *origentry = (inetKEY *) DatumGetPointer(((GISTENTRY *) PG_GETARG_POINTER(0))->key);
162  inetKEY *newentry = (inetKEY *) DatumGetPointer(((GISTENTRY *) PG_GETARG_POINTER(1))->key);
163  float *result = (float *) PG_GETARG_POINTER(2);
164 
165  penalty_num(result, origentry->lower, origentry->upper, newentry->lower, newentry->upper);
166 
167  PG_RETURN_POINTER(result);
168 }
169 
170 Datum
172 {
175  &tinfo, fcinfo->flinfo));
176 }
177 
178 Datum
180 {
181  inetKEY *b1 = (inetKEY *) PG_GETARG_POINTER(0);
182  inetKEY *b2 = (inetKEY *) PG_GETARG_POINTER(1);
183  bool *result = (bool *) PG_GETARG_POINTER(2);
184 
185  *result = gbt_num_same((void *) b1, (void *) b2, &tinfo, fcinfo->flinfo);
186  PG_RETURN_POINTER(result);
187 }
@ gbt_t_inet
Definition: btree_gist.h:36
static bool gbt_inetge(const void *a, const void *b, FmgrInfo *flinfo)
Definition: btree_inet.c:35
Datum gbt_inet_union(PG_FUNCTION_ARGS)
Definition: btree_inet.c:148
static int gbt_inetkey_cmp(const void *a, const void *b, FmgrInfo *flinfo)
Definition: btree_inet.c:56
Datum gbt_inet_picksplit(PG_FUNCTION_ARGS)
Definition: btree_inet.c:171
Datum gbt_inet_compress(PG_FUNCTION_ARGS)
Definition: btree_inet.c:94
Datum gbt_inet_consistent(PG_FUNCTION_ARGS)
Definition: btree_inet.c:120
static bool gbt_inetgt(const void *a, const void *b, FmgrInfo *flinfo)
Definition: btree_inet.c:30
static bool gbt_inetle(const void *a, const void *b, FmgrInfo *flinfo)
Definition: btree_inet.c:45
struct inetkey inetKEY
static const gbtree_ninfo tinfo
Definition: btree_inet.c:73
static bool gbt_inetlt(const void *a, const void *b, FmgrInfo *flinfo)
Definition: btree_inet.c:50
static bool gbt_ineteq(const void *a, const void *b, FmgrInfo *flinfo)
Definition: btree_inet.c:40
PG_FUNCTION_INFO_V1(gbt_inet_compress)
Datum gbt_inet_same(PG_FUNCTION_ARGS)
Definition: btree_inet.c:179
Datum gbt_inet_penalty(PG_FUNCTION_ARGS)
Definition: btree_inet.c:159
bool gbt_num_consistent(const GBT_NUMKEY_R *key, const void *query, const StrategyNumber *strategy, bool is_leaf, const gbtree_ninfo *tinfo, FmgrInfo *flinfo)
bool gbt_num_same(const GBT_NUMKEY *a, const GBT_NUMKEY *b, const gbtree_ninfo *tinfo, FmgrInfo *flinfo)
void * gbt_num_union(GBT_NUMKEY *out, const GistEntryVector *entryvec, const gbtree_ninfo *tinfo, FmgrInfo *flinfo)
GIST_SPLITVEC * gbt_num_picksplit(const GistEntryVector *entryvec, GIST_SPLITVEC *v, const gbtree_ninfo *tinfo, FmgrInfo *flinfo)
#define penalty_num(result, olower, oupper, nlower, nupper)
char GBT_NUMKEY
#define Assert(condition)
Definition: c.h:858
#define PG_GETARG_POINTER(n)
Definition: fmgr.h:276
#define PG_GETARG_DATUM(n)
Definition: fmgr.h:268
#define PG_GETARG_UINT16(n)
Definition: fmgr.h:272
#define PG_RETURN_POINTER(x)
Definition: fmgr.h:361
#define PG_FUNCTION_ARGS
Definition: fmgr.h:193
#define PG_RETURN_BOOL(x)
Definition: fmgr.h:359
#define GIST_LEAF(entry)
Definition: gist.h:170
#define gistentryinit(e, k, r, pg, o, l)
Definition: gist.h:244
int b
Definition: isn.c:70
int a
Definition: isn.c:69
void * palloc(Size size)
Definition: mcxt.c:1316
double convert_network_to_scalar(Datum value, Oid typid, bool *failure)
Definition: network.c:1502
static Datum PointerGetDatum(const void *X)
Definition: postgres.h:322
uintptr_t Datum
Definition: postgres.h:64
static Pointer DatumGetPointer(Datum X)
Definition: postgres.h:312
uint16 StrategyNumber
Definition: stratnum.h:22
Definition: fmgr.h:57
OffsetNumber offset
Definition: gist.h:163
Datum key
Definition: gist.h:160
Page page
Definition: gist.h:162
Relation rel
Definition: gist.h:161
bool leafkey
Definition: gist.h:164
double lower
Definition: btree_inet.c:14
double upper
Definition: btree_inet.c:15