pg_proc.h 126.2 KB
Newer Older
1
/*-------------------------------------------------------------------------
2
 *
3
 * pg_proc.h
4 5
 *	  definition of the system "procedure" relation (pg_proc)
 *	  along with the relation's initial contents.
6 7 8
 *
 * Copyright (c) 1994, Regents of the University of California
 *
9
 * $Id: pg_proc.h,v 1.93 1999/03/28 02:01:39 tgl Exp $
10 11
 *
 * NOTES
12 13 14
 *	  The script catalog/genbki.sh reads this file and generates .bki
 *	  information from the DATA() statements.  utils/Gen_fmgrtab.sh
 *	  generates fmgr.h and fmgrtab.c the same way.
15
 *
16 17 18
 *	  XXX do NOT break up DATA() statements into multiple lines!
 *		  the scripts are not as smart as you might think...
 *	  XXX (eg. #if 0 #endif won't do what you think)
19 20 21 22 23 24
 *
 *-------------------------------------------------------------------------
 */
#ifndef PG_PROC_H
#define PG_PROC_H

25 26
#include <tcop/dest.h>

27
/* ----------------
28 29 30
 *		postgres.h contains the system type definintions and the
 *		CATALOG(), BOOTSTRAP and DATA() sugar words so this file
 *		can be read by both genbki.sh and the C compiler.
31 32 33 34
 * ----------------
 */

/* ----------------
35 36
 *		pg_proc definition.  cpp turns this into
 *		typedef struct FormData_pg_proc
37 38
 * ----------------
 */
39 40
CATALOG(pg_proc) BOOTSTRAP
{
41
	NameData	proname;
42
	int4		proowner;
43 44 45 46 47 48 49 50 51 52 53 54 55 56
	Oid			prolang;
	bool		proisinh;
	bool		proistrusted;
	bool		proiscachable;
	int2		pronargs;
	bool		proretset;
	Oid			prorettype;
	oid8		proargtypes;
	int4		probyte_pct;
	int4		properbyte_cpu;
	int4		propercall_cpu;
	int4		prooutin_ratio;
	text		prosrc;			/* VARIABLE LENGTH FIELD */
	bytea		probin;			/* VARIABLE LENGTH FIELD */
57 58 59
} FormData_pg_proc;

/* ----------------
60 61
 *		Form_pg_proc corresponds to a pointer to a tuple with
 *		the format of pg_proc relation.
62 63
 * ----------------
 */
64
typedef FormData_pg_proc *Form_pg_proc;
65 66

/* ----------------
67
 *		compiler constants for pg_proc
68 69
 * ----------------
 */
70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86
#define Natts_pg_proc					16
#define Anum_pg_proc_proname			1
#define Anum_pg_proc_proowner			2
#define Anum_pg_proc_prolang			3
#define Anum_pg_proc_proisinh			4
#define Anum_pg_proc_proistrusted		5
#define Anum_pg_proc_proiscachable		6
#define Anum_pg_proc_pronargs			7
#define Anum_pg_proc_proretset			8
#define Anum_pg_proc_prorettype			9
#define Anum_pg_proc_proargtypes		10
#define Anum_pg_proc_probyte_pct		11
#define Anum_pg_proc_properbyte_cpu		12
#define Anum_pg_proc_propercall_cpu		13
#define Anum_pg_proc_prooutin_ratio		14
#define Anum_pg_proc_prosrc				15
#define Anum_pg_proc_probin				16
87 88

/* ----------------
89
 *		initial contents of pg_proc
90 91 92
 * ----------------
 */

93
/* keep the following ordered by OID so that later changes can be made easier */
94 95

/* OIDS 1 - 99 */
96

97
DATA(insert OID = 1242 (  boolin		   PGUID 11 f t f 1 f 16 "0" 100 0 0  100  foo bar ));
98
DESCR("(internal)");
99
DATA(insert OID = 1243 (  boolout		   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
100
DESCR("(internal)");
101
DATA(insert OID = 1244 (  byteain		   PGUID 11 f t f 1 f 17 "0" 100 0 0 100  foo bar ));
102
DESCR("(internal)");
103
DATA(insert OID =  31 (  byteaout		   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
104
DESCR("(internal)");
105
DATA(insert OID = 1245 (  charin		   PGUID 11 f t f 1 f 18 "0" 100 0 0 100  foo bar ));
106
DESCR("(internal)");
107
DATA(insert OID =  33 (  charout		   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
108
DESCR("(internal)");
109
DATA(insert OID =  34 (  namein			   PGUID 11 f t f 1 f 19 "0" 100 0 0 100  foo bar ));
110
DESCR("(internal)");
111
DATA(insert OID =  35 (  nameout		   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
112
DESCR("(internal)");
113
DATA(insert OID =  38 (  int2in			   PGUID 11 f t f 1 f 21 "0" 100 0 0 100  foo bar ));
114
DESCR("(internal)");
115
DATA(insert OID =  39 (  int2out		   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
116
DESCR("(internal)");
117
DATA(insert OID =  40 (  int28in		   PGUID 11 f t f 1 f 22 "0" 100 0 0 100  foo bar ));
118
DESCR("(internal)");
119
DATA(insert OID =  41 (  int28out		   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
120
DESCR("(internal)");
121
DATA(insert OID =  42 (  int4in			   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
122
DESCR("(internal)");
123
DATA(insert OID =  43 (  int4out		   PGUID 11 f t f 1 f 19 "0" 100 0 0 100  foo bar ));
124
DESCR("(internal)");
125
DATA(insert OID =  44 (  regprocin		   PGUID 11 f t f 1 f 24 "0" 100 0 0 100  foo bar ));
126
DESCR("(internal)");
127
DATA(insert OID =  45 (  regprocout		   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
128
DESCR("(internal)");
129
DATA(insert OID =  46 (  textin			   PGUID 11 f t f 1 f 25 "0" 100 0 0 100  foo bar ));
130
DESCR("(internal)");
131
DATA(insert OID =  47 (  textout		   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
132
DESCR("(internal)");
133
DATA(insert OID =  48 (  tidin			   PGUID 11 f t f 1 f 27 "0" 100 0 0 100  foo bar ));
134
DESCR("(internal)");
135
DATA(insert OID =  49 (  tidout			   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
136
DESCR("(internal)");
137
DATA(insert OID =  50 (  xidin			   PGUID 11 f t f 1 f 28 "0" 100 0 0 100  foo bar ));
138
DESCR("(internal)");
139
DATA(insert OID =  51 (  xidout			   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
140
DESCR("(internal)");
141
DATA(insert OID =  52 (  cidin			   PGUID 11 f t f 1 f 29 "0" 100 0 0 100  foo bar ));
142
DESCR("(internal)");
143
DATA(insert OID =  53 (  cidout			   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
144
DESCR("(internal)");
145
DATA(insert OID =  54 (  oid8in			   PGUID 11 f t f 1 f 30 "0" 100 0 0 100  foo bar ));
146
DESCR("(internal)");
147
DATA(insert OID =  55 (  oid8out		   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
148
DESCR("(internal)");
149
DATA(insert OID =  56 (  boollt			   PGUID 11 f t f 2 f 16 "16 16" 100 0 0 100  foo bar ));
150
DESCR("less-than");
151
DATA(insert OID =  57 (  boolgt			   PGUID 11 f t f 2 f 16 "16 16" 100 0 0 100  foo bar ));
152
DESCR("greater-than");
153
DATA(insert OID =  60 (  booleq			   PGUID 11 f t f 2 f 16 "16 16" 100 0 0 100  foo bar ));
154
DESCR("equal");
155
DATA(insert OID =  61 (  chareq			   PGUID 11 f t f 2 f 16 "18 18" 100 0 0 100  foo bar ));
156
DESCR("equal");
157
DATA(insert OID =  62 (  nameeq			   PGUID 11 f t f 2 f 16 "19 19" 100 0 0 100  foo bar ));
158
DESCR("equal");
159
DATA(insert OID =  63 (  int2eq			   PGUID 11 f t f 2 f 16 "21 21" 100 0 0 100  foo bar ));
160
DESCR("equal");
161
DATA(insert OID =  64 (  int2lt			   PGUID 11 f t f 2 f 16 "21 21" 100 0 0 100  foo bar ));
162
DESCR("less-than");
163
DATA(insert OID =  65 (  int4eq			   PGUID 11 f t f 2 f 16 "23 23" 100 0 0 100  foo bar ));
164
DESCR("equal");
165
DATA(insert OID =  66 (  int4lt			   PGUID 11 f t f 2 f 16 "23 23" 100 0 0 100  foo bar ));
166
DESCR("less-than");
167
DATA(insert OID =  67 (  texteq			   PGUID 11 f t f 2 f 16 "25 25" 100 0 0 0	foo bar ));
168
DESCR("equal");
169
DATA(insert OID =  68 (  xideq			   PGUID 11 f t f 2 f 16 "28 28" 100 0 0 100  foo bar ));
170
DESCR("equal");
171
DATA(insert OID =  69 (  cideq			   PGUID 11 f t f 2 f 16 "29 29" 100 0 0 100  foo bar ));
172
DESCR("equal");
173
DATA(insert OID =  70 (  charne			   PGUID 11 f t f 2 f 16 "18 18" 100 0 0 100  foo bar ));
174
DESCR("not equal");
175
DATA(insert OID = 1246 (  charlt		   PGUID 11 f t f 2 f 16 "18 18" 100 0 0 100  foo bar ));
176
DESCR("less-than");
177
DATA(insert OID =  72 (  charle			   PGUID 11 f t f 2 f 16 "18 18" 100 0 0 100  foo bar ));
178
DESCR("less-than-or-equal");
179
DATA(insert OID =  73 (  chargt			   PGUID 11 f t f 2 f 16 "18 18" 100 0 0 100  foo bar ));
180
DESCR("greater-than");
181
DATA(insert OID =  74 (  charge			   PGUID 11 f t f 2 f 16 "18 18" 100 0 0 100  foo bar ));
182
DESCR("greater-than-or-equal");
183
DATA(insert OID = 1248 (  charpl		   PGUID 11 f t f 2 f 18 "18 18" 100 0 0 100  foo bar ));
184
DESCR("addition");
185
DATA(insert OID = 1250 (  charmi		   PGUID 11 f t f 2 f 18 "18 18" 100 0 0 100  foo bar ));
186
DESCR("subtract");
187
DATA(insert OID =  77 (  charmul		   PGUID 11 f t f 2 f 18 "18 18" 100 0 0 100  foo bar ));
188
DESCR("multiply");
189
DATA(insert OID =  78 (  chardiv		   PGUID 11 f t f 2 f 18 "18 18" 100 0 0 100  foo bar ));
190
DESCR("divide");
191 192

DATA(insert OID =  79 (  nameregexeq	   PGUID 11 f t f 2 f 16 "19 25" 100 0 0 100  foo bar ));
193
DESCR("matches regex., case-sensitive");
194
DATA(insert OID = 1252 (  nameregexne	   PGUID 11 f t f 2 f 16 "19 25" 100 0 0 100  foo bar ));
195
DESCR("does not match regex., case-sensitive");
196
DATA(insert OID = 1254 (  textregexeq	   PGUID 11 f t f 2 f 16 "25 25" 100 0 1 0	foo bar ));
197
DESCR("matches regex., case-sensitive");
198
DATA(insert OID = 1256 (  textregexne	   PGUID 11 f t f 2 f 16 "25 25" 100 0 1 0	foo bar ));
199
DESCR("does not match regex., case-sensitive");
200
DATA(insert OID = 1257 (  textlen		   PGUID 11 f t f 1 f 23 "25" 100 0 1 0  foo bar ));
201
DESCR("length");
202
DATA(insert OID = 1258 (  textcat		   PGUID 11 f t f 2 f 25 "25 25" 100 0 1 0	foo bar ));
203 204
DESCR("concatenate");
DATA(insert OID = 1377 (  textoctetlen	   PGUID 11 f t f 1 f 23 "25" 100 0 1 0  foo bar ));
M
Marc G. Fournier 已提交
205
DESCR("octet length");
206

207
DATA(insert OID =  84 (  boolne			   PGUID 11 f t f 2 f 16 "16 16" 100 0 0 100  foo bar ));
208
DESCR("not equal");
209 210
DATA(insert OID =  89 (  version		   PGUID 11 f t t 0 f 25 "" 100 0 0 100 foo bar ));
DESCR("PostgreSQL version string");
211 212

DATA(insert OID = 1265 (  rtsel			   PGUID 11 f t f 7 f 701 "26 26 21 0 23 23 26" 100 0 0 100  foo bar ));
213
DESCR("r-tree");
214
DATA(insert OID = 1266 (  rtnpage		   PGUID 11 f t f 7 f 701 "26 26 21 0 23 23 26" 100 0 0 100  foo bar ));
215
DESCR("r-tree");
216
DATA(insert OID = 1268 (  btreesel		   PGUID 11 f t f 7 f 701 "26 26 21 0 23 23 26" 100 0 0 100  foo bar ));
217
DESCR("btree selectivity");
218 219 220

/* OIDS 100 - 199 */

221
DATA(insert OID = 1270 (  btreenpage	   PGUID 11 f t f 7 f 701 "26 26 21 0 23 23 26" 100 0 0 100  foo bar ));
222
DESCR("btree");
223
DATA(insert OID = 1272 (  eqsel			   PGUID 11 f t f 5 f 701 "26 26 21 0 23" 100 0 0 100  foo bar ));
224
DESCR("general selectivity");
225
DATA(insert OID = 102 (  neqsel			   PGUID 11 f t f 5 f 701 "26 26 21 0 23" 100 0 0 100  foo bar ));
226
DESCR("not-equal selectivity");
227
DATA(insert OID = 103 (  intltsel		   PGUID 11 f t f 5 f 701 "26 26 21 0 23" 100 0 0 100  foo bar ));
228
DESCR("selectivity");
229
DATA(insert OID = 104 (  intgtsel		   PGUID 11 f t f 5 f 701 "26 26 21 0 23" 100 0 0 100  foo bar ));
230
DESCR("selectivity");
231
DATA(insert OID = 105 (  eqjoinsel		   PGUID 11 f t f 5 f 701 "26 26 21 26 21" 100 0 0 100	foo bar ));
232
DESCR("selectivity");
233
DATA(insert OID = 106 (  neqjoinsel		   PGUID 11 f t f 5 f 701 "26 26 21 26 21" 100 0 0 100	foo bar ));
234
DESCR("selectivity");
235
DATA(insert OID = 107 (  intltjoinsel	   PGUID 11 f t f 5 f 701 "26 26 21 26 21" 100 0 0 100	foo bar ));
236
DESCR("selectivity");
237
DATA(insert OID = 108 (  intgtjoinsel	   PGUID 11 f t f 5 f 701 "26 26 21 26 21" 100 0 0 100	foo bar ));
238
DESCR("selectivity");
239

240
DATA(insert OID = 112 (  int4_text		   PGUID 11 f t f 1 f  25 "23" 100 0 0 100	foo bar ));
241
DESCR("convert int4 to text");
242
DATA(insert OID = 113 (  int2_text		   PGUID 11 f t f 1 f  25 "21" 100 0 0 100	foo bar ));
243
DESCR("convert int2 to text");
244
DATA(insert OID = 114 (  oid_text		   PGUID 11 f t f 1 f  25 "26" 100 0 0 100	foo bar ));
245
DESCR("convert oid to text");
246

247
DATA(insert OID = 115 (  box_above		   PGUID 11 f t f 2 f  16 "603 603" 100 1 0 100  foo bar ));
248
DESCR("is above");
249
DATA(insert OID = 116 (  box_below		   PGUID 11 f t f 2 f  16 "603 603" 100 1 0 100  foo bar ));
250
DESCR("is below");
251 252

DATA(insert OID = 117 (  point_in		   PGUID 11 f t f 1 f 600 "0" 100 0 0 100  foo bar ));
253
DESCR("(internal)");
254
DATA(insert OID = 118 (  point_out		   PGUID 11 f t f 1 f 23  "0" 100 0 0 100  foo bar ));
255
DESCR("(internal)");
256
DATA(insert OID = 119 (  lseg_in		   PGUID 11 f t f 1 f 601 "0" 100 0 0 100  foo bar ));
257
DESCR("(internal)");
258
DATA(insert OID = 120 (  lseg_out		   PGUID 11 f t f 1 f 23  "0" 100 0 0 100  foo bar ));
259
DESCR("(internal)");
260
DATA(insert OID = 121 (  path_in		   PGUID 11 f t f 1 f 602 "0" 100 0 0 100  foo bar ));
261
DESCR("(internal)");
262
DATA(insert OID = 122 (  path_out		   PGUID 11 f t f 1 f 23  "0" 100 0 0 100  foo bar ));
263
DESCR("(internal)");
264
DATA(insert OID = 123 (  box_in			   PGUID 11 f t f 1 f 603 "0" 100 0 0 100  foo bar ));
265
DESCR("(internal)");
266
DATA(insert OID = 124 (  box_out		   PGUID 11 f t f 1 f 23  "0" 100 0 0 100  foo bar ));
267
DESCR("(internal)");
268
DATA(insert OID = 125 (  box_overlap	   PGUID 11 f t f 2 f 16 "603 603" 100 1 0 100	foo bar ));
269
DESCR("overlaps");
270
DATA(insert OID = 126 (  box_ge			   PGUID 11 f t f 2 f 16 "603 603" 100 1 0 100	foo bar ));
271
DESCR("greater-than-or-equal");
272
DATA(insert OID = 127 (  box_gt			   PGUID 11 f t f 2 f 16 "603 603" 100 1 0 100	foo bar ));
273
DESCR("greater-than");
274
DATA(insert OID = 128 (  box_eq			   PGUID 11 f t f 2 f 16 "603 603" 100 1 0 100	foo bar ));
275
DESCR("equal");
276
DATA(insert OID = 129 (  box_lt			   PGUID 11 f t f 2 f 16 "603 603" 100 1 0 100	foo bar ));
277
DESCR("less-than");
278
DATA(insert OID = 130 (  box_le			   PGUID 11 f t f 2 f 16 "603 603" 100 1 0 100	foo bar ));
279
DESCR("less-than-or-equal");
280
DATA(insert OID = 131 (  point_above	   PGUID 11 f t f 2 f 16 "600 600" 100 0 0 100	foo bar ));
281
DESCR("is above");
282
DATA(insert OID = 132 (  point_left		   PGUID 11 f t f 2 f 16 "600 600" 100 0 0 100	foo bar ));
283
DESCR("is left of");
284
DATA(insert OID = 133 (  point_right	   PGUID 11 f t f 2 f 16 "600 600" 100 0 0 100	foo bar ));
285
DESCR("is left of");
286
DATA(insert OID = 134 (  point_below	   PGUID 11 f t f 2 f 16 "600 600" 100 0 0 100	foo bar ));
287
DESCR("is below");
288
DATA(insert OID = 135 (  point_eq		   PGUID 11 f t f 2 f 16 "600 600" 100 0 0 100	foo bar ));
289
DESCR("same as");
290
DATA(insert OID = 136 (  on_pb			   PGUID 11 f t f 2 f 16 "600 603" 100 0 0 100	foo bar ));
291
DESCR("point is inside");
292
DATA(insert OID = 137 (  on_ppath		   PGUID 11 f t f 2 f 16 "600 602" 100 0 1 0  foo bar ));
293
DESCR("contained in");
294
DATA(insert OID = 138 (  box_center		   PGUID 11 f t f 1 f 600 "603" 100 1 0 100  foo bar ));
295
DESCR("center of");
296
DATA(insert OID = 139 (  areasel		   PGUID 11 f t f 5 f 701 "26 26 21 0 23" 100 0 0 100  foo bar ));
297
DESCR("selectivity");
298
DATA(insert OID = 140 (  areajoinsel	   PGUID 11 f t f 5 f 701 "26 26 21 26 21" 100 0 0 100  foo bar ));
299
DESCR("selectivity");
300
DATA(insert OID = 141 (  int4mul		   PGUID 11 f t f 2 f 23 "23 23" 100 0 0 100  foo bar ));
301
DESCR("multiply");
302
DATA(insert OID = 142 (  int4fac		   PGUID 11 f t f 1 f 23 "23" 100 0 0 100  foo bar ));
303
DESCR("fraction");
304
DATA(insert OID = 143 (  pointdist		   PGUID 11 f t f 2 f 23 "600 600" 100 0 0 100	foo bar ));
305
DESCR("");
306
DATA(insert OID = 144 (  int4ne			   PGUID 11 f t f 2 f 16 "23 23" 100 0 0 100  foo bar ));
307
DESCR("not equal");
308
DATA(insert OID = 145 (  int2ne			   PGUID 11 f t f 2 f 16 "21 21" 100 0 0 100  foo bar ));
309
DESCR("not equal");
310
DATA(insert OID = 146 (  int2gt			   PGUID 11 f t f 2 f 16 "21 21" 100 0 0 100  foo bar ));
311
DESCR("greater-than");
312
DATA(insert OID = 147 (  int4gt			   PGUID 11 f t f 2 f 16 "23 23" 100 0 0 100  foo bar ));
313
DESCR("greater-than");
314
DATA(insert OID = 148 (  int2le			   PGUID 11 f t f 2 f 16 "21 21" 100 0 0 100  foo bar ));
315
DESCR("less-than-or-equal");
316
DATA(insert OID = 149 (  int4le			   PGUID 11 f t f 2 f 16 "23 23" 100 0 0 100  foo bar ));
317
DESCR("less-than-or-equal");
318
DATA(insert OID = 150 (  int4ge			   PGUID 11 f t f 2 f 16 "23 23" 100 0 0 100  foo bar ));
319
DESCR("greater-than-or-equal");
320
DATA(insert OID = 151 (  int2ge			   PGUID 11 f t f 2 f 16 "21 21" 100 0 0 100  foo bar ));
321
DESCR("greater-than-or-equal");
322
DATA(insert OID = 152 (  int2mul		   PGUID 11 f t f 2 f 21 "21 21" 100 0 0 100  foo bar ));
323
DESCR("multiply");
324
DATA(insert OID = 153 (  int2div		   PGUID 11 f t f 2 f 21 "21 21" 100 0 0 100  foo bar ));
325
DESCR("divide");
326
DATA(insert OID = 154 (  int4div		   PGUID 11 f t f 2 f 23 "23 23" 100 0 0 100  foo bar ));
327
DESCR("divide");
328
DATA(insert OID = 155 (  int2mod		   PGUID 11 f t f 2 f 21 "21 21" 100 0 0 100  foo bar ));
329
DESCR("modulus");
330
DATA(insert OID = 156 (  int4mod		   PGUID 11 f t f 2 f 23 "23 23" 100 0 0 100  foo bar ));
331
DESCR("modulus");
332
DATA(insert OID = 157 (  textne			   PGUID 11 f t f 2 f 16 "25 25" 100 0 0 0	foo bar ));
333
DESCR("not equal");
334
DATA(insert OID = 158 (  int24eq		   PGUID 11 f t f 2 f 16 "21 23" 100 0 0 100  foo bar ));
335
DESCR("equal");
336
DATA(insert OID = 159 (  int42eq		   PGUID 11 f t f 2 f 16 "23 21" 100 0 0 100  foo bar ));
337
DESCR("equal");
338
DATA(insert OID = 160 (  int24lt		   PGUID 11 f t f 2 f 16 "21 23" 100 0 0 100  foo bar ));
339
DESCR("less-than");
340
DATA(insert OID = 161 (  int42lt		   PGUID 11 f t f 2 f 16 "23 21" 100 0 0 100  foo bar ));
341
DESCR("less-than");
342
DATA(insert OID = 162 (  int24gt		   PGUID 11 f t f 2 f 16 "21 23" 100 0 0 100  foo bar ));
343
DESCR("greater-than");
344
DATA(insert OID = 163 (  int42gt		   PGUID 11 f t f 2 f 16 "23 21" 100 0 0 100  foo bar ));
345
DESCR("greater-than");
346
DATA(insert OID = 164 (  int24ne		   PGUID 11 f t f 2 f 16 "21 23" 100 0 0 100  foo bar ));
347
DESCR("not equal");
348
DATA(insert OID = 165 (  int42ne		   PGUID 11 f t f 2 f 16 "23 21" 100 0 0 100  foo bar ));
349
DESCR("not equal");
350
DATA(insert OID = 166 (  int24le		   PGUID 11 f t f 2 f 16 "21 23" 100 0 0 100  foo bar ));
351
DESCR("less-than-or-equal");
352
DATA(insert OID = 167 (  int42le		   PGUID 11 f t f 2 f 16 "23 21" 100 0 0 100  foo bar ));
353
DESCR("less-than-or-equal");
354
DATA(insert OID = 168 (  int24ge		   PGUID 11 f t f 2 f 16 "21 23" 100 0 0 100  foo bar ));
355
DESCR("greater-than-or-equal");
356
DATA(insert OID = 169 (  int42ge		   PGUID 11 f t f 2 f 16 "23 21" 100 0 0 100  foo bar ));
357
DESCR("greater-than-or-equal");
358
DATA(insert OID = 170 (  int24mul		   PGUID 11 f t f 2 f 23 "21 23" 100 0 0 100  foo bar ));
359
DESCR("multiply");
360
DATA(insert OID = 171 (  int42mul		   PGUID 11 f t f 2 f 23 "23 21" 100 0 0 100  foo bar ));
361
DESCR("multiply");
362
DATA(insert OID = 172 (  int24div		   PGUID 11 f t f 2 f 23 "21 23" 100 0 0 100  foo bar ));
363
DESCR("divide");
364
DATA(insert OID = 173 (  int42div		   PGUID 11 f t f 2 f 23 "23 21" 100 0 0 100  foo bar ));
365
DESCR("divide");
366
DATA(insert OID = 174 (  int24mod		   PGUID 11 f t f 2 f 23 "21 23" 100 0 0 100  foo bar ));
367
DESCR("modulus");
368
DATA(insert OID = 175 (  int42mod		   PGUID 11 f t f 2 f 23 "23 21" 100 0 0 100  foo bar ));
369
DESCR("modulus");
370
DATA(insert OID = 176 (  int2pl			   PGUID 11 f t f 2 f 21 "21 21" 100 0 0 100  foo bar ));
371
DESCR("addition");
372
DATA(insert OID = 177 (  int4pl			   PGUID 11 f t f 2 f 23 "23 23" 100 0 0 100  foo bar ));
373
DESCR("addition");
374
DATA(insert OID = 178 (  int24pl		   PGUID 11 f t f 2 f 23 "21 23" 100 0 0 100  foo bar ));
375
DESCR("addition");
376
DATA(insert OID = 179 (  int42pl		   PGUID 11 f t f 2 f 23 "23 21" 100 0 0 100  foo bar ));
377
DESCR("addition");
378
DATA(insert OID = 180 (  int2mi			   PGUID 11 f t f 2 f 21 "21 21" 100 0 0 100  foo bar ));
379
DESCR("subtract");
380
DATA(insert OID = 181 (  int4mi			   PGUID 11 f t f 2 f 23 "23 23" 100 0 0 100  foo bar ));
381
DESCR("subtract");
382
DATA(insert OID = 182 (  int24mi		   PGUID 11 f t f 2 f 23 "21 23" 100 0 0 100  foo bar ));
383
DESCR("subtract");
384
DATA(insert OID = 183 (  int42mi		   PGUID 11 f t f 2 f 23 "23 21" 100 0 0 100  foo bar ));
385
DESCR("subtract");
386
DATA(insert OID = 184 (  oideq			   PGUID 11 f t f 2 f 16 "26 26" 100 0 0 100  foo bar ));
387
DESCR("equal");
388
DATA(insert OID = 185 (  oidne			   PGUID 11 f t f 2 f 16 "26 26" 100 0 0 100  foo bar ));
389
DESCR("not equal");
390
DATA(insert OID = 186 (  box_same		   PGUID 11 f t f 2 f 16 "603 603" 100 0 0 100	foo bar ));
391
DESCR("same as");
392
DATA(insert OID = 187 (  box_contain	   PGUID 11 f t f 2 f 16 "603 603" 100 0 0 100	foo bar ));
393
DESCR("contains");
394
DATA(insert OID = 188 (  box_left		   PGUID 11 f t f 2 f 16 "603 603" 100 0 0 100	foo bar ));
395
DESCR("is left of");
396
DATA(insert OID = 189 (  box_overleft	   PGUID 11 f t f 2 f 16 "603 603" 100 0 0 100	foo bar ));
397
DESCR("overlaps, but does not extend to right of");
398
DATA(insert OID = 190 (  box_overright	   PGUID 11 f t f 2 f 16 "603 603" 100 0 0 100	foo bar ));
399
DESCR("overlaps, but does not extend to left of");
400
DATA(insert OID = 191 (  box_right		   PGUID 11 f t f 2 f 16 "603 603" 100 0 0 100	foo bar ));
401
DESCR("is left of");
402
DATA(insert OID = 192 (  box_contained	   PGUID 11 f t f 2 f 16 "603 603" 100 0 0 100	foo bar ));
403
DESCR("contained in");
404
DATA(insert OID = 193 (  rt_box_union	   PGUID 11 f t f 2 f 603 "603 603" 100 0 0 100  foo bar ));
405
DESCR("r-tree");
406
DATA(insert OID = 194 (  rt_box_inter	   PGUID 11 f t f 2 f 603 "603 603" 100 0 0 100  foo bar ));
407
DESCR("r-tree");
408
DATA(insert OID = 195 (  rt_box_size	   PGUID 11 f t f 2 f 700 "603 700" 100 0 0 100  foo bar ));
409
DESCR("r-tree");
410
DATA(insert OID = 196 (  rt_bigbox_size    PGUID 11 f t f 2 f 700 "603 700" 100 0 0 100  foo bar ));
411
DESCR("r-tree");
412
DATA(insert OID = 197 (  rt_poly_union	   PGUID 11 f t f 2 f 604 "604 604" 100 0 0 100  foo bar ));
413
DESCR("r-tree");
414
DATA(insert OID = 198 (  rt_poly_inter	   PGUID 11 f t f 2 f 604 "604 604" 100 0 0 100  foo bar ));
415
DESCR("r-tree");
416
DATA(insert OID = 199 (  rt_poly_size	   PGUID 11 f t f 2 f 23 "604 23" 100 0 0 100  foo bar ));
417
DESCR("r-tree");
418 419 420

/* OIDS 200 - 299 */

421
DATA(insert OID = 200 (  float4in		   PGUID 11 f t f 1 f 700 "0" 100 0 0 100  foo bar ));
422
DESCR("(internal)");
423
DATA(insert OID = 201 (  float4out		   PGUID 11 f t f 1 f 23  "0" 100 0 0 100  foo bar ));
424
DESCR("(internal)");
425
DATA(insert OID = 202 (  float4mul		   PGUID 11 f t f 2 f 700 "700 700" 100 0 0 100  foo bar ));
426
DESCR("multiply");
427
DATA(insert OID = 203 (  float4div		   PGUID 11 f t f 2 f 700 "700 700" 100 0 0 100  foo bar ));
428
DESCR("divide");
429
DATA(insert OID = 204 (  float4pl		   PGUID 11 f t f 2 f 700 "700 700" 100 0 0 100  foo bar ));
430
DESCR("addition");
431
DATA(insert OID = 205 (  float4mi		   PGUID 11 f t f 2 f 700 "700 700" 100 0 0 100  foo bar ));
432
DESCR("subtract");
433
DATA(insert OID = 206 (  float4um		   PGUID 11 f t f 1 f 700 "700" 100 0 0 100  foo bar ));
434
DESCR("subtract");
435
DATA(insert OID = 207 (  float4abs		   PGUID 11 f t f 1 f 700 "700 700" 100 0 0 100  foo bar ));
436
DESCR("absolute value");
437
DATA(insert OID = 208 (  float4inc		   PGUID 11 f t f 1 f 700 "700" 100 0 0 100  foo bar ));
438
DESCR("increment");
439
DATA(insert OID = 209 (  float4larger	   PGUID 11 f t f 2 f 700 "700 700" 100 0 0 100  foo bar ));
440
DESCR("larger of two");
441
DATA(insert OID = 211 (  float4smaller	   PGUID 11 f t f 2 f 700 "700 700" 100 0 0 100  foo bar ));
442
DESCR("smaller of two");
443 444

DATA(insert OID = 212 (  int4um			   PGUID 11 f t f 1 f 23 "23" 100 0 0 100  foo bar ));
445
DESCR("subtract");
446
DATA(insert OID = 213 (  int2um			   PGUID 11 f t f 1 f 21 "21" 100 0 0 100  foo bar ));
447
DESCR("subtract");
448 449

DATA(insert OID = 214 (  float8in		   PGUID 11 f t f 1 f 701 "0" 100 0 0 100  foo bar ));
450
DESCR("(internal)");
451
DATA(insert OID = 215 (  float8out		   PGUID 11 f t f 1 f 23  "0" 100 0 0 100  foo bar ));
452
DESCR("(internal)");
453
DATA(insert OID = 216 (  float8mul		   PGUID 11 f t f 2 f 701 "701 701" 100 0 0 100  foo bar ));
454
DESCR("multiply");
455
DATA(insert OID = 217 (  float8div		   PGUID 11 f t f 2 f 701 "701 701" 100 0 0 100  foo bar ));
456
DESCR("divide");
457
DATA(insert OID = 218 (  float8pl		   PGUID 11 f t f 2 f 701 "701 701" 100 0 0 100  foo bar ));
458
DESCR("addition");
459
DATA(insert OID = 219 (  float8mi		   PGUID 11 f t f 2 f 701 "701 701" 100 0 0 100  foo bar ));
460
DESCR("subtract");
461
DATA(insert OID = 220 (  float8um		   PGUID 11 f t f 1 f 701 "701" 100 0 0 100  foo bar ));
462
DESCR("subtract");
463
DATA(insert OID = 221 (  float8abs		   PGUID 11 f t f 1 f 701 "701" 100 0 0 100  foo bar ));
464
DESCR("absolute value");
465
DATA(insert OID = 222 (  float8inc		   PGUID 11 f t f 1 f 701 "701" 100 0 0 100  foo bar ));
466
DESCR("increment");
467
DATA(insert OID = 223 (  float8larger	   PGUID 11 f t f 2 f 701 "701 701" 100 0 0 100  foo bar ));
468
DESCR("larger of two");
469
DATA(insert OID = 224 (  float8smaller	   PGUID 11 f t f 2 f 701 "701 701" 100 0 0 100  foo bar ));
470
DESCR("smaller of two");
471 472

DATA(insert OID = 225 (  lseg_center	   PGUID 11 f t f 1 f 600 "601" 100 0 0 100  foo bar ));
473
DESCR("center of");
474
DATA(insert OID = 226 (  path_center	   PGUID 11 f t f 1 f 600 "602" 100 0 0 100  foo bar ));
475
DESCR("center of");
476
DATA(insert OID = 227 (  poly_center	   PGUID 11 f t f 1 f 600 "604" 100 0 0 100  foo bar ));
477
DESCR("center of");
478 479

DATA(insert OID = 228 (  dround			   PGUID 11 f t f 1 f 701 "701" 100 0 0 100  foo bar ));
480
DESCR("truncate to integer");
481
DATA(insert OID = 229 (  dtrunc			   PGUID 11 f t f 1 f 701 "701" 100 0 0 100  foo bar ));
482
DESCR("truncate to integer");
483
DATA(insert OID = 230 (  dsqrt			   PGUID 11 f t f 1 f 701 "701" 100 0 0 100  foo bar ));
484
DESCR("square root");
485
DATA(insert OID = 231 (  dcbrt			   PGUID 11 f t f 1 f 701 "701" 100 0 0 100  foo bar ));
486
DESCR("cube root");
487
DATA(insert OID = 232 (  dpow			   PGUID 11 f t f 2 f 701 "701 701" 100 0 0 100  foo bar ));
488
DESCR("exponentiation");
489
DATA(insert OID = 233 (  dexp			   PGUID 11 f t f 1 f 701 "701" 100 0 0 100  foo bar ));
490
DESCR("exponential");
491
DATA(insert OID = 234 (  dlog1			   PGUID 11 f t f 1 f 701 "701" 100 0 0 100  foo bar ));
492
DESCR("natural logarithm (in psql, protect with ()");
493 494

DATA(insert OID = 235 (  i2tod			   PGUID 11 f t f 1 f 701  "21" 100 0 0 100  foo bar ));
495
DESCR("convert int2 to float8");
496
DATA(insert OID = 236 (  i2tof			   PGUID 11 f t f 1 f 700  "21" 100 0 0 100  foo bar ));
497
DESCR("convert int2 to float4");
498
DATA(insert OID = 237 (  dtoi2			   PGUID 11 f t f 1 f  21 "701" 100 0 0 100  foo bar ));
499
DESCR("convert float8 to int2");
500
DATA(insert OID = 238 (  ftoi2			   PGUID 11 f t f 1 f  21 "700" 100 0 0 100  foo bar ));
501
DESCR("convert float4 to int2");
502
DATA(insert OID = 239 (  line_distance	   PGUID 11 f t f 2 f 701 "628 628" 100 0 0 100  foo bar ));
503
DESCR("distance between");
504 505

DATA(insert OID = 240 (  nabstimein		   PGUID 11 f t f 1 f 702 "0" 100 0 0 100  foo bar ));
506
DESCR("(internal)");
507
DATA(insert OID = 241 (  nabstimeout	   PGUID 11 f t f 1 f 23  "0" 100 0 0 100  foo bar ));
508
DESCR("(internal)");
509
DATA(insert OID = 242 (  reltimein		   PGUID 11 f t f 1 f 703 "0" 100 0 0 100  foo bar ));
510
DESCR("(internal)");
511
DATA(insert OID = 243 (  reltimeout		   PGUID 11 f t f 1 f 23  "0" 100 0 0 100  foo bar ));
512
DESCR("(internal)");
513
DATA(insert OID = 244 (  timepl			   PGUID 11 f t f 2 f 702 "702 703" 100 0 0 100  foo bar ));
514
DESCR("addition");
515
DATA(insert OID = 245 (  timemi			   PGUID 11 f t f 2 f 702 "702 703" 100 0 0 100  foo bar ));
516
DESCR("subtract");
517
DATA(insert OID = 246 (  tintervalin	   PGUID 11 f t f 1 f 704 "0" 100 0 0 100  foo bar ));
518
DESCR("(internal)");
519
DATA(insert OID = 247 (  tintervalout	   PGUID 11 f t f 1 f 23  "0" 100 0 0 100  foo bar ));
520
DESCR("(internal)");
521
DATA(insert OID = 248 (  ininterval		   PGUID 11 f t f 2 f 16 "702 704" 100 0 0 100	foo bar ));
522
DESCR("abstime in tinterval");
523
DATA(insert OID = 249 (  intervalrel	   PGUID 11 f t f 1 f 703 "704" 100 0 0 100  foo bar ));
524
DESCR("");
525
DATA(insert OID = 250 (  timenow		   PGUID 11 f t f 0 f 702 "0" 100 0 0 100  foo bar ));
526
DESCR("(internal)");
527
DATA(insert OID = 251 (  abstimeeq		   PGUID 11 f t f 2 f 16 "702 702" 100 0 0 100	foo bar ));
528
DESCR("equal");
529
DATA(insert OID = 252 (  abstimene		   PGUID 11 f t f 2 f 16 "702 702" 100 0 0 100	foo bar ));
530
DESCR("not equal");
531
DATA(insert OID = 253 (  abstimelt		   PGUID 11 f t f 2 f 16 "702 702" 100 0 0 100	foo bar ));
532
DESCR("less-than");
533
DATA(insert OID = 254 (  abstimegt		   PGUID 11 f t f 2 f 16 "702 702" 100 0 0 100	foo bar ));
534
DESCR("greater-than");
535
DATA(insert OID = 255 (  abstimele		   PGUID 11 f t f 2 f 16 "702 702" 100 0 0 100	foo bar ));
536
DESCR("less-than-or-equal");
537
DATA(insert OID = 256 (  abstimege		   PGUID 11 f t f 2 f 16 "702 702" 100 0 0 100	foo bar ));
538
DESCR("greater-than-or-equal");
539
DATA(insert OID = 257 (  reltimeeq		   PGUID 11 f t f 2 f 16 "703 703" 100 0 0 100	foo bar ));
540
DESCR("equal");
541
DATA(insert OID = 258 (  reltimene		   PGUID 11 f t f 2 f 16 "703 703" 100 0 0 100	foo bar ));
542
DESCR("not equal");
543
DATA(insert OID = 259 (  reltimelt		   PGUID 11 f t f 2 f 16 "703 703" 100 0 0 100	foo bar ));
544
DESCR("less-than");
545
DATA(insert OID = 260 (  reltimegt		   PGUID 11 f t f 2 f 16 "703 703" 100 0 0 100	foo bar ));
546
DESCR("greater-than");
547
DATA(insert OID = 261 (  reltimele		   PGUID 11 f t f 2 f 16 "703 703" 100 0 0 100	foo bar ));
548
DESCR("less-than-or-equal");
549
DATA(insert OID = 262 (  reltimege		   PGUID 11 f t f 2 f 16 "703 703" 100 0 0 100	foo bar ));
550
DESCR("greater-than-or-equal");
551
DATA(insert OID = 263 (  intervalsame	   PGUID 11 f t f 2 f 16 "704 704" 100 0 0 100	foo bar ));
552
DESCR("same as");
553
DATA(insert OID = 264 (  intervalct		   PGUID 11 f t f 2 f 16 "704 704" 100 0 0 100	foo bar ));
554
DESCR("less-than");
555
DATA(insert OID = 265 (  intervalov		   PGUID 11 f t f 2 f 16 "704 704" 100 0 0 100	foo bar ));
556
DESCR("overlaps");
557
DATA(insert OID = 266 (  intervalleneq	   PGUID 11 f t f 2 f 16 "704 703" 100 0 0 100	foo bar ));
558
DESCR("length equal");
559
DATA(insert OID = 267 (  intervallenne	   PGUID 11 f t f 2 f 16 "704 703" 100 0 0 100	foo bar ));
560
DESCR("length not equal to");
561
DATA(insert OID = 268 (  intervallenlt	   PGUID 11 f t f 2 f 16 "704 703" 100 0 0 100	foo bar ));
562
DESCR("length less-than");
563
DATA(insert OID = 269 (  intervallengt	   PGUID 11 f t f 2 f 16 "704 703" 100 0 0 100	foo bar ));
564
DESCR("length greater-than");
565
DATA(insert OID = 270 (  intervallenle	   PGUID 11 f t f 2 f 16 "704 703" 100 0 0 100	foo bar ));
566
DESCR("length less-than-or-equal");
567
DATA(insert OID = 271 (  intervallenge	   PGUID 11 f t f 2 f 16 "704 703" 100 0 0 100	foo bar ));
568
DESCR("length greater-than-or-equal");
569
DATA(insert OID = 272 (  intervalstart	   PGUID 11 f t f 1 f 702 "704" 100 0 0 100  foo bar ));
570
DESCR("start of interval");
571
DATA(insert OID = 273 (  intervalend	   PGUID 11 f t f 1 f 702 "704" 100 0 0 100  foo bar ));
572
DESCR("");
573
DATA(insert OID = 274 (  timeofday		   PGUID 11 f t f 0 f 25 "0" 100 0 0 100  foo bar ));
574
DESCR("(internal)");
575
DATA(insert OID = 275 (  abstime_finite    PGUID 11 f t f 1 f 16 "702" 100 0 0 100	foo bar ));
576
DESCR("");
577 578

DATA(insert OID = 276 (  int2fac		   PGUID 11 f t f 1 f 21 "21" 100 0 0 100  foo bar ));
579
DESCR("");
580

581
DATA(insert OID = 277 (  inter_sl		   PGUID 11 f t f 2 f 16 "601 628" 100 0 0 100	foo bar ));
582
DESCR("");
583
DATA(insert OID = 278 (  inter_lb		   PGUID 11 f t f 2 f 16 "628 603" 100 0 0 100	foo bar ));
584
DESCR("");
585 586

DATA(insert OID = 279 (  float48mul		   PGUID 11 f t f 2 f 701 "700 701" 100 0 0 100  foo bar ));
587
DESCR("multiply");
588
DATA(insert OID = 280 (  float48div		   PGUID 11 f t f 2 f 701 "700 701" 100 0 0 100  foo bar ));
589
DESCR("divide");
590
DATA(insert OID = 281 (  float48pl		   PGUID 11 f t f 2 f 701 "700 701" 100 0 0 100  foo bar ));
591
DESCR("addition");
592
DATA(insert OID = 282 (  float48mi		   PGUID 11 f t f 2 f 701 "700 701" 100 0 0 100  foo bar ));
593
DESCR("subtract");
594
DATA(insert OID = 283 (  float84mul		   PGUID 11 f t f 2 f 701 "701 700" 100 0 0 100  foo bar ));
595
DESCR("multiply");
596
DATA(insert OID = 284 (  float84div		   PGUID 11 f t f 2 f 701 "701 700" 100 0 0 100  foo bar ));
597
DESCR("divide");
598
DATA(insert OID = 285 (  float84pl		   PGUID 11 f t f 2 f 701 "701 700" 100 0 0 100  foo bar ));
599
DESCR("addition");
600
DATA(insert OID = 286 (  float84mi		   PGUID 11 f t f 2 f 701 "701 700" 100 0 0 100  foo bar ));
601
DESCR("subtract");
602

603
DATA(insert OID = 287 (  float4eq		   PGUID 11 f t f 2 f 16 "700 700" 100 0 0 100	foo bar ));
604
DESCR("equal");
605
DATA(insert OID = 288 (  float4ne		   PGUID 11 f t f 2 f 16 "700 700" 100 0 0 100	foo bar ));
606
DESCR("not equal");
607
DATA(insert OID = 289 (  float4lt		   PGUID 11 f t f 2 f 16 "700 700" 100 0 0 100	foo bar ));
608
DESCR("less-than");
609
DATA(insert OID = 290 (  float4le		   PGUID 11 f t f 2 f 16 "700 700" 100 0 0 100	foo bar ));
610
DESCR("less-than-or-equal");
611
DATA(insert OID = 291 (  float4gt		   PGUID 11 f t f 2 f 16 "700 700" 100 0 0 100	foo bar ));
612
DESCR("greater-than");
613
DATA(insert OID = 292 (  float4ge		   PGUID 11 f t f 2 f 16 "700 700" 100 0 0 100	foo bar ));
614
DESCR("greater-than-or-equal");
615

616
DATA(insert OID = 293 (  float8eq		   PGUID 11 f t f 2 f 16 "701 701" 100 0 0 100	foo bar ));
617
DESCR("equal");
618
DATA(insert OID = 294 (  float8ne		   PGUID 11 f t f 2 f 16 "701 701" 100 0 0 100	foo bar ));
619
DESCR("not equal");
620
DATA(insert OID = 295 (  float8lt		   PGUID 11 f t f 2 f 16 "701 701" 100 0 0 100	foo bar ));
621
DESCR("less-than");
622
DATA(insert OID = 296 (  float8le		   PGUID 11 f t f 2 f 16 "701 701" 100 0 0 100	foo bar ));
623
DESCR("less-than-or-equal");
624
DATA(insert OID = 297 (  float8gt		   PGUID 11 f t f 2 f 16 "701 701" 100 0 0 100	foo bar ));
625
DESCR("greater-than");
626
DATA(insert OID = 298 (  float8ge		   PGUID 11 f t f 2 f 16 "701 701" 100 0 0 100	foo bar ));
627
DESCR("greater-than-or-equal");
628

629
DATA(insert OID = 299 (  float48eq		   PGUID 11 f t f 2 f 16 "700 701" 100 0 0 100	foo bar ));
630
DESCR("equal");
631 632 633

/* OIDS 300 - 399 */

634
DATA(insert OID = 300 (  float48ne		   PGUID 11 f t f 2 f 16 "700 701" 100 0 0 100	foo bar ));
635
DESCR("not equal");
636
DATA(insert OID = 301 (  float48lt		   PGUID 11 f t f 2 f 16 "700 701" 100 0 0 100	foo bar ));
637
DESCR("less-than");
638
DATA(insert OID = 302 (  float48le		   PGUID 11 f t f 2 f 16 "700 701" 100 0 0 100	foo bar ));
639
DESCR("less-than-or-equal");
640
DATA(insert OID = 303 (  float48gt		   PGUID 11 f t f 2 f 16 "700 701" 100 0 0 100	foo bar ));
641
DESCR("greater-than");
642
DATA(insert OID = 304 (  float48ge		   PGUID 11 f t f 2 f 16 "700 701" 100 0 0 100	foo bar ));
643
DESCR("greater-than-or-equal");
644
DATA(insert OID = 305 (  float84eq		   PGUID 11 f t f 2 f 16 "701 700" 100 0 0 100	foo bar ));
645
DESCR("equal");
646
DATA(insert OID = 306 (  float84ne		   PGUID 11 f t f 2 f 16 "701 700" 100 0 0 100	foo bar ));
647
DESCR("not equal");
648
DATA(insert OID = 307 (  float84lt		   PGUID 11 f t f 2 f 16 "701 700" 100 0 0 100	foo bar ));
649
DESCR("less-than");
650
DATA(insert OID = 308 (  float84le		   PGUID 11 f t f 2 f 16 "701 700" 100 0 0 100	foo bar ));
651
DESCR("less-than-or-equal");
652
DATA(insert OID = 309 (  float84gt		   PGUID 11 f t f 2 f 16 "701 700" 100 0 0 100	foo bar ));
653
DESCR("greater-than");
654
DATA(insert OID = 310 (  float84ge		   PGUID 11 f t f 2 f 16 "701 700" 100 0 0 100	foo bar ));
655
DESCR("greater-than-or-equal");
656

657
DATA(insert OID = 311 (  ftod			   PGUID 11 f t f 1 f 701 "700" 100 0 0 100  foo bar ));
658
DESCR("convert float4 to float8");
659
DATA(insert OID = 312 (  dtof			   PGUID 11 f t f 1 f 700 "701" 100 0 0 100  foo bar ));
660
DESCR("convert float8 to float4");
661
DATA(insert OID = 313 (  i2toi4			   PGUID 11 f t f 1 f  23  "21" 100 0 0 100  foo bar ));
662
DESCR("convert int2 to int4");
663
DATA(insert OID = 314 (  i4toi2			   PGUID 11 f t f 1 f  21  "23" 100 0 0 100  foo bar ));
664
DESCR("convert int4 to int2");
665
DATA(insert OID = 315 (  keyfirsteq		   PGUID 11 f t f 2 f  16	"0 21" 100 0 0 100	foo bar ));
666
DESCR("");
667
DATA(insert OID = 316 (  i4tod			   PGUID 11 f t f 1 f 701  "23" 100 0 0 100  foo bar ));
668
DESCR("convert int4 to float8");
669
DATA(insert OID = 317 (  dtoi4			   PGUID 11 f t f 1 f  23 "701" 100 0 0 100  foo bar ));
670
DESCR("convert float8 to int4");
671
DATA(insert OID = 318 (  i4tof			   PGUID 11 f t f 1 f 700  "23" 100 0 0 100  foo bar ));
672
DESCR("convert int4 to float4");
673
DATA(insert OID = 319 (  ftoi4			   PGUID 11 f t f 1 f  23 "700" 100 0 0 100  foo bar ));
674
DESCR("convert float4 to int4");
675 676

DATA(insert OID = 320 (  rtinsert		   PGUID 11 f t f 5 f 23 "0" 100 0 0 100  foo bar ));
677
DESCR("r-tree(internal)");
678
DATA(insert OID = 321 (  rtdelete		   PGUID 11 f t f 2 f 23 "0" 100 0 0 100  foo bar ));
679
DESCR("r-tree(internal)");
680
DATA(insert OID = 322 (  rtgettuple		   PGUID 11 f t f 2 f 23 "0" 100 0 0 100  foo bar ));
681
DESCR("r-tree(internal)");
682
DATA(insert OID = 323 (  rtbuild		   PGUID 11 f t f 9 f 23 "0" 100 0 0 100  foo bar ));
683
DESCR("r-tree(internal)");
684
DATA(insert OID = 324 (  rtbeginscan	   PGUID 11 f t f 4 f 23 "0" 100 0 0 100  foo bar ));
685
DESCR("r-tree(internal)");
686
DATA(insert OID = 325 (  rtendscan		   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
687
DESCR("r-tree(internal)");
688
DATA(insert OID = 326 (  rtmarkpos		   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
689
DESCR("r-tree(internal)");
690
DATA(insert OID = 327 (  rtrestrpos		   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
691
DESCR("r-tree(internal)");
692
DATA(insert OID = 328 (  rtrescan		   PGUID 11 f t f 3 f 23 "0" 100 0 0 100  foo bar ));
693
DESCR("r-tree(internal)");
694 695

DATA(insert OID = 330 (  btgettuple		   PGUID 11 f t f 2 f 23 "0" 100 0 0 100  foo bar ));
696
DESCR("btree(internal)");
697
DATA(insert OID = 331 (  btinsert		   PGUID 11 f t f 5 f 23 "0" 100 0 0 100  foo bar ));
698
DESCR("btree(internal)");
699
DATA(insert OID = 332 (  btdelete		   PGUID 11 f t f 2 f 23 "0" 100 0 0 100  foo bar ));
700
DESCR("btree(internal)");
701
DATA(insert OID = 333 (  btbeginscan	   PGUID 11 f t f 4 f 23 "0" 100 0 0 100  foo bar ));
702
DESCR("btree(internal)");
703
DATA(insert OID = 334 (  btrescan		   PGUID 11 f t f 3 f 23 "0" 100 0 0 100  foo bar ));
704
DESCR("btree(internal)");
705
DATA(insert OID = 335 (  btendscan		   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
706
DESCR("btree(internal)");
707
DATA(insert OID = 336 (  btmarkpos		   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
708
DESCR("btree(internal)");
709
DATA(insert OID = 337 (  btrestrpos		   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
710
DESCR("btree(internal)");
711
DATA(insert OID = 338 (  btbuild		   PGUID 11 f t f 9 f 23 "0" 100 0 0 100  foo bar ));
712
DESCR("btree(internal)");
713
DATA(insert OID = 339 (  poly_same		   PGUID 11 f t f 2 f 16 "604 604" 100 0 1 0  foo bar ));
714
DESCR("same as");
715
DATA(insert OID = 340 (  poly_contain	   PGUID 11 f t f 2 f 16 "604 604" 100 0 1 0  foo bar ));
716
DESCR("contains");
717
DATA(insert OID = 341 (  poly_left		   PGUID 11 f t f 2 f 16 "604 604" 100 0 1 0  foo bar ));
718
DESCR("is left of");
719
DATA(insert OID = 342 (  poly_overleft	   PGUID 11 f t f 2 f 16 "604 604" 100 0 1 0  foo bar ));
720
DESCR("overlaps, but does not extend to right of");
721
DATA(insert OID = 343 (  poly_overright    PGUID 11 f t f 2 f 16 "604 604" 100 0 1 0  foo bar ));
722
DESCR("overlaps, but does not extend to left of");
723
DATA(insert OID = 344 (  poly_right		   PGUID 11 f t f 2 f 16 "604 604" 100 0 1 0  foo bar ));
724
DESCR("is left of");
725
DATA(insert OID = 345 (  poly_contained    PGUID 11 f t f 2 f 16 "604 604" 100 0 1 0  foo bar ));
726
DESCR("contained in");
727
DATA(insert OID = 346 (  poly_overlap	   PGUID 11 f t f 2 f 16 "604 604" 100 0 1 0  foo bar ));
728
DESCR("overlaps");
729
DATA(insert OID = 347 (  poly_in		   PGUID 11 f t f 1 f 604 "0" 100 0 1 0  foo bar ));
730
DESCR("(internal)");
731
DATA(insert OID = 348 (  poly_out		   PGUID 11 f t f 1 f 23  "0" 100 0 1 0  foo bar ));
732
DESCR("(internal)");
733 734

DATA(insert OID = 350 (  btint2cmp		   PGUID 11 f t f 2 f 23 "21 21" 100 0 0 100  foo bar ));
735
DESCR("btree less-equal-greater");
736
DATA(insert OID = 351 (  btint4cmp		   PGUID 11 f t f 2 f 23 "23 23" 100 0 0 100  foo bar ));
737
DESCR("btree less-equal-greater");
738 739
DATA(insert OID = 842 (  btint8cmp		   PGUID 11 f t f 2 f 23 "20 20" 100 0 0 100  foo bar ));
DESCR("btree less-equal-greater");
740
DATA(insert OID = 352 (  btint42cmp		   PGUID 11 f t f 2 f 23 "23 21" 100 0 0 100  foo bar ));
741
DESCR("btree less-equal-greater");
742
DATA(insert OID = 353 (  btint24cmp		   PGUID 11 f t f 2 f 23 "21 23" 100 0 0 100  foo bar ));
743
DESCR("btree less-equal-greater");
744
DATA(insert OID = 354 (  btfloat4cmp	   PGUID 11 f t f 2 f 23 "700 700" 100 0 0 100	foo bar ));
745
DESCR("btree less-equal-greater");
746
DATA(insert OID = 355 (  btfloat8cmp	   PGUID 11 f t f 2 f 23 "701 701" 100 0 0 100	foo bar ));
747
DESCR("btree less-equal-greater");
748
DATA(insert OID = 356 (  btoidcmp		   PGUID 11 f t f 2 f 23 "26 26" 100 0 0 100  foo bar ));
749
DESCR("btree less-equal-greater");
750 751
DATA(insert OID = 404 (  btoid8cmp		   PGUID 11 f t f 2 f 23 "30 30" 100 0 0 100  foo bar ));
DESCR("btree less-equal-greater");
752
DATA(insert OID = 357 (  btabstimecmp	   PGUID 11 f t f 2 f 23 "702 702" 100 0 0 100	foo bar ));
753
DESCR("btree less-equal-greater");
754
DATA(insert OID = 358 (  btcharcmp		   PGUID 11 f t f 2 f 23 "18 18" 100 0 0 100  foo bar ));
755
DESCR("btree less-equal-greater");
756
DATA(insert OID = 359 (  btnamecmp		   PGUID 11 f t f 2 f 23 "19 19" 100 0 0 100  foo bar ));
757
DESCR("btree less-equal-greater");
758
DATA(insert OID = 360 (  bttextcmp		   PGUID 11 f t f 2 f 23 "25 25" 100 0 0 100  foo bar ));
759
DESCR("btree less-equal-greater");
760 761

DATA(insert OID = 361 (  lseg_distance	   PGUID 11 f t f 2 f 701 "601 601" 100 0 0 100  foo bar ));
762
DESCR("distance between");
763
DATA(insert OID = 362 (  lseg_interpt	   PGUID 11 f t f 2 f 600 "601 601" 100 0 0 100  foo bar ));
764
DESCR("");
765
DATA(insert OID = 363 (  dist_ps		   PGUID 11 f t f 2 f 701 "600 601" 100 0 0 100  foo bar ));
766
DESCR("distance between");
767
DATA(insert OID = 364 (  dist_pb		   PGUID 11 f t f 2 f 701 "600 603" 100 0 0 100  foo bar ));
768
DESCR("distance between");
769
DATA(insert OID = 365 (  dist_sb		   PGUID 11 f t f 2 f 701 "601 603" 100 0 0 100  foo bar ));
770
DESCR("distance between");
771
DATA(insert OID = 366 (  close_ps		   PGUID 11 f t f 2 f 600 "600 601" 100 0 0 100  foo bar ));
772
DESCR("closest point on line segment");
773
DATA(insert OID = 367 (  close_pb		   PGUID 11 f t f 2 f 600 "600 603" 100 0 0 100  foo bar ));
774
DESCR("closest point on box");
775
DATA(insert OID = 368 (  close_sb		   PGUID 11 f t f 2 f 600 "601 603" 100 0 0 100  foo bar ));
776
DESCR("closest point to line segment on box");
777
DATA(insert OID = 369 (  on_ps			   PGUID 11 f t f 2 f 16 "600 601" 100 0 0 100	foo bar ));
778
DESCR("contained in");
779
DATA(insert OID = 370 (  path_distance	   PGUID 11 f t f 2 f 701 "602 602" 100 0 1 0 foo bar ));
780
DESCR("distance between");
781
DATA(insert OID = 371 (  dist_ppath		   PGUID 11 f t f 2 f 701 "600 602" 100 0 1 0 foo bar ));
782
DESCR("distance between");
783
DATA(insert OID = 372 (  on_sb			   PGUID 11 f t f 2 f 16 "601 603" 100 0 0 100	foo bar ));
784
DESCR("contained in");
785
DATA(insert OID = 373 (  inter_sb		   PGUID 11 f t f 2 f 16 "601 603" 100 0 0 100	foo bar ));
786
DESCR("");
787 788 789

/* OIDS 400 - 499 */

790
DATA(insert OID =  406 (  name_text		   PGUID 11 f t f 1 f	25 "19" 100 0 0 100 foo bar ));
791
DESCR("convert name to text");
792
DATA(insert OID =  407 (  text_name		   PGUID 11 f t f 1 f	19 "25" 100 0 0 100 foo bar ));
793
DESCR("convert text to name");
794
DATA(insert OID =  408 (  name_bpchar	   PGUID 11 f t f 1 f 1042 "19" 100 0 0 100 foo bar ));
795
DESCR("convert name to char()");
796
DATA(insert OID =  409 (  bpchar_name	   PGUID 11 f t f 1 f	19 "1042" 100 0 0 100	foo bar ));
797
DESCR("convert char() to name");
798

799
DATA(insert OID =  438 (  hashsel		   PGUID 11 f t t 7 f 701 "26 26 21 0 23 23 26" 100 0 0 100  foo bar ));
800
DESCR("selectivity");
801
DATA(insert OID =  439 (  hashnpage		   PGUID 11 f t t 7 f 701 "26 26 21 0 23 23 26" 100 0 0 100  foo bar ));
802
DESCR("hash");
803 804

DATA(insert OID = 440 (  hashgettuple	   PGUID 11 f t f 2 f 23 "0" 100 0 0 100  foo bar ));
805
DESCR("hash(internal)");
806
DATA(insert OID = 441 (  hashinsert		   PGUID 11 f t f 5 f 23 "0" 100 0 0 100  foo bar ));
807
DESCR("hash(internal)");
808
DATA(insert OID = 442 (  hashdelete		   PGUID 11 f t f 2 f 23 "0" 100 0 0 100  foo bar ));
809
DESCR("hash(internal)");
810
DATA(insert OID = 443 (  hashbeginscan	   PGUID 11 f t f 4 f 23 "0" 100 0 0 100  foo bar ));
811
DESCR("hash(internal)");
812
DATA(insert OID = 444 (  hashrescan		   PGUID 11 f t f 3 f 23 "0" 100 0 0 100  foo bar ));
813
DESCR("hash(internal)");
814
DATA(insert OID = 445 (  hashendscan	   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
815
DESCR("hash(internal)");
816
DATA(insert OID = 446 (  hashmarkpos	   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
817
DESCR("hash(internal)");
818
DATA(insert OID = 447 (  hashrestrpos	   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
819
DESCR("hash(internal)");
820
DATA(insert OID = 448 (  hashbuild		   PGUID 11 f t f 9 f 23 "0" 100 0 0 100  foo bar ));
821
DESCR("hash(internal)");
822
DATA(insert OID = 449 (  hashint2		   PGUID 11 f t f 1 f 23 "21" 100 0 0 100  foo bar ));
823
DESCR("hash");
824
DATA(insert OID = 450 (  hashint4		   PGUID 11 f t f 1 f 23 "23" 100 0 0 100  foo bar ));
825
DESCR("hash");
826
DATA(insert OID = 949 (  hashint8		   PGUID 11 f t f 1 f 23 "20" 100 0 0 100  foo bar ));
827
DESCR("hash");
828
DATA(insert OID = 451 (  hashfloat4		   PGUID 11 f t f 1 f 23 "700" 100 0 0 100	foo bar ));
829
DESCR("hash");
830
DATA(insert OID = 452 (  hashfloat8		   PGUID 11 f t f 1 f 23 "701" 100 0 0 100	foo bar ));
831
DESCR("hash");
832
DATA(insert OID = 453 (  hashoid		   PGUID 11 f t f 1 f 23 "26" 100 0 0 100  foo bar ));
833
DESCR("hash");
834
DATA(insert OID = 454 (  hashchar		   PGUID 11 f t f 1 f 23 "18" 100 0 0 100  foo bar ));
835
DESCR("hash");
836
DATA(insert OID = 455 (  hashname		   PGUID 11 f t f 1 f 23 "19" 100 0 0 100  foo bar ));
837
DESCR("hash");
838
DATA(insert OID = 456 (  hashtext		   PGUID 11 f t f 1 f 23 "25" 100 0 0 100  foo bar ));
839
DESCR("hash");
840
DATA(insert OID = 457 (  hashoid8		   PGUID 11 f t f 1 f 23 "30" 100 0 0 100  foo bar ));
841 842 843 844 845
DESCR("hash");
DATA(insert OID = 458 (  text_larger	   PGUID 11 f t f 2 f 25 "25 25" 100 0 0 100  foo bar ));
DESCR("larger of two");
DATA(insert OID = 459 (  text_smaller	   PGUID 11 f t f 2 f 25 "25 25" 100 0 0 100  foo bar ));
DESCR("smaller of two");
846

847 848
DATA(insert OID = 460 (  int8in			   PGUID 11 f t f 1 f 20 "0" 100 0 0 100  foo bar ));
DESCR("(internal)");
849
DATA(insert OID = 461 (  int8out		   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
850 851 852 853 854 855 856 857 858 859 860 861 862 863 864 865 866 867 868 869
DESCR("(internal)");
DATA(insert OID = 462 (  int8um			   PGUID 11 f t f 1 f 20 "20" 100 0 0 100  foo bar ));
DESCR("unary minus");
DATA(insert OID = 463 (  int8pl			   PGUID 11 f t f 2 f 20 "20 20" 100 0 0 100  foo bar ));
DESCR("addition");
DATA(insert OID = 464 (  int8mi			   PGUID 11 f t f 2 f 20 "20 20" 100 0 0 100  foo bar ));
DESCR("subtraction");
DATA(insert OID = 465 (  int8mul		   PGUID 11 f t f 2 f 20 "20 20" 100 0 0 100  foo bar ));
DESCR("multiply");
DATA(insert OID = 466 (  int8div		   PGUID 11 f t f 2 f 20 "20 20" 100 0 0 100  foo bar ));
DESCR("divide");
DATA(insert OID = 467 (  int8eq			   PGUID 11 f t f 2 f 16 "20 20" 100 0 0 100  foo bar ));
DESCR("equal");
DATA(insert OID = 468 (  int8ne			   PGUID 11 f t f 2 f 16 "20 20" 100 0 0 100  foo bar ));
DESCR("not equal");
DATA(insert OID = 469 (  int8lt			   PGUID 11 f t f 2 f 16 "20 20" 100 0 0 100  foo bar ));
DESCR("less-than");
DATA(insert OID = 470 (  int8gt			   PGUID 11 f t f 2 f 16 "20 20" 100 0 0 100  foo bar ));
DESCR("greater-than");
DATA(insert OID = 471 (  int8le			   PGUID 11 f t f 2 f 16 "20 20" 100 0 0 100  foo bar ));
870
DESCR("less-than-or-equal");
871
DATA(insert OID = 472 (  int8ge			   PGUID 11 f t f 2 f 16 "20 20" 100 0 0 100  foo bar ));
872
DESCR("greater-than-or-equal");
873 874 875 876 877 878 879 880 881 882

DATA(insert OID = 474 (  int84eq		   PGUID 11 f t f 2 f 16 "20 23" 100 0 0 100  foo bar ));
DESCR("equal");
DATA(insert OID = 475 (  int84ne		   PGUID 11 f t f 2 f 16 "20 23" 100 0 0 100  foo bar ));
DESCR("not equal");
DATA(insert OID = 476 (  int84lt		   PGUID 11 f t f 2 f 16 "20 23" 100 0 0 100  foo bar ));
DESCR("less-than");
DATA(insert OID = 477 (  int84gt		   PGUID 11 f t f 2 f 16 "20 23" 100 0 0 100  foo bar ));
DESCR("greater-than");
DATA(insert OID = 478 (  int84le		   PGUID 11 f t f 2 f 16 "20 23" 100 0 0 100  foo bar ));
883
DESCR("less-than-or-equal");
884
DATA(insert OID = 479 (  int84ge		   PGUID 11 f t f 2 f 16 "20 23" 100 0 0 100  foo bar ));
885
DESCR("greater-than-or-equal");
886

887
DATA(insert OID = 480 (  int84			   PGUID 11 f t f 1 f  23 "20" 100 0 0 100	foo bar ));
888
DESCR("convert int8 to int4");
889
DATA(insert OID = 481 (  int48			   PGUID 11 f t f 1 f  20 "23" 100 0 0 100	foo bar ));
890
DESCR("convert int4 to int8");
891
DATA(insert OID = 482 (  i8tod			   PGUID 11 f t f 1 f 701 "20" 100 0 0 100	foo bar ));
892 893 894 895
DESCR("convert int8 to float8");
DATA(insert OID = 483 (  dtoi8			   PGUID 11 f t f 1 f  20 "701" 100 0 0 100  foo bar ));
DESCR("convert float8 to int8");

896 897 898 899
/* OIDS 500 - 599 */

/* OIDS 600 - 699 */

900
DATA(insert OID = 1285 (  int4notin		   PGUID 11 f t f 2 f 16 "23 0" 100 0 0 100  foo bar ));
901
DESCR("not in");
902
DATA(insert OID = 1286 (  oidnotin		   PGUID 11 f t f 2 f 16 "26 0" 100 0 0 100  foo bar ));
903
DESCR("not in");
904
DATA(insert OID = 1287 (  int44in		   PGUID 11 f t f 1 f 22 "0" 100 0 0 100  foo bar ));
905
DESCR("(internal)");
906
DATA(insert OID = 653 (  int44out		   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
907
DESCR("(internal)");
908
DATA(insert OID = 655 (  namelt			   PGUID 11 f t f 2 f 16 "19 19" 100 0 0 100  foo bar ));
909
DESCR("less-than");
910
DATA(insert OID = 656 (  namele			   PGUID 11 f t f 2 f 16 "19 19" 100 0 0 100  foo bar ));
911
DESCR("less-than-or-equal");
912
DATA(insert OID = 657 (  namegt			   PGUID 11 f t f 2 f 16 "19 19" 100 0 0 100  foo bar ));
913
DESCR("greater-than");
914
DATA(insert OID = 658 (  namege			   PGUID 11 f t f 2 f 16 "19 19" 100 0 0 100  foo bar ));
915
DESCR("greater-than-or-equal");
916
DATA(insert OID = 659 (  namene			   PGUID 11 f t f 2 f 16 "19 19" 100 0 0 100  foo bar ));
917
DESCR("not equal");
918 919

DATA(insert OID = 668 (  bpchar			   PGUID 11 f t f 2 f 1042 "1042 23" 100 0 0 100  foo bar ));
920
DESCR("truncate char()");
921
DATA(insert OID = 669 (  varchar		   PGUID 11 f t f 2 f 1043 "1043 23" 100 0 0 100  foo bar ));
922
DESCR("truncate varchar()");
923

924
DATA(insert OID = 676 (  mktinterval	   PGUID 11 f t f 2 f 704 "702 702" 100 0 0 100 foo bar ));
925
DESCR("convert to interval");
T
Tom Lane 已提交
926
DATA(insert OID = 619 (  oid8ne			   PGUID 11 f t f 2 f 16 "30 30" 100 0 0 100  foo bar ));
B
Bruce Momjian 已提交
927
DESCR("less-than");
928 929 930 931 932
DATA(insert OID = 677 (  oid8lt			   PGUID 11 f t f 2 f 16 "30 30" 100 0 0 100  foo bar ));
DESCR("less-than");
DATA(insert OID = 678 (  oid8le			   PGUID 11 f t f 2 f 16 "30 30" 100 0 0 100  foo bar ));
DESCR("less-than-or-equal");
DATA(insert OID = 679 (  oid8eq			   PGUID 11 f t f 2 f 16 "30 30" 100 0 0 100  foo bar ));
933
DESCR("equal");
934 935 936 937
DATA(insert OID = 680 (  oid8ge			   PGUID 11 f t f 2 f 16 "30 30" 100 0 0 100  foo bar ));
DESCR("greater-than-or-equal");
DATA(insert OID = 681 (  oid8gt			   PGUID 11 f t f 2 f 16 "30 30" 100 0 0 100  foo bar ));
DESCR("greater-than");
938 939

/* OIDS 700 - 799 */
940
DATA(insert OID = 710 (  getpgusername	   PGUID 11 f t f 0 f 19 "0" 100 0 0 100  foo bar ));
941
DESCR("(internal)");
942
DATA(insert OID = 711 (  userfntest		   PGUID 11 f t f 1 f 23 "23" 100 0 0 100  foo bar ));
943
DESCR("");
944
DATA(insert OID = 713 (  oidrand		   PGUID 11 f t f 2 f 16 "26 23" 100 0 0 100  foo bar ));
945
DESCR("random");
946
DATA(insert OID = 715 (  oidsrand		   PGUID 11 f t f 1 f 16 "23" 100 0 0 100  foo bar ));
947
DESCR("seed random number generator");
948
DATA(insert OID = 716 (  oideqint4		   PGUID 11 f t f 2 f 16 "26 23" 100 0 0 100  foo bar ));
949
DESCR("equal");
950
DATA(insert OID = 717 (  int4eqoid		   PGUID 11 f t f 2 f 16 "23 26" 100 0 0 100  foo bar ));
951
DESCR("equal");
952 953

DATA(insert OID = 720 (  byteaGetSize	   PGUID 11 f t f 1 f 23 "17" 100 0 0 100  foo bar ));
954
DESCR("");
955
DATA(insert OID = 721 (  byteaGetByte	   PGUID 11 f t f 2 f 23 "17 23" 100 0 0 100  foo bar ));
956
DESCR("");
957
DATA(insert OID = 722 (  byteaSetByte	   PGUID 11 f t f 3 f 17 "17 23 23" 100 0 0 100  foo bar ));
958
DESCR("");
959
DATA(insert OID = 723 (  byteaGetBit	   PGUID 11 f t f 2 f 23 "17 23" 100 0 0 100  foo bar ));
960
DESCR("");
961
DATA(insert OID = 724 (  byteaSetBit	   PGUID 11 f t f 3 f 17 "17 23 23" 100 0 0 100  foo bar ));
962
DESCR("");
963

964
DATA(insert OID = 725 (  dist_pl		   PGUID 11 f t f 2 f 701 "600 628" 100 0 0 100  foo bar ));
965
DESCR("distance between");
966
DATA(insert OID = 726 (  dist_lb		   PGUID 11 f t f 2 f 701 "628 603" 100 0 0 100  foo bar ));
967
DESCR("distance between");
968
DATA(insert OID = 727 (  dist_sl		   PGUID 11 f t f 2 f 701 "601 628" 100 0 0 100  foo bar ));
969
DESCR("distance between");
970
DATA(insert OID = 728 (  dist_cpoly		   PGUID 11 f t f 2 f 701 "718 604" 100 0 0 100  foo bar ));
971
DESCR("distance between");
972
DATA(insert OID = 729 (  poly_distance	   PGUID 11 f t f 2 f 701 "604 604" 100 0 0 100  foo bar ));
973
DESCR("distance between");
974 975

DATA(insert OID = 730 (  pqtest			   PGUID 11 f t f 1 f 23 "25" 100 0 0 100  foo bar ));
976
DESCR("");
977

978
DATA(insert OID = 740 (  text_lt		   PGUID 11 f t f 2 f 16 "25 25" 100 0 0 0	foo bar ));
979
DESCR("less-than");
980
DATA(insert OID = 741 (  text_le		   PGUID 11 f t f 2 f 16 "25 25" 100 0 0 0	foo bar ));
981
DESCR("less-than-or-equal");
982
DATA(insert OID = 742 (  text_gt		   PGUID 11 f t f 2 f 16 "25 25" 100 0 0 0	foo bar ));
983
DESCR("greater-than");
984
DATA(insert OID = 743 (  text_ge		   PGUID 11 f t f 2 f 16 "25 25" 100 0 0 0	foo bar ));
985
DESCR("greater-than-or-equal");
986 987

DATA(insert OID = 744 (  array_eq		   PGUID 11 f t f 2 f 16 "0 0" 100 0 0 100 foo bar));
988
DESCR("equal");
989
DATA(insert OID = 745 (  array_assgn	   PGUID 11 f t f 8 f 23 "0 23 0 0 0 23 23 0" 100 0 0 100 foo bar));
990
DESCR("array");
991
DATA(insert OID = 746 (  array_clip		   PGUID 11 f t f 7 f 23 "0 23 0 0 23 23 0" 100 0 0 100 foo bar));
992
DESCR("array");
993
DATA(insert OID = 747 (  array_dims		   PGUID 11 f t f 1 f 25 "0" 100 0 0 100 foo bar));
994
DESCR("array(internal)");
995
DATA(insert OID = 748 (  array_set		   PGUID 11 f t f 8 f 23 "0 23 0 0 23 23 23 0" 100 0 0 100 foo bar));
996
DESCR("array");
997
DATA(insert OID = 749 (  array_ref		   PGUID 11 f t f 7 f 23 "0 23 0 23 23 23 0" 100 0 0 100 foo bar));
998
DESCR("array");
999
DATA(insert OID = 750 (  array_in		   PGUID 11 f t f 2 f 23 "0 0" 100 0 0 100	foo bar ));
1000
DESCR("array");
1001
DATA(insert OID = 751 (  array_out		   PGUID 11 f t f 2 f 23 "0 0" 100 0 0 100	foo bar ));
1002
DESCR("array");
1003 1004

DATA(insert OID = 752 (  filename_in	   PGUID 11 f t f 2 f 605 "0" 100 0 0 100  foo bar ));
1005
DESCR("(internal)");
1006
DATA(insert OID = 753 (  filename_out	   PGUID 11 f t f 2 f 19  "0" 100 0 0 100  foo bar ));
1007
DESCR("(internal)");
1008 1009

DATA(insert OID = 760 (  smgrin			   PGUID 11 f t f 1 f 210 "0" 100 0 0 100  foo bar ));
1010
DESCR("storage manager(internal)");
1011
DATA(insert OID = 761 (  smgrout		   PGUID 11 f t f 1 f 23  "0" 100 0 0 100  foo bar ));
1012
DESCR("storage manager(internal)");
1013
DATA(insert OID = 762 (  smgreq			   PGUID 11 f t f 2 f 16 "210 210" 100 0 0 100	foo bar ));
1014
DESCR("storage manager");
1015
DATA(insert OID = 763 (  smgrne			   PGUID 11 f t f 2 f 16 "210 210" 100 0 0 100	foo bar ));
1016
DESCR("storage manager");
1017 1018

DATA(insert OID = 764 (  lo_import		   PGUID 11 f t f 1 f 26 "25" 100 0 0 100  foo bar ));
1019
DESCR("large object import");
1020
DATA(insert OID = 765 (  lo_export		   PGUID 11 f t f 2 f 23 "26 25" 100 0 0 100  foo bar ));
1021
DESCR("large object export");
1022 1023

DATA(insert OID = 766 (  int4inc		   PGUID 11 f t f 1 f 23 "23" 100 0 0 100  foo bar ));
1024
DESCR("increment");
1025
DATA(insert OID = 767 (  int2inc		   PGUID 11 f t f 1 f 21 "21" 100 0 0 100  foo bar ));
1026
DESCR("increment");
1027
DATA(insert OID = 768 (  int4larger		   PGUID 11 f t f 2 f 23 "23 23" 100 0 0 100  foo bar ));
1028
DESCR("larger of two");
1029
DATA(insert OID = 769 (  int4smaller	   PGUID 11 f t f 2 f 23 "23 23" 100 0 0 100  foo bar ));
1030
DESCR("smaller of two");
1031
DATA(insert OID = 770 (  int2larger		   PGUID 11 f t f 2 f 21 "21 21" 100 0 0 100  foo bar ));
1032
DESCR("larger of two");
1033
DATA(insert OID = 771 (  int2smaller	   PGUID 11 f t f 2 f 21 "21 21" 100 0 0 100  foo bar ));
1034
DESCR("smaller of two");
1035
DATA(insert OID = 772 (  gistsel		   PGUID 11 f t t 7 f 701 "26 26 21 0 23 23 26" 100 0 0 100  foo bar ));
1036
DESCR("gist selectivity");
1037
DATA(insert OID = 773 (  gistnpage		   PGUID 11 f t t 7 f 701 "26 26 21 0 23 23 26" 100 0 0 100  foo bar ));
1038
DESCR("gist");
1039
DATA(insert OID = 774 (  gistgettuple	   PGUID 11 f t f 2 f 23 "0" 100 0 0 100  foo bar ));
1040
DESCR("gist(internal)");
1041
DATA(insert OID = 775 (  gistinsert		   PGUID 11 f t f 5 f 23 "0" 100 0 0 100  foo bar ));
1042
DESCR("gist(internal)");
1043
DATA(insert OID = 776 (  gistdelete		   PGUID 11 f t f 2 f 23 "0" 100 0 0 100  foo bar ));
1044
DESCR("gist(internal)");
1045
DATA(insert OID = 777 (  gistbeginscan	   PGUID 11 f t f 4 f 23 "0" 100 0 0 100  foo bar ));
1046
DESCR("gist(internal)");
1047
DATA(insert OID = 778 (  gistrescan		   PGUID 11 f t f 3 f 23 "0" 100 0 0 100  foo bar ));
1048
DESCR("gist(internal)");
1049
DATA(insert OID = 779 (  gistendscan	   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
1050
DESCR("gist(internal)");
1051
DATA(insert OID = 780 (  gistmarkpos	   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
1052
DESCR("gist(internal)");
1053
DATA(insert OID = 781 (  gistrestrpos	   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
1054
DESCR("gist(internal)");
1055
DATA(insert OID = 782 (  gistbuild		   PGUID 11 f t f 9 f 23 "0" 100 0 0 100  foo bar ));
1056
DESCR("gist(internal)");
1057

1058
DATA(insert OID = 784 (  intervaleq		   PGUID 11 f t f 2 f 16 "704 704" 100 0 0 100	foo bar ));
1059
DESCR("equal");
1060
DATA(insert OID = 785 (  intervalne		   PGUID 11 f t f 2 f 16 "704 704" 100 0 0 100	foo bar ));
1061
DESCR("not equal");
1062
DATA(insert OID = 786 (  intervallt		   PGUID 11 f t f 2 f 16 "704 704" 100 0 0 100	foo bar ));
1063
DESCR("less-than");
1064
DATA(insert OID = 787 (  intervalgt		   PGUID 11 f t f 2 f 16 "704 704" 100 0 0 100	foo bar ));
1065
DESCR("greater-than");
1066
DATA(insert OID = 788 (  intervalle		   PGUID 11 f t f 2 f 16 "704 704" 100 0 0 100	foo bar ));
1067
DESCR("less-than-or-equal");
1068
DATA(insert OID = 789 (  intervalge		   PGUID 11 f t f 2 f 16 "704 704" 100 0 0 100	foo bar ));
1069
DESCR("greater-than-or-equal");
1070

1071
/* OIDS 800 - 899 */
1072

1073
DATA(insert OID = 817 (  text_oid		   PGUID 11 f t f 1 f 26 "25" 100 0 0 100  foo bar));
1074
DESCR("convert text to oid");
1075
DATA(insert OID = 818 (  text_int2		   PGUID 11 f t f 1 f 21 "25" 100 0 0 100  foo bar));
1076
DESCR("convert text to int2");
1077
DATA(insert OID = 819 (  text_int4		   PGUID 11 f t f 1 f 23 "25" 100 0 0 100  foo bar));
1078
DESCR("convert text to int4");
1079

1080
DATA(insert OID = 838 (  text_float8	   PGUID 11 f t f 1 f 701 "25" 100 0 0 100  foo bar));
1081
DESCR("convert text to float8");
1082
DATA(insert OID = 839 (  text_float4	   PGUID 11 f t f 1 f 700 "25" 100 0 0 100  foo bar));
1083
DESCR("convert text to float4");
1084
DATA(insert OID = 840 (  float8_text	   PGUID 11 f t f 1 f  25 "701" 100 0 0 100  foo bar));
1085
DESCR("convert float8 to text");
1086
DATA(insert OID = 841 (  float4_text	   PGUID 11 f t f 1 f  25 "700" 100 0 0 100  foo bar));
1087
DESCR("convert float4 to text");
1088

1089
DATA(insert OID =  846 (  cash_mul_flt4    PGUID 11 f t f 2 f 790 "790 700" 100 0 0 100  foo bar ));
1090
DESCR("multiply");
1091
DATA(insert OID =  847 (  cash_div_flt4    PGUID 11 f t f 2 f 790 "790 700" 100 0 0 100  foo bar ));
1092
DESCR("divide");
1093
DATA(insert OID =  848 (  flt4_mul_cash    PGUID 11 f t f 2 f 790 "700 790" 100 0 0 100  foo bar ));
1094
DESCR("multiply");
1095

1096 1097 1098 1099 1100 1101 1102
DATA(insert OID =  849 (  textpos		   PGUID 11 f t f 2 f 23 "25 25" 100 0 1 0 foo bar ));
DESCR("return position of substring");
DATA(insert OID =  850 (  textlike		   PGUID 11 f t f 2 f 16 "25 25" 100 0 1 0 foo bar ));
DESCR("matches LIKE expression");
DATA(insert OID =  851 (  textnlike		   PGUID 11 f t f 2 f 16 "25 25" 100 0 1 0 foo bar ));
DESCR("does not match LIKE expression");

1103
DATA(insert OID =  852 (  int48eq		   PGUID 11 f t f 2 f 16 "23 20" 100 0 0 100  foo bar ));
1104
DESCR("equal");
1105
DATA(insert OID =  853 (  int48ne		   PGUID 11 f t f 2 f 16 "23 20" 100 0 0 100  foo bar ));
1106
DESCR("not equal");
1107
DATA(insert OID =  854 (  int48lt		   PGUID 11 f t f 2 f 16 "23 20" 100 0 0 100  foo bar ));
1108
DESCR("less-than");
1109
DATA(insert OID =  855 (  int48gt		   PGUID 11 f t f 2 f 16 "23 20" 100 0 0 100  foo bar ));
1110
DESCR("greater-than");
1111
DATA(insert OID =  856 (  int48le		   PGUID 11 f t f 2 f 16 "23 20" 100 0 0 100  foo bar ));
1112
DESCR("less-than-or-equal");
1113
DATA(insert OID =  857 (  int48ge		   PGUID 11 f t f 2 f 16 "23 20" 100 0 0 100  foo bar ));
1114
DESCR("greater-than-or-equal");
1115

1116 1117 1118 1119 1120
DATA(insert OID =  858 (  namelike		   PGUID 11 f t f 2 f 16 "19 25" 100 0 0 100  foo bar ));
DESCR("matches LIKE expression");
DATA(insert OID =  859 (  namenlike		   PGUID 11 f t f 2 f 16 "19 25" 100 0 0 100  foo bar ));
DESCR("does not match LIKE expression");

1121
DATA(insert OID =  860 (  char_bpchar	   PGUID 11 f t f 1 f 1042 "18" 100 0 0 100  foo bar ));
1122
DESCR("convert char to char()");
1123
DATA(insert OID =  861 (  bpchar_char	   PGUID 11 f t f 1 f	18 "1042" 100 0 0 100  foo bar ));
1124
DESCR("convert char() to char");
1125

1126
DATA(insert OID =  862 (  int4_mul_cash		   PGUID 11 f t f 2 f 790 "23 790" 100 0 0 100	foo bar ));
1127
DESCR("multiply");
1128
DATA(insert OID =  863 (  int2_mul_cash		   PGUID 11 f t f 2 f 790 "21 790" 100 0 0 100	foo bar ));
1129
DESCR("multiply");
1130
DATA(insert OID =  864 (  cash_mul_int4		   PGUID 11 f t f 2 f 790 "790 23" 100 0 0 100	foo bar ));
1131
DESCR("multiply");
1132
DATA(insert OID =  865 (  cash_div_int4		   PGUID 11 f t f 2 f 790 "790 23" 100 0 0 100	foo bar ));
1133
DESCR("divide");
1134
DATA(insert OID =  866 (  cash_mul_int2		   PGUID 11 f t f 2 f 790 "790 21" 100 0 0 100	foo bar ));
1135
DESCR("multiply");
1136
DATA(insert OID =  867 (  cash_div_int2		   PGUID 11 f t f 2 f 790 "790 21" 100 0 0 100	foo bar ));
1137
DESCR("divide");
1138

1139
DATA(insert OID =  886 (  cash_in		   PGUID 11 f t f 1 f 790 "0" 100 0 0 100  foo bar ));
1140
DESCR("(internal)");
1141
DATA(insert OID =  887 (  cash_out		   PGUID 11 f t f 1 f  23 "0" 100 0 0 100  foo bar ));
1142
DESCR("(internal)");
B
Bruce Momjian 已提交
1143
DATA(insert OID =  1273 (  cash_words_out  PGUID 11 f t f 1 f  25 "790" 100 0 0 100  foo bar ));
1144
DESCR("output amount as words");
1145
DATA(insert OID =  888 (  cash_eq		   PGUID 11 f t f 2 f  16 "790 790" 100 0 0 100  foo bar ));
1146
DESCR("equal");
1147
DATA(insert OID =  889 (  cash_ne		   PGUID 11 f t f 2 f  16 "790 790" 100 0 0 100  foo bar ));
1148
DESCR("not equal");
1149
DATA(insert OID =  890 (  cash_lt		   PGUID 11 f t f 2 f  16 "790 790" 100 0 0 100  foo bar ));
1150
DESCR("less-than");
1151
DATA(insert OID =  891 (  cash_le		   PGUID 11 f t f 2 f  16 "790 790" 100 0 0 100  foo bar ));
1152
DESCR("less-than-or-equal");
1153
DATA(insert OID =  892 (  cash_gt		   PGUID 11 f t f 2 f  16 "790 790" 100 0 0 100  foo bar ));
1154
DESCR("greater-than");
1155
DATA(insert OID =  893 (  cash_ge		   PGUID 11 f t f 2 f  16 "790 790" 100 0 0 100  foo bar ));
1156
DESCR("greater-than-or-equal");
1157
DATA(insert OID =  894 (  cash_pl		   PGUID 11 f t f 2 f 790 "790 790" 100 0 0 100  foo bar ));
1158
DESCR("addition");
1159
DATA(insert OID =  895 (  cash_mi		   PGUID 11 f t f 2 f 790 "790 790" 100 0 0 100  foo bar ));
1160
DESCR("subtract");
1161
DATA(insert OID =  896 (  cash_mul_flt8		   PGUID 11 f t f 2 f 790 "790 701" 100 0 0 100  foo bar ));
1162
DESCR("multiply");
1163
DATA(insert OID =  897 (  cash_div_flt8		   PGUID 11 f t f 2 f 790 "790 701" 100 0 0 100  foo bar ));
1164
DESCR("divide");
1165
DATA(insert OID =  898 (  cashlarger	   PGUID 11 f t f 2 f 790 "790 790" 100 0 0 100  foo bar ));
1166
DESCR("larger of two");
1167
DATA(insert OID =  899 (  cashsmaller	   PGUID 11 f t f 2 f 790 "790 790" 100 0 0 100  foo bar ));
1168
DESCR("smaller of two");
1169

1170
DATA(insert OID =  919 (  flt8_mul_cash		   PGUID 11 f t f 2 f 790 "701 790" 100 0 0 100  foo bar ));
1171
DESCR("multiply");
1172

1173
/* OIDS 900 - 999 */
1174

1175
/* isoldpath, upgradepath, upgradepoly, revertpoly are used to update pre-v6.1 to v6.1 - tgl 97/06/03 */
1176
DATA(insert OID = 936 (  isoldpath		   PGUID 11 f t f 1 f  16 "602" 100 0 0 100  foo bar ));
1177
DESCR("");
1178
DATA(insert OID = 937 (  upgradepath	   PGUID 11 f t f 1 f 602 "602" 100 0 0 100  foo bar ));
1179
DESCR("");
1180
DATA(insert OID = 938 (  upgradepoly	   PGUID 11 f t f 1 f 604 "604" 100 0 0 100  foo bar ));
1181
DESCR("");
1182
DATA(insert OID = 939 (  revertpoly		   PGUID 11 f t f 1 f 604 "604" 100 0 0 100  foo bar ));
1183
DESCR("");
1184

1185 1186 1187 1188 1189 1190 1191 1192 1193 1194 1195 1196 1197
DATA(insert OID = 942 (  char_text		   PGUID 11 f t f 1 f 25 "18" 100 0 0 100  foo bar ));
DESCR("convert char to text");
DATA(insert OID = 943 (  text_char		   PGUID 11 f t f 1 f 18 "25" 100 0 0 100  foo bar ));
DESCR("convert text to char");
DATA(insert OID = 944 (  char			   PGUID 14 f t f 1 f 18 "25" 100 0 0 100  "select text_char($1)" - ));
DESCR("convert text to char()");
DATA(insert OID = 946 (  text			   PGUID 14 f t f 1 f 25 "18" 100 0 0 100  "select char_text($1)" - ));
DESCR("convert char to text");
DATA(insert OID = 947 (  char			   PGUID 14 f t f 1 f 18 "1042" 100 0 0 100  "select bpchar_char($1)" - ));
DESCR("convert char() to char");
DATA(insert OID = 948 (  varchar		   PGUID 14 f t f 1 f 25 "1043" 100 0 0 100  "select bpchar_char($1)" - ));
DESCR("convert char to text");

1198
DATA(insert OID = 950 (  istrue			   PGUID 11 f t f 1 f 16 "16" 100 0 0 100  foo bar ));
1199
DESCR("");
1200
DATA(insert OID = 951 (  isfalse		   PGUID 11 f t f 1 f 16 "16" 100 0 0 100  foo bar ));
1201
DESCR("");
1202

1203
DATA(insert OID = 952 (  lo_open		   PGUID 11 f t f 2 f 23 "26 23" 100 0 0 100  foo bar ));
1204
DESCR("large object open");
1205
DATA(insert OID = 953 (  lo_close		   PGUID 11 f t f 1 f 23 "23" 100 0 0 100  foo bar ));
1206
DESCR("large object close");
1207
DATA(insert OID = 954 (  loread			   PGUID 11 f t f 2 f 17 "23 23" 100 0 0 100  foo bar ));
1208
DESCR("large object read");
1209
DATA(insert OID = 955 (  lowrite		   PGUID 11 f t f 2 f 23 "23 17" 100 0 0 100  foo bar ));
1210
DESCR("large object write");
1211
DATA(insert OID = 956 (  lo_lseek		   PGUID 11 f t f 3 f 23 "23 23 23" 100 0 0 100  foo bar ));
1212
DESCR("large object seek");
1213
DATA(insert OID = 957 (  lo_creat		   PGUID 11 f t f 1 f 26 "23" 100 0 0 100  foo bar ));
1214
DESCR("large object create");
1215
DATA(insert OID = 958 (  lo_tell		   PGUID 11 f t f 1 f 23 "23" 100 0 0 100  foo bar ));
1216
DESCR("large object position");
1217 1218

DATA(insert OID = 959 (  on_pl			   PGUID 11 f t f 2 f  16 "600 628" 100 0 10 100  foo bar ));
1219
DESCR("contained in");
1220
DATA(insert OID = 960 (  on_sl			   PGUID 11 f t f 2 f  16 "601 628" 100 0 10 100  foo bar ));
1221
DESCR("contained in");
1222
DATA(insert OID = 961 (  close_pl		   PGUID 11 f t f 2 f 600 "600 628" 100 0 10 100  foo bar ));
1223
DESCR("closest point on line");
1224
DATA(insert OID = 962 (  close_sl		   PGUID 11 f t f 2 f 600 "601 628" 100 0 10 100  foo bar ));
1225
DESCR("closest point to line segment on line");
1226
DATA(insert OID = 963 (  close_lb		   PGUID 11 f t f 2 f 600 "628 603" 100 0 10 100  foo bar ));
1227
DESCR("closest point to line on box");
1228

1229
DATA(insert OID = 964 (  lo_unlink		   PGUID 11 f t f 1 f  23 "26" 100 0 0 100	foo bar ));
1230
DESCR("large object unlink(delete)");
1231
DATA(insert OID = 972 (  regproctooid	   PGUID 11 f t f 1 f  26 "24" 100 0 0 100	foo bar ));
1232
DESCR("get oid for regproc");
1233 1234

DATA(insert OID = 973 (  path_inter		   PGUID 11 f t f 2 f  16 "602 602" 100 0 10 100  foo bar ));
1235
DESCR("");
1236
DATA(insert OID = 975 (  box_area		   PGUID 11 f t f 1 f 701 "603" 100 0 0 100  foo bar ));
1237
DESCR("box area");
1238
DATA(insert OID = 976 (  box_width		   PGUID 11 f t f 1 f 701 "603" 100 0 0 100  foo bar ));
1239
DESCR("box width");
1240
DATA(insert OID = 977 (  box_height		   PGUID 11 f t f 1 f 701 "603" 100 0 0 100  foo bar ));
1241
DESCR("box height");
1242
DATA(insert OID = 978 (  box_distance	   PGUID 11 f t f 2 f 701 "603 603" 100 0 0 100  foo bar ));
1243
DESCR("distance between");
1244
DATA(insert OID = 980 (  box_intersect	   PGUID 11 f t f 2 f 603 "603 603" 100 0 0 100  foo bar ));
1245
DESCR("intersects");
1246
DATA(insert OID = 981 (  box_diagonal	   PGUID 11 f t f 1 f 601 "603" 100 0 0 100  foo bar ));
1247
DESCR("box diagonal");
1248
DATA(insert OID = 982 (  path_n_lt		   PGUID 11 f t f 2 f 16 "602 602" 100 0 0 100	foo bar ));
1249
DESCR("less-than");
1250
DATA(insert OID = 983 (  path_n_gt		   PGUID 11 f t f 2 f 16 "602 602" 100 0 0 100	foo bar ));
1251
DESCR("greater-than");
1252
DATA(insert OID = 984 (  path_n_eq		   PGUID 11 f t f 2 f 16 "602 602" 100 0 0 100	foo bar ));
1253
DESCR("equal");
1254
DATA(insert OID = 985 (  path_n_le		   PGUID 11 f t f 2 f 16 "602 602" 100 0 0 100	foo bar ));
1255
DESCR("less-than-or-equal");
1256
DATA(insert OID = 986 (  path_n_ge		   PGUID 11 f t f 2 f 16 "602 602" 100 0 0 100	foo bar ));
1257
DESCR("greater-than-or-equal");
1258
DATA(insert OID = 987 (  path_length	   PGUID 11 f t f 1 f 701 "602" 100 0 1 0  foo bar ));
1259
DESCR("sum of path segments");
1260
DATA(insert OID = 988 (  point_ne		   PGUID 11 f t f 2 f 16 "600 600" 100 0 0 100	foo bar ));
1261
DESCR("not equal");
1262
DATA(insert OID = 989 (  point_vert		   PGUID 11 f t f 2 f 16 "600 600" 100 0 0 100	foo bar ));
1263
DESCR("is vertical");
1264
DATA(insert OID = 990 (  point_horiz	   PGUID 11 f t f 2 f 16 "600 600" 100 0 0 100	foo bar ));
1265
DESCR("is horizontal");
1266
DATA(insert OID = 991 (  point_distance    PGUID 11 f t f 2 f 701 "600 600" 100 0 0 100  foo bar ));
1267
DESCR("distance between");
1268
DATA(insert OID = 992 (  point_slope	   PGUID 11 f t f 2 f 701 "600 600" 100 0 0 100  foo bar ));
1269
DESCR("slope between points");
1270
DATA(insert OID = 993 (  lseg_construct    PGUID 11 f t f 2 f 601 "600 600" 100 0 0 100  foo bar ));
1271
DESCR("convert points to line segment");
1272
DATA(insert OID = 994 (  lseg_intersect    PGUID 11 f t f 2 f 16 "601 601" 100 0 0 100	foo bar ));
1273
DESCR("intersects");
1274
DATA(insert OID = 995 (  lseg_parallel	   PGUID 11 f t f 2 f 16 "601 601" 100 0 0 100	foo bar ));
1275
DESCR("is parallel to");
1276
DATA(insert OID = 996 (  lseg_perp		   PGUID 11 f t f 2 f 16 "601 601" 100 0 0 100	foo bar ));
1277
DESCR("is perpendicular to");
1278
DATA(insert OID = 997 (  lseg_vertical	   PGUID 11 f t f 1 f 16 "601" 100 0 0 100	foo bar ));
1279
DESCR("is vertical");
1280
DATA(insert OID = 998 (  lseg_horizontal   PGUID 11 f t f 1 f 16 "601" 100 0 0 100	foo bar ));
1281
DESCR("is horizontal");
1282
DATA(insert OID = 999 (  lseg_eq		   PGUID 11 f t f 2 f 16 "601 601" 100 0 0 100	foo bar ));
1283
DESCR("equal");
1284 1285 1286

/* OIDS 1000 - 1999 */

1287
DATA(insert OID = 1029 (  nullvalue		   PGUID 11 f t f 1 f 16 "0" 100 0 0 100  foo bar ));
1288
DESCR("(internal)");
1289
DATA(insert OID = 1030 (  nonnullvalue	   PGUID 11 f t f 1 f 16 "0" 100 0 0 100  foo bar ));
1290
DESCR("(internal)");
1291
DATA(insert OID = 1031 (  aclitemin		   PGUID 11 f t f 1 f 1033 "0" 100 0 0 100	foo bar ));
1292
DESCR("(internal)");
1293
DATA(insert OID = 1032 (  aclitemout	   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
1294
DESCR("(internal)");
1295
DATA(insert OID = 1035 (  aclinsert		   PGUID 11 f t f 2 f 1034 "1034 1033" 100 0 0 100	foo bar ));
1296
DESCR("addition");
1297
DATA(insert OID = 1036 (  aclremove		   PGUID 11 f t f 2 f 1034 "1034 1033" 100 0 0 100	foo bar ));
1298
DESCR("subtract");
1299
DATA(insert OID = 1037 (  aclcontains	   PGUID 11 f t f 2 f 16 "1034 1033" 100 0 0 100  foo bar ));
1300
DESCR("matches regex., case-sensitive");
1301
DATA(insert OID = 1038 (  seteval		   PGUID 11 f t f 1 f 23 "26" 100 0 0 100  foo bar ));
1302
DESCR("");
1303
DATA(insert OID = 1044 (  bpcharin		   PGUID 11 f t f 3 f 1042 "0" 100 0 0 100	foo bar ));
1304
DESCR("(internal)");
1305
DATA(insert OID = 1045 (  bpcharout		   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
1306
DESCR("(internal)");
1307
DATA(insert OID = 1046 (  varcharin		   PGUID 11 f t f 3 f 1043 "0" 100 0 0 100	foo bar ));
1308
DESCR("(internal)");
1309
DATA(insert OID = 1047 (  varcharout	   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
1310
DESCR("(internal)");
1311
DATA(insert OID = 1048 (  bpchareq		   PGUID 11 f t f 2 f 16 "1042 1042" 100 0 0 100  foo bar ));
1312
DESCR("equal");
1313
DATA(insert OID = 1049 (  bpcharlt		   PGUID 11 f t f 2 f 16 "1042 1042" 100 0 0 100  foo bar ));
1314
DESCR("less-than");
1315
DATA(insert OID = 1050 (  bpcharle		   PGUID 11 f t f 2 f 16 "1042 1042" 100 0 0 100  foo bar ));
1316
DESCR("less-than-or-equal");
1317
DATA(insert OID = 1051 (  bpchargt		   PGUID 11 f t f 2 f 16 "1042 1042" 100 0 0 100  foo bar ));
1318
DESCR("greater-than");
1319
DATA(insert OID = 1052 (  bpcharge		   PGUID 11 f t f 2 f 16 "1042 1042" 100 0 0 100  foo bar ));
1320
DESCR("greater-than-or-equal");
1321
DATA(insert OID = 1053 (  bpcharne		   PGUID 11 f t f 2 f 16 "1042 1042" 100 0 0 100  foo bar ));
1322
DESCR("not equal");
1323
DATA(insert OID = 1070 (  varchareq		   PGUID 11 f t f 2 f 16 "1043 1043" 100 0 0 100  foo bar ));
1324
DESCR("equal");
1325
DATA(insert OID = 1071 (  varcharlt		   PGUID 11 f t f 2 f 16 "1043 1043" 100 0 0 100  foo bar ));
1326
DESCR("less-than");
1327
DATA(insert OID = 1072 (  varcharle		   PGUID 11 f t f 2 f 16 "1043 1043" 100 0 0 100  foo bar ));
1328
DESCR("less-than-or-equal");
1329
DATA(insert OID = 1073 (  varchargt		   PGUID 11 f t f 2 f 16 "1043 1043" 100 0 0 100  foo bar ));
1330
DESCR("greater-than");
1331
DATA(insert OID = 1074 (  varcharge		   PGUID 11 f t f 2 f 16 "1043 1043" 100 0 0 100  foo bar ));
1332
DESCR("greater-than-or-equal");
1333
DATA(insert OID = 1075 (  varcharne		   PGUID 11 f t f 2 f 16 "1043 1043" 100 0 0 100  foo bar ));
1334
DESCR("not equal");
1335
DATA(insert OID = 1078 (  bpcharcmp		   PGUID 11 f t f 2 f 23 "1042 1042" 100 0 0 100  foo bar ));
1336
DESCR("less-equal-greater");
1337
DATA(insert OID = 1079 (  varcharcmp	   PGUID 11 f t f 2 f 23 "1043 1043" 100 0 0 100  foo bar ));
1338
DESCR("less-equal-greater");
1339
DATA(insert OID = 1080 (  hashbpchar	   PGUID 11 f t f 1 f 23 "1042" 100 0 0 100  foo bar ));
1340
DESCR("hash");
1341
DATA(insert OID = 1081 (  hashvarchar	   PGUID 11 f t f 1 f 23 "1043" 100 0 0 100  foo bar ));
1342
DESCR("hash");
1343

1344
DATA(insert OID = 1084 (  date_in		   PGUID 11 f t f 1 f 1082 "0" 100 0 0 100	foo bar ));
1345
DESCR("(internal)");
1346
DATA(insert OID = 1085 (  date_out		   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
1347
DESCR("(internal)");
1348
DATA(insert OID = 1086 (  date_eq		   PGUID 11 f t f 2 f 16 "1082 1082" 100 0 0 100  foo bar ));
1349
DESCR("equal");
1350
DATA(insert OID = 1087 (  date_lt		   PGUID 11 f t f 2 f 16 "1082 1082" 100 0 0 100  foo bar ));
1351
DESCR("less-than");
1352
DATA(insert OID = 1088 (  date_le		   PGUID 11 f t f 2 f 16 "1082 1082" 100 0 0 100  foo bar ));
1353
DESCR("less-than-or-equal");
1354
DATA(insert OID = 1089 (  date_gt		   PGUID 11 f t f 2 f 16 "1082 1082" 100 0 0 100  foo bar ));
1355
DESCR("greater-than");
1356
DATA(insert OID = 1090 (  date_ge		   PGUID 11 f t f 2 f 16 "1082 1082" 100 0 0 100  foo bar ));
1357
DESCR("greater-than-or-equal");
1358
DATA(insert OID = 1091 (  date_ne		   PGUID 11 f t f 2 f 16 "1082 1082" 100 0 0 100  foo bar ));
1359
DESCR("not equal");
1360
DATA(insert OID = 1092 (  date_cmp		   PGUID 11 f t f 2 f 23 "1082 1082" 100 0 0 100  foo bar ));
1361
DESCR("less-equal-greater");
1362 1363

/* OIDS 1100 - 1199 */
1364

1365
DATA(insert OID = 1102 (  time_lt		   PGUID 11 f t f 2 f 16 "1083 1083" 100 0 0 100  foo bar ));
1366
DESCR("less-than");
1367
DATA(insert OID = 1103 (  time_le		   PGUID 11 f t f 2 f 16 "1083 1083" 100 0 0 100  foo bar ));
1368
DESCR("less-than-or-equal");
1369
DATA(insert OID = 1104 (  time_gt		   PGUID 11 f t f 2 f 16 "1083 1083" 100 0 0 100  foo bar ));
1370
DESCR("greater-than");
1371
DATA(insert OID = 1105 (  time_ge		   PGUID 11 f t f 2 f 16 "1083 1083" 100 0 0 100  foo bar ));
1372
DESCR("greater-than-or-equal");
1373
DATA(insert OID = 1106 (  time_ne		   PGUID 11 f t f 2 f 16 "1083 1083" 100 0 0 100  foo bar ));
1374
DESCR("not equal");
1375
DATA(insert OID = 1107 (  time_cmp		   PGUID 11 f t f 2 f 23 "1083 1083" 100 0 0 100  foo bar ));
1376
DESCR("less-equal-greater");
1377
DATA(insert OID = 1138 (  date_larger	   PGUID 11 f t f 2 f 1082 "1082 1082" 100 0 0 100	foo bar ));
1378
DESCR("larger of two");
1379
DATA(insert OID = 1139 (  date_smaller	   PGUID 11 f t f 2 f 1082 "1082 1082" 100 0 0 100	foo bar ));
1380
DESCR("smaller of two");
1381
DATA(insert OID = 1140 (  date_mi		   PGUID 11 f t f 2 f 23 "1082 1082" 100 0 0 100  foo bar ));
1382
DESCR("subtract");
1383
DATA(insert OID = 1141 (  date_pli		   PGUID 11 f t f 2 f 1082 "1082 23" 100 0 0 100  foo bar ));
1384
DESCR("addition");
1385
DATA(insert OID = 1142 (  date_mii		   PGUID 11 f t f 2 f 1082 "1082 23" 100 0 0 100  foo bar ));
1386
DESCR("subtract");
1387
DATA(insert OID = 1143 (  time_in		   PGUID 11 f t f 1 f 1083 "0" 100 0 0 100	foo bar ));
1388
DESCR("(internal)");
1389
DATA(insert OID = 1144 (  time_out		   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
1390
DESCR("(internal)");
1391
DATA(insert OID = 1145 (  time_eq		   PGUID 11 f t f 2 f 16 "1083 1083" 100 0 0 100  foo bar ));
1392
DESCR("equal");
1393

1394
DATA(insert OID = 1146 (  circle_add_pt    PGUID 11 f t f 2 f 718 "718 600" 100 0 0 100  foo bar ));
1395
DESCR("addition");
1396
DATA(insert OID = 1147 (  circle_sub_pt    PGUID 11 f t f 2 f 718 "718 600" 100 0 0 100  foo bar ));
1397
DESCR("subtract");
1398
DATA(insert OID = 1148 (  circle_mul_pt    PGUID 11 f t f 2 f 718 "718 600" 100 0 0 100  foo bar ));
1399
DESCR("multiply");
1400
DATA(insert OID = 1149 (  circle_div_pt    PGUID 11 f t f 2 f 718 "718 600" 100 0 0 100  foo bar ));
1401
DESCR("divide");
1402

1403
DATA(insert OID = 1150 (  datetime_in	   PGUID 11 f t f 1 f 1184 "0" 100 0 0 100	foo bar ));
1404
DESCR("(internal)");
1405
DATA(insert OID = 1151 (  datetime_out	   PGUID 11 f t f 1 f	23 "0" 100 0 0 100	foo bar ));
1406
DESCR("(internal)");
1407
DATA(insert OID = 1152 (  datetime_eq	   PGUID 11 f t f 2 f	16 "1184 1184" 100 0 0 100	foo bar ));
1408
DESCR("equal");
1409
DATA(insert OID = 1153 (  datetime_ne	   PGUID 11 f t f 2 f	16 "1184 1184" 100 0 0 100	foo bar ));
1410
DESCR("not equal");
1411
DATA(insert OID = 1154 (  datetime_lt	   PGUID 11 f t f 2 f	16 "1184 1184" 100 0 0 100	foo bar ));
1412
DESCR("less-than");
1413
DATA(insert OID = 1155 (  datetime_le	   PGUID 11 f t f 2 f	16 "1184 1184" 100 0 0 100	foo bar ));
1414
DESCR("less-than-or-equal");
1415
DATA(insert OID = 1156 (  datetime_ge	   PGUID 11 f t f 2 f	16 "1184 1184" 100 0 0 100	foo bar ));
1416
DESCR("greater-than-or-equal");
1417
DATA(insert OID = 1157 (  datetime_gt	   PGUID 11 f t f 2 f	16 "1184 1184" 100 0 0 100	foo bar ));
1418
DESCR("greater-than");
1419
DATA(insert OID = 1158 (  datetime_finite  PGUID 11 f t f 1 f	16 "1184" 100 0 0 100  foo bar ));
1420
DESCR("");
1421
DATA(insert OID = 1159 (  datetime_zone    PGUID 11 f t f 2 f	25 "25 1184" 100 0 0 100  foo bar ));
1422
DESCR("");
1423

1424
DATA(insert OID = 1160 (  timespan_in	   PGUID 11 f t f 1 f 1186 "0" 100 0 0 100	foo bar ));
1425
DESCR("(internal)");
1426
DATA(insert OID = 1161 (  timespan_out	   PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
1427
DESCR("(internal)");
1428
DATA(insert OID = 1162 (  timespan_eq	   PGUID 11 f t f 2 f 16 "1186 1186" 100 0 0 100  foo bar ));
1429
DESCR("equal");
1430
DATA(insert OID = 1163 (  timespan_ne	   PGUID 11 f t f 2 f 16 "1186 1186" 100 0 0 100  foo bar ));
1431
DESCR("not equal");
1432
DATA(insert OID = 1164 (  timespan_lt	   PGUID 11 f t f 2 f 16 "1186 1186" 100 0 0 100  foo bar ));
1433
DESCR("less-than");
1434
DATA(insert OID = 1165 (  timespan_le	   PGUID 11 f t f 2 f 16 "1186 1186" 100 0 0 100  foo bar ));
1435
DESCR("less-than-or-equal");
1436
DATA(insert OID = 1166 (  timespan_ge	   PGUID 11 f t f 2 f 16 "1186 1186" 100 0 0 100  foo bar ));
1437
DESCR("greater-than-or-equal");
1438
DATA(insert OID = 1167 (  timespan_gt	   PGUID 11 f t f 2 f 16 "1186 1186" 100 0 0 100  foo bar ));
1439
DESCR("greater-than");
1440
DATA(insert OID = 1168 (  timespan_um	   PGUID 11 f t f 1 f 1186 "1186" 100 0 0 100  foo bar ));
1441
DESCR("subtract");
1442
DATA(insert OID = 1169 (  timespan_pl	  PGUID 11 f t f 2 f 1186 "1186 1186" 100 0 0 100  foo bar ));
1443
DESCR("addition");
1444
DATA(insert OID = 1170 (  timespan_mi	  PGUID 11 f t f 2 f 1186 "1186 1186" 100 0 0 100  foo bar ));
1445
DESCR("subtract");
1446
DATA(insert OID = 1171 (  datetime_part    PGUID 11 f t f 2 f  701 "25 1184" 100 0 0 100  foo bar ));
1447
DESCR("extract field from datetime");
1448
DATA(insert OID = 1172 (  timespan_part    PGUID 11 f t f 2 f  701 "25 1186" 100 0 0 100  foo bar ));
1449
DESCR("extract field from timespan");
1450

1451
DATA(insert OID = 1173 (  abstime_datetime	 PGUID 11 f t f 1 f 1184  "702" 100 0 0 100  foo bar ));
1452
DESCR("convert abstime to datetime");
1453
DATA(insert OID = 1174 (  date_datetime		 PGUID 11 f t f 1 f 1184 "1082" 100 0 0 100  foo bar ));
1454
DESCR("convert date to datetime");
1455
DATA(insert OID = 1175 (  timestamp_datetime PGUID 11 f t f 1 f 1184 "1296" 100 0 0 100  foo bar ));
1456
DESCR("convert timestamp to datetime");
1457
DATA(insert OID = 1176 (  datetime_datetime  PGUID 11 f t f 2 f 1184 "1082 1083" 100 0 0 100  foo bar ));
1458
DESCR("convert date and time to datetime");
1459
DATA(insert OID = 1177 (  reltime_timespan	 PGUID 11 f t f 1 f 1186  "703" 100 0 0 100  foo bar ));
1460
DESCR("convert reltime to timespan");
1461
DATA(insert OID = 1178 (  datetime_date		 PGUID 11 f t f 1 f 1082 "1184" 100 0 0 100  foo bar ));
1462
DESCR("convert datetime to date");
1463
DATA(insert OID = 1179 (  abstime_date		 PGUID 11 f t f 1 f 1082  "702" 100 0 0 100  foo bar ));
1464
DESCR("convert abstime to date");
1465
DATA(insert OID = 1180 (  datetime_abstime	 PGUID 11 f t f 1 f  702 "1184" 100 0 0 100  foo bar ));
1466
DESCR("convert datetime to abstime");
1467 1468

DATA(insert OID = 1188 (  datetime_mi		PGUID 11 f t f 2 f 1186 "1184 1184" 100 0 0 100  foo bar ));
1469
DESCR("subtract");
1470
DATA(insert OID = 1189 (  datetime_pl_span	PGUID 11 f t f 2 f 1184 "1184 1186" 100 0 0 100  foo bar ));
1471
DESCR("plus");
1472
DATA(insert OID = 1190 (  datetime_mi_span	PGUID 11 f t f 2 f 1184 "1184 1186" 100 0 0 100  foo bar ));
1473
DESCR("minus");
1474
DATA(insert OID = 1191 (  text_datetime		 PGUID 11 f t f 1 f 1184 "25" 100 0 0 100  foo bar ));
1475
DESCR("convert text to datetime");
1476
DATA(insert OID = 1192 (  datetime_text		 PGUID 11 f t f 1 f   25 "1184" 100 0 0 100  foo bar ));
1477
DESCR("convert datetime to text");
1478
DATA(insert OID = 1193 (  timespan_text		 PGUID 11 f t f 1 f   25 "1186" 100 0 0 100  foo bar ));
1479
DESCR("convert timespan to text");
1480
DATA(insert OID = 1194 (  timespan_reltime	 PGUID 11 f t f 1 f  703 "1186" 100 0 0 100  foo bar ));
1481
DESCR("convert timespan to reltime");
1482
DATA(insert OID = 1195 (  datetime_smaller	 PGUID 11 f t f 2 f 1184 "1184 1184" 100 0 0 100  foo bar ));
1483
DESCR("smaller of two");
1484
DATA(insert OID = 1196 (  datetime_larger	 PGUID 11 f t f 2 f 1184 "1184 1184" 100 0 0 100  foo bar ));
1485
DESCR("larger of two");
1486
DATA(insert OID = 1197 (  timespan_smaller	 PGUID 11 f t f 2 f 1186 "1186 1186" 100 0 0 100  foo bar ));
1487
DESCR("smaller of two");
1488
DATA(insert OID = 1198 (  timespan_larger	 PGUID 11 f t f 2 f 1186 "1186 1186" 100 0 0 100  foo bar ));
1489
DESCR("larger of two");
1490
DATA(insert OID = 1199 (  datetime_age		 PGUID 11 f t f 2 f 1186 "1184 1184" 100 0 0 100  foo bar ));
1491
DESCR("date difference preserving months and years");
1492

1493
/* OIDS 1200 - 1299 */
1494

1495
DATA(insert OID = 1200 (  int4reltime	   PGUID 11 f t f 1 f  703 "23" 100 0 0 100  foo bar ));
1496
DESCR("convert int4 to reltime");
1497 1498

DATA(insert OID = 1217 (  datetime_trunc   PGUID 11 f t f 2 f 1184 "25 1184" 100 0 0 100  foo bar ));
1499
DESCR("truncate datetime to specified units");
1500
DATA(insert OID = 1218 (  timespan_trunc   PGUID 11 f t f 2 f 1186 "25 1186" 100 0 0 100  foo bar ));
1501
DESCR("truncate timespan to specified units");
1502

1503
DATA(insert OID = 1230 (  bpchar		   PGUID 14 f t f 1 f 1042 "18" 100 0 0 100  "select char_bpchar($1)" - ));
1504 1505 1506
DESCR("convert char to char()");
DATA(insert OID = 1231 (  char			   PGUID 14 f t f 1 f	18 "1042" 100 0 0 100  "select bpchar_char($1)" - ));
DESCR("convert char() to char");
1507 1508 1509 1510 1511 1512

DATA(insert OID = 1236 (  int8larger	   PGUID 11 f t f 2 f 20 "20 20" 100 0 0 100  foo bar ));
DESCR("larger of two");
DATA(insert OID = 1237 (  int8smaller	   PGUID 11 f t f 2 f 20 "20 20" 100 0 0 100  foo bar ));
DESCR("smaller of two");

1513
DATA(insert OID = 1238 (  texticregexeq    PGUID 11 f t f 2 f 16 "25 25" 100 0 1 0	foo bar ));
1514
DESCR("matches regex., case-insensitive");
1515
DATA(insert OID = 1239 (  texticregexne    PGUID 11 f t f 2 f 16 "25 25" 100 0 1 0	foo bar ));
1516
DESCR("does not match regex., case-insensitive");
1517
DATA(insert OID = 1240 (  nameicregexeq    PGUID 11 f t f 2 f 16 "19 25" 100 0 0 100  foo bar ));
1518
DESCR("matches regex., case-insensitive");
1519
DATA(insert OID = 1241 (  nameicregexne    PGUID 11 f t f 2 f 16 "19 25" 100 0 0 100  foo bar ));
1520
DESCR("does not match regex., case-insensitive");
1521

1522
DATA(insert OID = 1251 (  bpcharlen		   PGUID 11 f t f 1 f 23 "1042" 100 0 0 100  foo bar ));
1523
DESCR("octet length");
1524
DATA(insert OID = 1378 (  bpcharoctetlen   PGUID 11 f t f 1 f 23 "1042" 100 0 0 100  foo bar ));
M
Marc G. Fournier 已提交
1525
DESCR("octet length");
1526
DATA(insert OID = 1253 (  varcharlen	   PGUID 11 f t f 1 f 23 "1043" 100 0 0 100  foo bar ));
M
Marc G. Fournier 已提交
1527
DESCR("character length");
1528
DATA(insert OID = 1379 (  varcharoctetlen  PGUID 11 f t f 1 f 23 "1043" 100 0 0 100  foo bar ));
1529 1530
DESCR("octet length");

1531
DATA(insert OID = 1263 (  text_timespan    PGUID 11 f t f 1 f 1186 "25" 100 0 0 100  foo bar ));
1532
DESCR("convert text to timespan");
1533 1534 1535
DATA(insert OID = 1271 (  timespan_finite  PGUID 11 f t f 1 f	16 "1186" 100 0 0 100  foo bar ));
DESCR("boolean test");

1536 1537 1538 1539 1540 1541 1542 1543 1544 1545 1546 1547 1548 1549 1550 1551 1552
DATA(insert OID = 1274 (  int84pl		   PGUID 11 f t f 2 f 20 "20 23" 100 0 0 100  foo bar ));
DESCR("addition");
DATA(insert OID = 1275 (  int84mi		   PGUID 11 f t f 2 f 20 "20 23" 100 0 0 100  foo bar ));
DESCR("subtraction");
DATA(insert OID = 1276 (  int84mul		   PGUID 11 f t f 2 f 20 "20 23" 100 0 0 100  foo bar ));
DESCR("multiply");
DATA(insert OID = 1277 (  int84div		   PGUID 11 f t f 2 f 20 "20 23" 100 0 0 100  foo bar ));
DESCR("divide");
DATA(insert OID = 1278 (  int48pl		   PGUID 11 f t f 2 f 20 "23 20" 100 0 0 100  foo bar ));
DESCR("addition");
DATA(insert OID = 1279 (  int48mi		   PGUID 11 f t f 2 f 20 "23 20" 100 0 0 100  foo bar ));
DESCR("subtraction");
DATA(insert OID = 1280 (  int48mul		   PGUID 11 f t f 2 f 20 "23 20" 100 0 0 100  foo bar ));
DESCR("multiply");
DATA(insert OID = 1281 (  int48div		   PGUID 11 f t f 2 f 20 "23 20" 100 0 0 100  foo bar ));
DESCR("divide");

1553 1554 1555 1556 1557
DATA(insert OID = 1288 (  int8_text		   PGUID 11 f t f 1 f 25 "20" 100 0 0 100  foo bar ));
DESCR("convert int8 to text");
DATA(insert OID = 1289 (  text_int8		   PGUID 11 f t f 1 f 20 "25" 100 0 0 100  foo bar ));
DESCR("convert text to int8");

1558
DATA(insert OID = 1297 (  timestamp_in	   PGUID 11 f t f 1 f 1296 "0" 100 0 0 100	foo bar ));
1559
DESCR("(internal)");
1560
DATA(insert OID = 1298 (  timestamp_out    PGUID 11 f t f 1 f	23 "0" 100 0 0 100	foo bar ));
1561
DESCR("(internal)");
1562
DATA(insert OID = 1299 (  now			   PGUID 11 f t f 0 f 1296 "0" 100 0 0 100	foo bar ));
1563
DESCR("current transaction time");
1564 1565

/* OIDS 1300 - 1399 */
1566

1567
DATA(insert OID = 1306 (  timestampeq		 PGUID 11 f t f 2 f   16 "1296 1296" 100 0 0 100  foo bar ));
1568
DESCR("equal");
1569
DATA(insert OID = 1307 (  timestampne		 PGUID 11 f t f 2 f   16 "1296 1296" 100 0 0 100  foo bar ));
1570
DESCR("not equal");
1571
DATA(insert OID = 1308 (  timestamplt		 PGUID 11 f t f 2 f   16 "1296 1296" 100 0 0 100  foo bar ));
1572
DESCR("less-than");
1573
DATA(insert OID = 1309 (  timestampgt		 PGUID 11 f t f 2 f   16 "1296 1296" 100 0 0 100  foo bar ));
1574
DESCR("greater-than");
1575
DATA(insert OID = 1310 (  timestample		 PGUID 11 f t f 2 f   16 "1296 1296" 100 0 0 100  foo bar ));
1576
DESCR("less-than-or-equal");
1577
DATA(insert OID = 1311 (  timestampge		 PGUID 11 f t f 2 f   16 "1296 1296" 100 0 0 100  foo bar ));
1578
DESCR("greater-than-or-equal");
1579
DATA(insert OID = 1314 (  datetime_cmp		 PGUID 11 f t f 2 f   23 "1184 1184" 100 0 0 100  foo bar ));
1580
DESCR("less-equal-greater");
1581
DATA(insert OID = 1315 (  timespan_cmp		 PGUID 11 f t f 2 f   23 "1186 1186" 100 0 0 100  foo bar ));
1582
DESCR("less-equal-greater");
1583
DATA(insert OID = 1316 (  datetime_time		 PGUID 11 f t f 1 f 1083 "1184" 100 0 0 100  foo bar ));
1584
DESCR("convert datetime to time");
1585
DATA(insert OID = 1318 (  datetime_timestamp PGUID 11 f t f 1 f 1296 "1184" 100 0 0 100  foo bar ));
1586
DESCR("convert datetime to timestamp");
1587
DATA(insert OID = 1326 (  timespan_div		 PGUID 11 f t f 2 f 1186 "1186 701" 100 0 0 100  foo bar ));
1588
DESCR("divide");
1589

1590
DATA(insert OID = 1339 (  date_zone			 PGUID 14 f t f 2 f   25 "25 1184" 100 0 0 100	"select datetime_zone($1, $2)" - ));
1591
DESCR("");
1592
DATA(insert OID = 1340 (  text				 PGUID 14 f t f 1 f   25 "1184" 100 0 0 100  "select datetime_text($1)" - ));
1593
DESCR("convert datetime to text");
1594
DATA(insert OID = 1341 (  text				 PGUID 14 f t f 1 f   25 "1186" 100 0 0 100  "select timespan_text($1)" - ));
1595
DESCR("convert timespan to text");
1596
DATA(insert OID = 1342 (  text				 PGUID 14 f t f 1 f   25 "23" 100 0 0 100  "select int4_text($1)" - ));
1597
DESCR("convert int4 to text");
1598
DATA(insert OID = 1343 (  text				 PGUID 14 f t f 1 f   25 "21" 100 0 0 100  "select int2_text($1)" - ));
1599
DESCR("convert int2 to text");
1600
DATA(insert OID = 1344 (  text				 PGUID 14 f t f 1 f   25 "26" 100 0 0 100  "select oid_text($1)" - ));
1601
DESCR("convert oid to text");
1602
DATA(insert OID = 1345 (  oid				 PGUID 14 f t f 1 f   26 "25" 100 0 0 100  "select text_oid($1)" - ));
1603
DESCR("convert text to oid");
1604
DATA(insert OID = 1346 (  int2				 PGUID 14 f t f 1 f   21 "25" 100 0 0 100  "select text_int2($1)" - ));
1605
DESCR("convert text to int2");
1606
DATA(insert OID = 1347 (  int4				 PGUID 14 f t f 1 f   23 "25" 100 0 0 100  "select text_int4($1)" - ));
1607
DESCR("convert text to int4");
1608
DATA(insert OID = 1348 (  obj_description	 PGUID 14 f t f 1 f   25 "26" 100 0 0 100  "select description from pg_description where objoid = $1" - ));
1609
DESCR("get description for object id");
1610
DATA(insert OID = 1349 (  oid8types			 PGUID 11 f t f 1 f   25 "30" 100 0 0 100  foo bar ));
1611
DESCR("print type names of oid8 field");
1612

1613
DATA(insert OID = 1350 (  datetime			 PGUID 14 f t f 1 f 1184 "1184" 100 0 0 100  "select $1" - ));
1614
DESCR("convert (noop)");
1615
DATA(insert OID = 1351 (  datetime			 PGUID 14 f t f 1 f 1184 "25" 100 0 0 100  "select text_datetime($1)" - ));
1616
DESCR("convert text to datetime");
1617
DATA(insert OID = 1352 (  datetime			 PGUID 14 f t f 1 f 1184 "702" 100 0 0 100	"select abstime_datetime($1)" - ));
1618
DESCR("convert abstime to datetime");
1619
DATA(insert OID = 1353 (  datetime			 PGUID 14 f t f 1 f 1184 "1082" 100 0 0 100  "select date_datetime($1)" - ));
1620
DESCR("convert date to datetime");
1621
DATA(insert OID = 1354 (  datetime			 PGUID 14 f t f 1 f 1184 "1296" 100 0 0 100  "select timestamp_datetime($1)" - ));
1622
DESCR("convert timestamp to datetime");
1623
DATA(insert OID = 1355 (  datetime			 PGUID 14 f t f 2 f 1184 "1082 1083" 100 0 0 100  "select datetime_datetime($1, $2)" - ));
1624
DESCR("convert date and time to datetime");
1625
DATA(insert OID = 1356 (  timespan			 PGUID 14 f t f 1 f 1186 "1186" 100 0 0 100  "select $1" - ));
1626
DESCR("convert (noop)");
1627
DATA(insert OID = 1357 (  timespan			 PGUID 14 f t f 1 f 1186 "703" 100 0 0 100	"select reltime_timespan($1)" - ));
1628
DESCR("convert reltime to timespan");
1629
DATA(insert OID = 1358 (  timespan			 PGUID 14 f t f 1 f 1186 "1083" 100 0 0 100  "select time_timespan($1)" - ));
1630
DESCR("convert time to timespan");
1631
DATA(insert OID = 1359 (  date				 PGUID 14 f t f 1 f 1082 "1082" 100 0 0 100  "select $1" - ));
1632
DESCR("convert (noop)");
1633
DATA(insert OID = 1360 (  date				 PGUID 14 f t f 1 f 1082 "1184" 100 0 0 100  "select datetime_date($1)" - ));
1634
DESCR("convert datetime to date");
1635
DATA(insert OID = 1361 (  date				 PGUID 14 f t f 1 f 1082 "702" 100 0 0 100	"select abstime_date($1)" - ));
1636
DESCR("convert abstime to date");
1637
DATA(insert OID = 1362 (  time				 PGUID 14 f t f 1 f 1083 "1083" 100 0 0 100  "select $1" - ));
1638
DESCR("convert (noop)");
1639
DATA(insert OID = 1363 (  time				 PGUID 14 f t f 1 f 1083 "1184" 100 0 0 100  "select datetime_time($1)" - ));
1640
DESCR("convert datetime to time");
1641
DATA(insert OID = 1364 (  time				 PGUID 14 f t f 1 f 1083 "702" 100 0 0 100	"select abstime_time($1)" - ));
1642
DESCR("convert abstime to time");
1643
DATA(insert OID = 1365 (  abstime			 PGUID 14 f t f 1 f  702 "702" 100 0 0 100	"select $1" - ));
1644
DESCR("convert (noop)");
1645
DATA(insert OID = 1366 (  abstime			 PGUID 14 f t f 1 f  702 "1184" 100 0 0 100  "select datetime_abstime($1)" - ));
1646
DESCR("convert datetime to abstime");
1647
DATA(insert OID = 1367 (  reltime			 PGUID 14 f t f 1 f  703 "703" 100 0 0 100	"select $1" - ));
1648
DESCR("convert (noop)");
1649
DATA(insert OID = 1368 (  reltime			 PGUID 14 f t f 1 f  703 "1186" 100 0 0 100  "select timespan_reltime($1)" - ));
1650
DESCR("convert timespan to reltime");
1651
DATA(insert OID = 1369 (  timestamp			 PGUID 14 f t f 1 f 1296 "1296" 100 0 0 100  "select $1" - ));
1652
DESCR("convert (noop)");
1653
DATA(insert OID = 1370 (  timestamp			 PGUID 14 f t f 1 f 1296 "1184" 100 0 0 100  "select datetime_stamp($1)" - ));
1654
DESCR("convert datetime to timestamp");
1655
DATA(insert OID = 1371 (  length			 PGUID 14 f t f 1 f   23   "25" 100 0 0 100  "select textlen($1)" - ));
M
Marc G. Fournier 已提交
1656
DESCR("character length");
1657
DATA(insert OID = 1372 (  length			 PGUID 14 f t f 1 f   23   "1042" 100 0 0 100  "select bpcharlen($1)" - ));
M
Marc G. Fournier 已提交
1658
DESCR("character length");
1659
DATA(insert OID = 1373 (  length			 PGUID 14 f t f 1 f   23   "1043" 100 0 0 100  "select varcharlen($1)" - ));
M
Marc G. Fournier 已提交
1660 1661 1662 1663 1664 1665 1666
DESCR("character length");

DATA(insert OID = 1374 (  octet_length			 PGUID 14 f t f 1 f   23   "25" 100 0 0 100  "select textoctetlen($1)" - ));
DESCR("octet length");
DATA(insert OID = 1375 (  octet_length			 PGUID 14 f t f 1 f   23   "1042" 100 0 0 100  "select bpcharoctetlen($1)" - ));
DESCR("octet length");
DATA(insert OID = 1376 (  octet_length			 PGUID 14 f t f 1 f   23   "1043" 100 0 0 100  "select varcharoctetlen($1)" - ));
1667
DESCR("octet length");
1668 1669

DATA(insert OID = 1380 (  date_part    PGUID 14 f t f 2 f  701 "25 1184" 100 0 0 100  "select datetime_part($1, $2)" - ));
1670
DESCR("extract field from datetime");
1671
DATA(insert OID = 1381 (  date_part    PGUID 14 f t f 2 f  701 "25 1186" 100 0 0 100  "select timespan_part($1, $2)" - ));
1672
DESCR("extract field from timespan");
1673
DATA(insert OID = 1382 (  date_part    PGUID 14 f t f 2 f  701 "25 702" 100 0 0 100  "select datetime_part($1, datetime($2))" - ));
1674
DESCR("extract field from abstime");
1675
DATA(insert OID = 1383 (  date_part    PGUID 14 f t f 2 f  701 "25 703" 100 0 0 100  "select timespan_part($1, timespan($2))" - ));
1676
DESCR("extract field from reltime");
1677
DATA(insert OID = 1384 (  date_part    PGUID 14 f t f 2 f  701 "25 1082" 100 0 0 100  "select datetime_part($1, datetime($2))" - ));
1678
DESCR("extract field from date");
1679
DATA(insert OID = 1385 (  date_part    PGUID 14 f t f 2 f  701 "25 1083" 100 0 0 100  "select timespan_part($1, timespan($2))" - ));
1680
DESCR("extract field from time");
1681
DATA(insert OID = 1386 (  date_trunc   PGUID 14 f t f 2 f 1184 "25 1184" 100 0 0 100  "select datetime_trunc($1, $2)" - ));
1682
DESCR("truncate datetime to field");
1683
DATA(insert OID = 1387 (  date_trunc   PGUID 14 f t f 2 f 1186 "25 1186" 100 0 0 100  "select timespan_trunc($1, $2)" - ));
1684
DESCR("truncate timespan to field");
1685
DATA(insert OID = 1388 (  age		   PGUID 14 f t f 2 f 1186 "1184 1184" 100 0 0 100	"select datetime_age($1, $2)" - ));
1686
DESCR("difference between datetimes but leave years and months unresolved");
1687
DATA(insert OID = 1389 (  age		   PGUID 14 f t f 1 f 1186 "1184" 100 0 0 100  "select datetime_age(\'today\', $1)" - ));
1688
DESCR("difference between datetime and today but leave years and months unresolved");
1689

1690
DATA(insert OID = 1390 (  isfinite	   PGUID 14 f t f 1 f	16 "1184" 100 0 0 100  "select datetime_finite($1)" - ));
1691
DESCR("boolean test");
1692
DATA(insert OID = 1391 (  isfinite	   PGUID 14 f t f 1 f	16 "1186" 100 0 0 100  "select timespan_finite($1)" - ));
1693
DESCR("boolean test");
1694
DATA(insert OID = 1392 (  isfinite	   PGUID 14 f t f 1 f	16 "702" 100 0 0 100  "select abstime_finite($1)" - ));
1695 1696
DESCR("boolean test");

1697
DATA(insert OID = 1393 (  timespan	   PGUID 14 f t f 1 f 1186 "25" 100 0 0 100  "select text_timespan($1)" - ));
1698
DESCR("convert text to timespan");
1699

1700
DATA(insert OID = 1394 (  name		   PGUID 14 f t f 1 f	19 "25" 100 0 0 100  "select text_name($1)" - ));
1701
DESCR("convert text to name");
1702
DATA(insert OID = 1395 (  text		   PGUID 14 f t f 1 f	25 "19" 100 0 0 100  "select name_text($1)" - ));
1703
DESCR("convert name to text");
1704
DATA(insert OID = 1396 (  name		   PGUID 14 f t f 1 f	19 "1042" 100 0 0 100  "select bpchar_name($1)" - ));
1705
DESCR("convert char() to name");
1706
DATA(insert OID = 1397 (  bpchar	   PGUID 14 f t f 1 f 1042 "19" 100 0 0 100  "select name_bpchar($1)" - ));
1707
DESCR("convert name to char()");
1708
DATA(insert OID = 1398 (  name		   PGUID 14 f t f 1 f	19 "1043" 100 0 0 100  "select text_name($1)" - ));
1709
DESCR("convert varchar to name");
1710
DATA(insert OID = 1399 (  varchar	   PGUID 14 f t f 1 f 1043 "19" 100 0 0 100  "select name_text($1)" - ));
1711
DESCR("convert convert name to varchar");
1712

1713
/* OIDS 1400 - 1499 */
1714

1715
DATA(insert OID = 1400 (  float		   PGUID 14 f t f 1 f  701	"701" 100 0 0 100  "select $1" - ));
1716
DESCR("convert float8 to float8 (no-op)");
1717
DATA(insert OID = 1401 (  float		   PGUID 14 f t f 1 f  701	"700" 100 0 0 100  "select ftod($1)" - ));
1718
DESCR("convert float4 to float8");
1719
DATA(insert OID = 1402 (  float4	   PGUID 14 f t f 1 f  700	"700" 100 0 0 100  "select $1" - ));
1720
DESCR("convert float4 to float4 (no-op)");
1721
DATA(insert OID = 1403 (  float4	   PGUID 14 f t f 1 f  700	"701" 100 0 0 100  "select dtof($1)" - ));
1722
DESCR("convert float8 to float4");
1723
DATA(insert OID = 1404 (  int		   PGUID 14 f t f 1 f	23	 "23" 100 0 0 100  "select $1" - ));
1724
DESCR("convert (no-op)");
1725
DATA(insert OID = 1405 (  int2		   PGUID 14 f t f 1 f	21	 "21" 100 0 0 100  "select $1" - ));
1726
DESCR("convert (no-op)");
1727
DATA(insert OID = 1406 (  float8	   PGUID 14 f t f 1 f  701	"701" 100 0 0 100  "select $1" - ));
1728
DESCR("convert (no-op)");
1729
DATA(insert OID = 1407 (  float8	   PGUID 14 f t f 1 f  701	"700" 100 0 0 100  "select ftod($1)" - ));
1730
DESCR("convert float4 to float8");
1731
DATA(insert OID = 1408 (  float8	   PGUID 14 f t f 1 f  701	 "23" 100 0 0 100  "select i4tod($1)" - ));
1732
DESCR("convert int4 to float8");
1733
DATA(insert OID = 1409 (  float8	   PGUID 14 f t f 1 f  701	 "21" 100 0 0 100  "select i2tod($1)" - ));
1734
DESCR("convert int2 to float8");
1735
DATA(insert OID = 1410 (  float4	   PGUID 14 f t f 1 f  700	 "23" 100 0 0 100  "select i4tof($1)" - ));
1736
DESCR("convert int4 to float4");
1737
DATA(insert OID = 1411 (  float4	   PGUID 14 f t f 1 f  700	 "21" 100 0 0 100  "select i2tof($1)" - ));
1738
DESCR("convert int2 to float4");
1739
DATA(insert OID = 1412 (  int4		   PGUID 14 f t f 1 f	23	 "23" 100 0 0 100  "select $1" - ));
1740
DESCR("convert (no-op)");
1741
DATA(insert OID = 1413 (  int4		   PGUID 14 f t f 1 f	23	"701" 100 0 0 100  "select dtoi4($1)" - ));
1742
DESCR("convert float8 to int4");
1743
DATA(insert OID = 1414 (  int4		   PGUID 14 f t f 1 f	23	 "21" 100 0 0 100  "select i2toi4($1)" - ));
1744
DESCR("convert int2 to int4");
1745
DATA(insert OID = 1415 (  int4		   PGUID 14 f t f 1 f	23	"700" 100 0 0 100  "select ftoi4($1)" - ));
1746
DESCR("convert float4 to int4");
1747
DATA(insert OID = 1417 (  int2		   PGUID 14 f t f 1 f	21	 "23" 100 0 0 100  "select i4toi2($1)" - ));
1748
DESCR("convert int4 to int2");
1749
DATA(insert OID = 1418 (  int2		   PGUID 14 f t f 1 f	21	"701" 100 0 0 100  "select dtoi2($1)" - ));
1750
DESCR("convert float8 to int2");
1751
DATA(insert OID = 1419 (  int2		   PGUID 14 f t f 1 f	21	"700" 100 0 0 100  "select ftoi2($1)" - ));
1752
DESCR("convert float4 to int2");
1753 1754

DATA(insert OID = 1421 (  box				PGUID 11 f t f 2 f 603 "600 600" 100 0 0 100  foo bar ));
1755
DESCR("convert points to box");
1756
DATA(insert OID = 1422 (  box_add			PGUID 11 f t f 2 f 603 "603 600" 100 0 0 100  foo bar ));
1757
DESCR("add point to box (translate)");
1758
DATA(insert OID = 1423 (  box_sub			PGUID 11 f t f 2 f 603 "603 600" 100 0 0 100  foo bar ));
1759
DESCR("subtract point from box (translate)");
1760
DATA(insert OID = 1424 (  box_mul			PGUID 11 f t f 2 f 603 "603 600" 100 0 0 100  foo bar ));
1761
DESCR("multiply box by point (scale)");
1762
DATA(insert OID = 1425 (  box_div			PGUID 11 f t f 2 f 603 "603 600" 100 0 0 100  foo bar ));
1763
DESCR("divide box by point (scale)");
1764
DATA(insert OID = 1426 (  path_contain_pt	PGUID 11 f t f 2 f	16 "602 600" 100 0 0 100  foo bar ));
1765
DESCR("path contains point?");
1766
DATA(insert OID = 1427 (  pt_contained_path PGUID 11 f t f 2 f	16 "600 602" 100 0 0 100  foo bar ));
1767
DESCR("point contained in path?");
1768
DATA(insert OID = 1428 (  poly_contain_pt	PGUID 11 f t f 2 f	16 "604 600" 100 0 0 100  foo bar ));
1769
DESCR("polygon contains point?");
1770
DATA(insert OID = 1429 (  pt_contained_poly PGUID 11 f t f 2 f	16 "600 604" 100 0 0 100  foo bar ));
1771
DESCR("point contained by polygon?");
1772 1773

DATA(insert OID = 1430 (  path_isclosed		PGUID 11 f t f 1 f	16 "602" 100 0 0 100  foo bar ));
1774
DESCR("");
1775
DATA(insert OID = 1431 (  path_isopen		PGUID 11 f t f 1 f	16 "602" 100 0 0 100  foo bar ));
1776
DESCR("");
1777
DATA(insert OID = 1432 (  path_npoints		PGUID 11 f t f 1 f	23 "602" 100 0 0 100  foo bar ));
1778
DESCR("");
1779
DATA(insert OID = 1433 (  path_close		PGUID 11 f t f 1 f 602 "602" 100 0 0 100  foo bar ));
1780
DESCR("");
1781
DATA(insert OID = 1434 (  path_open			PGUID 11 f t f 1 f 602 "602" 100 0 0 100  foo bar ));
1782
DESCR("");
1783
DATA(insert OID = 1435 (  path_add			PGUID 11 f t f 2 f 602 "602 602" 100 0 0 100  foo bar ));
1784
DESCR("addition");
1785
DATA(insert OID = 1436 (  path_add_pt		PGUID 11 f t f 2 f 602 "602 600" 100 0 0 100  foo bar ));
1786
DESCR("addition");
1787
DATA(insert OID = 1437 (  path_sub_pt		PGUID 11 f t f 2 f 602 "602 600" 100 0 0 100  foo bar ));
1788
DESCR("subtract");
1789
DATA(insert OID = 1438 (  path_mul_pt		PGUID 11 f t f 2 f 602 "602 600" 100 0 0 100  foo bar ));
1790
DESCR("multiply");
1791
DATA(insert OID = 1439 (  path_div_pt		PGUID 11 f t f 2 f 602 "602 600" 100 0 0 100  foo bar ));
1792
DESCR("divide");
1793 1794

DATA(insert OID = 1440 (  point				PGUID 11 f t f 2 f 600 "701 701" 100 0 0 100  foo bar ));
1795
DESCR("convert x, y to point");
1796
DATA(insert OID = 1441 (  point_add			PGUID 11 f t f 2 f 600 "600 600" 100 0 0 100  foo bar ));
1797
DESCR("add points (translate)");
1798
DATA(insert OID = 1442 (  point_sub			PGUID 11 f t f 2 f 600 "600 600" 100 0 0 100  foo bar ));
1799
DESCR("subtract points (translate)");
1800
DATA(insert OID = 1443 (  point_mul			PGUID 11 f t f 2 f 600 "600 600" 100 0 0 100  foo bar ));
1801
DESCR("multiply points (scale/rotate)");
1802
DATA(insert OID = 1444 (  point_div			PGUID 11 f t f 2 f 600 "600 600" 100 0 0 100  foo bar ));
1803
DESCR("divide points (scale/rotate)");
1804 1805

DATA(insert OID = 1445 (  poly_npoints		PGUID 11 f t f 1 f	23 "604" 100 0 0 100  foo bar ));
1806
DESCR("number of points in polygon");
1807
DATA(insert OID = 1446 (  poly_box			PGUID 11 f t f 1 f 603 "604" 100 0 0 100  foo bar ));
1808
DESCR("convert polygon to bounding box");
1809
DATA(insert OID = 1447 (  poly_path			PGUID 11 f t f 1 f 602 "604" 100 0 0 100  foo bar ));
1810
DESCR("convert polygon to path");
1811
DATA(insert OID = 1448 (  box_poly			PGUID 11 f t f 1 f 604 "603" 100 0 0 100  foo bar ));
1812
DESCR("convert box to polygon");
1813
DATA(insert OID = 1449 (  path_poly			PGUID 11 f t f 1 f 604 "602" 100 0 0 100  foo bar ));
1814
DESCR("convert path to polygon");
1815 1816

DATA(insert OID = 1450 (  circle_in			PGUID 11 f t f 1 f 718 "0" 100 0 1 0  foo bar ));
1817
DESCR("(internal)");
1818
DATA(insert OID = 1451 (  circle_out		PGUID 11 f t f 1 f	23	"0" 100 0 1 0  foo bar ));
1819
DESCR("(internal)");
1820
DATA(insert OID = 1452 (  circle_same		PGUID 11 f t f 2 f	16 "718 718" 100 0 1 0	foo bar ));
1821
DESCR("same as");
1822
DATA(insert OID = 1453 (  circle_contain	PGUID 11 f t f 2 f	16 "718 718" 100 0 1 0	foo bar ));
1823
DESCR("contains");
1824
DATA(insert OID = 1454 (  circle_left		PGUID 11 f t f 2 f	16 "718 718" 100 0 1 0	foo bar ));
1825
DESCR("is left of");
1826
DATA(insert OID = 1455 (  circle_overleft	PGUID 11 f t f 2 f	16 "718 718" 100 0 1 0	foo bar ));
1827
DESCR("overlaps, but does not extend to right of");
1828
DATA(insert OID = 1456 (  circle_overright	PGUID 11 f t f 2 f	16 "718 718" 100 0 1 0	foo bar ));
1829
DESCR("");
1830
DATA(insert OID = 1457 (  circle_right		PGUID 11 f t f 2 f	16 "718 718" 100 0 1 0	foo bar ));
1831
DESCR("is left of");
1832
DATA(insert OID = 1458 (  circle_contained	PGUID 11 f t f 2 f	16 "718 718" 100 0 1 0	foo bar ));
1833
DESCR("");
1834
DATA(insert OID = 1459 (  circle_overlap	PGUID 11 f t f 2 f	16 "718 718" 100 0 1 0	foo bar ));
1835
DESCR("overlaps");
1836
DATA(insert OID = 1460 (  circle_below		PGUID 11 f t f 2 f	16 "718 718" 100 0 1 0	foo bar ));
1837
DESCR("is below");
1838
DATA(insert OID = 1461 (  circle_above		PGUID 11 f t f 2 f	16 "718 718" 100 0 1 0	foo bar ));
1839
DESCR("is above");
1840
DATA(insert OID = 1462 (  circle_eq			PGUID 11 f t f 2 f	16 "718 718" 100 0 1 0	foo bar ));
1841
DESCR("equal");
1842
DATA(insert OID = 1463 (  circle_ne			PGUID 11 f t f 2 f	16 "718 718" 100 0 1 0	foo bar ));
1843
DESCR("not equal");
1844
DATA(insert OID = 1464 (  circle_lt			PGUID 11 f t f 2 f	16 "718 718" 100 0 1 0	foo bar ));
1845
DESCR("less-than");
1846
DATA(insert OID = 1465 (  circle_gt			PGUID 11 f t f 2 f	16 "718 718" 100 0 1 0	foo bar ));
1847
DESCR("greater-than");
1848
DATA(insert OID = 1466 (  circle_le			PGUID 11 f t f 2 f	16 "718 718" 100 0 1 0	foo bar ));
1849
DESCR("less-than-or-equal");
1850
DATA(insert OID = 1467 (  circle_ge			PGUID 11 f t f 2 f	16 "718 718" 100 0 1 0	foo bar ));
1851
DESCR("greater-than-or-equal");
1852
DATA(insert OID = 1468 (  circle_area		PGUID 11 f t f 1 f 701 "718" 100 0 1 0	foo bar ));
1853
DESCR("area");
1854
DATA(insert OID = 1469 (  circle_diameter	PGUID 11 f t f 1 f 701 "718" 100 0 1 0	foo bar ));
1855
DESCR("diameter");
1856
DATA(insert OID = 1470 (  circle_radius		PGUID 11 f t f 1 f 701 "718" 100 0 1 0	foo bar ));
1857
DESCR("radius");
1858
DATA(insert OID = 1471 (  circle_distance	PGUID 11 f t f 2 f 701 "718 718" 100 0 1 0	foo bar ));
1859
DESCR("distance between");
1860
DATA(insert OID = 1472 (  circle_center		PGUID 11 f t f 1 f 600 "718" 100 0 1 0	foo bar ));
1861
DESCR("center of");
1862
DATA(insert OID = 1473 (  circle			PGUID 11 f t f 2 f 718 "600 701" 100 0 1 0	foo bar ));
1863
DESCR("convert point and radius to circle");
1864
DATA(insert OID = 1474 (  poly_circle		PGUID 11 f t f 1 f 718 "604" 100 0 1 0	foo bar ));
1865
DESCR("convert polygon to circle");
1866
DATA(insert OID = 1475 (  circle_poly		PGUID 11 f t f 2 f 604 "23 718" 100 0 1 0  foo bar ));
1867
DESCR("convert vertex count and circle to polygon");
1868
DATA(insert OID = 1476 (  dist_pc			PGUID 11 f t f 2 f 701 "600 718" 100 0 1 0	foo bar ));
1869
DESCR("distance between");
1870
DATA(insert OID = 1477 (  circle_contain_pt   PGUID 11 f t f 2 f  16 "718 600" 100 0 0 100	foo bar ));
1871
DESCR("");
1872
DATA(insert OID = 1478 (  pt_contained_circle PGUID 11 f t f 2 f  16 "600 718" 100 0 0 100	foo bar ));
1873
DESCR("");
1874
DATA(insert OID = 1479 (  box_circle		PGUID 11 f t f 1 f 718 "603" 100 0 1 0	foo bar ));
1875
DESCR("convert box to circle");
1876
DATA(insert OID = 1480 (  circle_box		PGUID 11 f t f 1 f 603 "718" 100 0 1 0	foo bar ));
1877
DESCR("convert circle to box");
1878

1879 1880 1881
DATA(insert OID = 1481 (  text_substr		PGUID 11 f t f 3 f 25 "25 23 23" 100 0 0 100  foo bar ));
DESCR("return portion of string");

1882
DATA(insert OID = 1482 (  lseg_ne			PGUID 11 f t f 2 f	16 "601 601" 100 0 0 100  foo bar ));
1883
DESCR("not equal");
1884
DATA(insert OID = 1483 (  lseg_lt			PGUID 11 f t f 2 f	16 "601 601" 100 0 0 100  foo bar ));
1885
DESCR("less-than");
1886
DATA(insert OID = 1484 (  lseg_le			PGUID 11 f t f 2 f	16 "601 601" 100 0 0 100  foo bar ));
1887
DESCR("less-than-or-equal");
1888
DATA(insert OID = 1485 (  lseg_gt			PGUID 11 f t f 2 f	16 "601 601" 100 0 0 100  foo bar ));
1889
DESCR("greater-than");
1890
DATA(insert OID = 1486 (  lseg_ge			PGUID 11 f t f 2 f	16 "601 601" 100 0 0 100  foo bar ));
1891
DESCR("greater-than-or-equal");
1892
DATA(insert OID = 1487 (  lseg_length		PGUID 11 f t f 1 f 701 "601" 100 0 1 0	foo bar ));
1893 1894 1895 1896 1897 1898
DESCR("distance between endpoints");
DATA(insert OID = 1488 (  close_ls			PGUID 11 f t f 2 f 600 "628 601" 100 0 10 100  foo bar ));
DESCR("closest point to line on line segment");
DATA(insert OID = 1489 (  close_lseg		PGUID 11 f t f 2 f 600 "601 601" 100 0 10 100  foo bar ));
DESCR("closest point to line segment on line segment");

1899
DATA(insert OID = 1490 (  line_in			PGUID 11 f t f 1 f 628 "0" 100 0 0 100	foo bar ));
1900
DESCR("(internal)");
1901
DATA(insert OID = 1491 (  line_out			PGUID 11 f t f 1 f 23  "0" 100 0 0 100	foo bar ));
1902
DESCR("(internal)");
1903
DATA(insert OID = 1492 (  line_eq			PGUID 11 f t f 2 f	16 "628 628" 100 0 0 100  foo bar ));
1904
DESCR("lines equal?");
1905
DATA(insert OID = 1493 (  line_construct_pp PGUID 11 f t f 2 f 628 "600 600" 100 0 0 100  foo bar ));
1906 1907 1908
DESCR("line from points");
DATA(insert OID = 1494 (  line_interpt		PGUID 11 f t f 2 f 600 "628 628" 100 0 0 100  foo bar ));
DESCR("intersection point");
1909
DATA(insert OID = 1495 (  line_intersect	PGUID 11 f t f 2 f	16 "628 628" 100 0 0 100  foo bar ));
1910
DESCR("lines intersect?");
1911
DATA(insert OID = 1496 (  line_parallel		PGUID 11 f t f 2 f	16 "628 628" 100 0 0 100  foo bar ));
1912
DESCR("lines parallel?");
1913
DATA(insert OID = 1497 (  line_perp			PGUID 11 f t f 2 f	16 "628 628" 100 0 0 100  foo bar ));
1914
DESCR("lines perpendicular?");
1915
DATA(insert OID = 1498 (  line_vertical		PGUID 11 f t f 1 f	16 "628" 100 0 0 100  foo bar ));
1916
DESCR("lines vertical?");
1917
DATA(insert OID = 1499 (  line_horizontal	PGUID 11 f t f 1 f	16 "628" 100 0 0 100  foo bar ));
1918 1919 1920 1921
DESCR("lines horizontal?");

/* OIDS 1500 - 1599 */

1922
DATA(insert OID = 1530 (  point				PGUID 14 f t f 2 f 600 "601 601" 100 0 0 100  "select lseg_interpt($1, $2)" - ));
1923
DESCR("convert two line segments to point (intersection)");
1924
DATA(insert OID = 1531 (  point				PGUID 14 f t f 1 f 600 "718" 100 0 0 100  "select circle_center($1)" - ));
1925
DESCR("convert circle to point (center)");
1926
DATA(insert OID = 1532 (  isvertical		PGUID 14 f t f 2 f	16 "600 600" 100 0 0 100  "select point_vert($1, $2)" - ));
1927
DESCR("");
1928
DATA(insert OID = 1533 (  ishorizontal		PGUID 14 f t f 2 f	16 "600 600" 100 0 0 100  "select point_horiz($1, $2)" - ));
1929
DESCR("");
1930
DATA(insert OID = 1534 (  slope				PGUID 14 f t f 2 f 701 "600 600" 100 0 0 100  "select point_slope($1, $2)" - ));
1931
DESCR("");
1932 1933

DATA(insert OID = 1540 (  lseg				PGUID 14 f t f 2 f 601 "600 600" 100 0 0 100  "select lseg_construct($1, $2)" - ));
1934
DESCR("");
1935
DATA(insert OID = 1541 (  lseg				PGUID 14 f t f 1 f 601 "603" 100 0 0 100  "select box_diagonal($1)" - ));
1936
DESCR("");
1937
DATA(insert OID = 1542 (  isparallel		PGUID 14 f t f 2 f	16 "601 601" 100 0 0 100  "select lseg_parallel($1, $2)" - ));
1938
DESCR("");
1939
DATA(insert OID = 1543 (  isperpendicular	PGUID 14 f t f 2 f	16 "601 601" 100 0 0 100  "select lseg_perp($1, $2)" - ));
1940
DESCR("");
1941
DATA(insert OID = 1544 (  isvertical		PGUID 14 f t f 1 f	16 "601" 100 0 0 100  "select lseg_vertical($1)" - ));
1942
DESCR("");
1943
DATA(insert OID = 1545 (  ishorizontal		PGUID 14 f t f 1 f	16 "601" 100 0 0 100  "select lseg_horizontal($1)" - ));
1944
DESCR("");
1945

1946
/* pclose and popen might better be named close and open, but that crashes initdb.
1947 1948 1949
 * - tgl 97/04/20
 */

1950
DATA(insert OID = 1550 (  path				PGUID 14 f t f 1 f 602 "604" 100 0 0 100  "select poly_path($1)" - ));
1951
DESCR("");
1952
DATA(insert OID = 1551 (  length			PGUID 14 f t f 1 f 701 "602" 100 0 1 0	"select path_length($1)" - ));
1953
DESCR("sum of lengths of path segments");
1954
DATA(insert OID = 1552 (  points			PGUID 14 f t f 1 f	23 "602" 100 0 0 100  "select path_npoints($1)" - ));
1955
DESCR("");
1956
DATA(insert OID = 1553 (  pclose			PGUID 14 f t f 1 f 602 "602" 100 0 0 100  "select path_close($1)" - ));
1957
DESCR("");
1958
DATA(insert OID = 1554 (  popen				PGUID 14 f t f 1 f 602 "602" 100 0 0 100  "select path_open($1)" - ));
1959
DESCR("");
1960
DATA(insert OID = 1555 (  isopen			PGUID 14 f t f 1 f	16 "602" 100 0 0 100  "select path_isopen($1)" - ));
1961
DESCR("");
1962
DATA(insert OID = 1556 (  isclosed			PGUID 14 f t f 1 f	16 "602" 100 0 0 100  "select path_isclosed($1)" - ));
1963
DESCR("");
1964 1965

DATA(insert OID = 1560 (  box				PGUID 14 f t f 2 f 603 "603 603" 100 0 0 100  "select box_intersect($1, $2)" - ));
1966
DESCR("convert boxes to box (intersection)");
1967
DATA(insert OID = 1561 (  box				PGUID 14 f t f 1 f 603 "604" 100 0 0 100  "select poly_box($1)" - ));
1968
DESCR("convert polygon to box");
1969
DATA(insert OID = 1562 (  width				PGUID 14 f t f 1 f 701 "603" 100 0 0 100  "select box_width($1)" - ));
1970
DESCR("box width");
1971
DATA(insert OID = 1563 (  height			PGUID 14 f t f 1 f 701 "603" 100 0 0 100  "select box_height($1)" - ));
1972
DESCR("box height");
1973
DATA(insert OID = 1564 (  center			PGUID 14 f t f 1 f 600 "603" 100 0 0 100  "select box_center($1)" - ));
1974
DESCR("box center");
1975
DATA(insert OID = 1565 (  area				PGUID 14 f t f 1 f 701 "603" 100 0 0 100  "select box_area($1)" - ));
1976
DESCR("box area");
1977
DATA(insert OID = 1569 (  box				PGUID 14 f t f 1 f 603 "718" 100 0 0 100  "select circle_box($1)" - ));
1978
DESCR("convert circle to box");
1979 1980

DATA(insert OID = 1570 (  polygon			PGUID 14 f t f 1 f 604 "602" 100 0 0 100  "select path_poly($1)" - ));
1981
DESCR("convert path to polygon");
1982
DATA(insert OID = 1571 (  polygon			PGUID 14 f t f 1 f 604 "603" 100 0 0 100  "select box_poly($1)" - ));
1983
DESCR("convert box to polygon");
1984
DATA(insert OID = 1572 (  polygon			PGUID 14 f t f 2 f 604 "23 718" 100 0 0 100  "select circle_poly($1, $2)" - ));
1985
DESCR("convert circle to polygon");
1986
DATA(insert OID = 1573 (  polygon			PGUID 14 f t f 1 f 604 "718" 100 0 0 100  "select circle_poly(12, $1)" - ));
1987
DESCR("convert circle to 12-vertex polygon");
1988
DATA(insert OID = 1574 (  points			PGUID 14 f t f 1 f	23 "604" 100 0 0 100  "select poly_npoints($1)" - ));
1989
DESCR("");
1990
DATA(insert OID = 1575 (  center			PGUID 14 f t f 1 f 600 "604" 100 0 0 100  "select poly_center($1)" - ));
1991
DESCR("");
1992 1993
DATA(insert OID = 1576 (  length			PGUID 14 f t f 1 f 701 "601" 100 0 1 0	"select lseg_length($1)" - ));
DESCR("distance between endpoints");
1994 1995

DATA(insert OID = 1579 (  circle			PGUID 14 f t f 1 f 718 "603" 100 0 0 100  "select box_circle($1)" - ));
1996
DESCR("convert box to circle");
1997
DATA(insert OID = 1580 (  circle			PGUID 14 f t f 1 f 718 "604" 100 0 0 100  "select poly_circle($1)" - ));
1998
DESCR("convert polygon to circle");
1999
DATA(insert OID = 1581 (  center			PGUID 14 f t f 1 f 600 "718" 100 0 0 100  "select circle_center($1)" - ));
2000
DESCR("center of circle");
2001
DATA(insert OID = 1582 (  radius			PGUID 14 f t f 1 f 701 "718" 100 0 0 100  "select circle_radius($1)" - ));
2002
DESCR("radius of circle");
2003
DATA(insert OID = 1583 (  diameter			PGUID 14 f t f 1 f 701 "718" 100 0 0 100  "select circle_diameter($1)" - ));
2004
DESCR("diameter of circle");
2005
DATA(insert OID = 1584 (  area				PGUID 14 f t f 1 f 701 "718" 100 0 0 100  "select circle_area($1)" - ));
2006
DESCR("area of circle");
2007

2008
DATA(insert OID = 1592 (  int8				PGUID 14 f t f 1 f	20 "20" 100 0 0 100  "select $1" - ));
2009
DESCR("convert int8 to int8 (no-op)");
2010
DATA(insert OID = 1593 (  int8				PGUID 14 f t f 1 f	20 "23" 100 0 0 100  "select int48($1)" - ));
2011
DESCR("convert int4 to int8");
2012
DATA(insert OID = 1594 (  int8				PGUID 14 f t f 1 f	20 "701" 100 0 0 100  "select dtoi8($1)" - ));
2013
DESCR("convert float8 to int8");
2014
DATA(insert OID = 1595 (  int4				PGUID 14 f t f 1 f	23 "20" 100 0 0 100  "select int84($1)" - ));
2015 2016 2017 2018
DESCR("convert int8 to int4");
DATA(insert OID = 1596 (  float8			PGUID 14 f t f 1 f 701 "20" 100 0 0 100  "select i8tod($1)" - ));
DESCR("convert int8 to float8");

2019 2020 2021
/* OIDS 1600 - 1699 */

DATA(insert OID = 1600 (  line				PGUID 14 f t f 2 f 628 "600 600" 100 0 0 100  "select line_construct_pp($1, $2)" - ));
2022
DESCR("points to line");
2023
DATA(insert OID = 1601 (  ishorizontal		PGUID 14 f t f 1 f	16 "628" 100 0 0 100  "select line_horizontal($1)" - ));
2024
DESCR("is line horizontal?");
2025
DATA(insert OID = 1602 (  isvertical		PGUID 14 f t f 1 f	16 "628" 100 0 0 100  "select line_vertical($1)" - ));
2026
DESCR("is line vertical?");
2027
DATA(insert OID = 1603 (  isparallel		PGUID 14 f t f 2 f	16 "628 628" 100 0 0 100  "select line_parallel($1, $2)" - ));
2028 2029 2030
DESCR("are lines parallel?");

DATA(insert OID = 1604 (  float8	   PGUID 14 f t f 1 f 701 "25" 100 0 0 100  "select text_float8($1)" - ));
2031
DESCR("convert text to float8");
2032
DATA(insert OID = 1605 (  float4	   PGUID 14 f t f 1 f 700 "25" 100 0 0 100  "select text_float4($1)" - ));
2033
DESCR("convert text to float4");
2034
DATA(insert OID = 1606 (  text		   PGUID 14 f t f 1 f  25 "701" 100 0 0 100  "select float8_text($1)" - ));
2035
DESCR("convert float8 to text");
2036
DATA(insert OID = 1607 (  text		   PGUID 14 f t f 1 f  25 "700" 100 0 0 100  "select float4_text($1)" - ));
2037
DESCR("convert float4 to text");
2038

2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 2050 2051
DATA(insert OID = 1619 (  varchar	   PGUID 14 f t f 1 f 1043 "23" 100 0 0 100  "select int4_text($1)" - ));
DESCR("convert int4 to varchar");
DATA(insert OID = 1620 (  int4		   PGUID 14 f t f 1 f   23 "1043" 100 0 0 100  "select text_int4($1)" - ));
DESCR("convert varchar to int4");
DATA(insert OID = 1621 (  text		   PGUID 14 f t f 1 f  25 "20" 100 0 0 100  "select int8_text($1)" - ));
DESCR("convert int8 to text");
DATA(insert OID = 1622 (  int8		   PGUID 14 f t f 1 f  20 "25" 100 0 0 100  "select text_int8($1)" - ));
DESCR("convert text to int8");
DATA(insert OID = 1623 (  varchar	   PGUID 14 f t f 1 f 1043 "20" 100 0 0 100  "select int8_text($1)" - ));
DESCR("convert int8 to varchar");
DATA(insert OID = 1624 (  int8		   PGUID 14 f t f 1 f  20 "1043" 100 0 0 100  "select text_int8($1)" - ));
DESCR("convert varchar to int8");

2052
/* Oracle Compatibility Related Functions - By Edmund Mergl <E.Mergl@bawue.de> */
2053
DATA(insert OID =  868 (  strpos	   PGUID 14 f t f 2 f 23 "25 25" 100 0 0 100  "select textpos($1, $2)" - ));
2054
DESCR("find position of substring");
2055
DATA(insert OID =  870 (  lower		   PGUID 11 f t f 1 f 25 "25" 100 0 0 100  foo bar ));
2056
DESCR("lowercase");
2057
DATA(insert OID =  871 (  upper		   PGUID 11 f t f 1 f 25 "25" 100 0 0 100  foo bar ));
2058
DESCR("uppercase");
2059
DATA(insert OID =  872 (  initcap	   PGUID 11 f t f 1 f 25 "25" 100 0 0 100  foo bar ));
2060
DESCR("capitalize each word");
2061
DATA(insert OID =  873 (  lpad		   PGUID 11 f t f 3 f 25 "25 23 25" 100 0 0 100  foo bar ));
2062
DESCR("left-pad string to length");
2063
DATA(insert OID =  874 (  rpad		   PGUID 11 f t f 3 f 25 "25 23 25" 100 0 0 100  foo bar ));
2064
DESCR("right-pad string to length");
2065
DATA(insert OID =  875 (  ltrim		   PGUID 11 f t f 2 f 25 "25 25" 100 0 0 100  foo bar ));
2066
DESCR("left-pad string to length");
2067
DATA(insert OID =  876 (  rtrim		   PGUID 11 f t f 2 f 25 "25 25" 100 0 0 100  foo bar ));
2068
DESCR("right-pad string to length");
2069
DATA(insert OID =  877 (  substr	   PGUID 14 f t f 3 f 25 "25 23 23" 100 0 0 100  "select text_substr($1, $2, $3)" - ));
2070
DESCR("return portion of string");
2071
DATA(insert OID =  878 (  translate    PGUID 11 f t f 3 f 25 "25 18 18" 100 0 0 100  foo bar ));
2072
DESCR("modify string by substring replacement");
2073
DATA(insert OID =  879 (  lpad		   PGUID 14 f t f 2 f 25 "25 23" 100 0 0 100  "select lpad($1, $2, \' \')" - ));
2074
DESCR("left-pad string to length");
2075
DATA(insert OID =  880 (  rpad		   PGUID 14 f t f 2 f 25 "25 23" 100 0 0 100  "select rpad($1, $2, \' \')" - ));
2076
DESCR("right-pad string to length");
2077
DATA(insert OID =  881 (  ltrim		   PGUID 14 f t f 1 f 25 "25" 100 0 0 100  "select ltrim($1, \' \')" - ));
2078
DESCR("remove initial characters from string");
2079
DATA(insert OID =  882 (  rtrim		   PGUID 14 f t f 1 f 25 "25" 100 0 0 100  "select rtrim($1, \' \')" - ));
2080
DESCR("remove trailing characters from string");
2081
DATA(insert OID =  883 (  substr	   PGUID 14 f t f 2 f 25 "25 23" 100 0 0 100  "select text_substr($1, $2, -1)" - ));
2082
DESCR("return portion of string");
2083
DATA(insert OID =  884 (  btrim		   PGUID 11 f t f 2 f 25 "25 25" 100 0 0 100  foo bar ));
2084
DESCR("trim both ends of string");
2085
DATA(insert OID =  885 (  btrim		   PGUID 14 f t f 1 f 25 "25" 100 0 0 100  "select btrim($1, \' \')" - ));
2086
DESCR("trim both ends of string");
2087

M
 
Marc G. Fournier 已提交
2088

2089
/* SEQUENCEs nextval & currval functions */
2090
DATA(insert OID =  1317 (  nextval	   PGUID 11 f t f 1 f 23 "25" 100 0 0 100  foo bar ));
2091
DESCR("sequence next value");
2092
DATA(insert OID =  1319 (  currval	   PGUID 11 f t f 1 f 23 "25" 100 0 0 100  foo bar ));
2093
DESCR("sequence current value");
M
 
Marc G. Fournier 已提交
2094 2095
DATA(insert OID =  1618 (  setval	   PGUID 11 f t f 2 f 23 "25 23" 100 0 0 100  foo bar ));
DESCR("sequence set value");
2096

M
 
Marc G. Fournier 已提交
2097 2098
/* for multi-byte support */
DATA(insert OID = 1039 (  getdatabaseencoding	   PGUID 11 f t f 0 f 19 "0" 100 0 0 100  foo bar ));
2099

2100 2101 2102 2103 2104
/* System-view support functions */
DATA(insert OID = 1640 (  pg_get_ruledef	   PGUID 11 f t f 1 f 25 "19" 100 0 0 100  foo bar ));
DESCR("source text of a rule");
DATA(insert OID = 1641 (  pg_get_viewdef	   PGUID 11 f t f 1 f 25 "19" 100 0 0 100  foo bar ));
DESCR("select statement of a view");
2105 2106 2107 2108
DATA(insert OID = 1642 (  pg_get_userbyid	   PGUID 11 f t f 1 f 19 "23" 100 0 0 100  foo bar ));
DESCR("user name by UID (with fallback)");
DATA(insert OID = 1643 (  pg_get_indexdef	   PGUID 11 f t f 1 f 25 "26" 100 0 0 100  foo bar ));
DESCR("index description");
2109

2110 2111 2112 2113 2114 2115 2116 2117 2118 2119 2120 2121 2122 2123 2124 2125 2126 2127 2128 2129 2130 2131 2132
/* for mac type support */
DATA(insert OID = 436 (  macaddr_in			PGUID 11 f t f 1 f 829 "0" 100 0 0 100	foo bar ));
DESCR("(internal)");
DATA(insert OID = 437 (  macaddr_out		PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
DESCR("(internal)");

DATA(insert OID = 830 (  macaddr_eq		   PGUID 11 f t f 2 f 16 "829 829" 100 0 0 100  foo bar ));
DESCR("equal");
DATA(insert OID = 831 (  macaddr_lt		   PGUID 11 f t f 2 f 16 "829 829" 100 0 0 100  foo bar ));
DESCR("less-than");
DATA(insert OID = 832 (  macaddr_le		   PGUID 11 f t f 2 f 16 "829 829" 100 0 0 100  foo bar ));
DESCR("less-than-or-equal");
DATA(insert OID = 833 (  macaddr_gt		   PGUID 11 f t f 2 f 16 "829 829" 100 0 0 100  foo bar ));
DESCR("greater-than");
DATA(insert OID = 834 (  macaddr_ge		   PGUID 11 f t f 2 f 16 "829 829" 100 0 0 100  foo bar ));
DESCR("greater-than-or-equal");
DATA(insert OID = 835 (  macaddr_ne		   PGUID 11 f t f 2 f 16 "829 829" 100 0 0 100  foo bar ));
DESCR("not equal");
DATA(insert OID = 836 (  macaddr_cmp	   PGUID 11 f t f 2 f 23 "829 829" 100 0 0 100  foo bar ));
DESCR("less-equal-greater");
DATA(insert OID = 837 (  macaddr_manuf	   PGUID 11 f t f 1 f 25 "829" 100 0 0 100  foo bar ));
DESCR("MAC manufacturer");

2133
/* for inet type support */
2134
DATA(insert OID = 910 (  inet_in			PGUID 11 f t f 1 f 869 "0" 100 0 0 100	foo bar ));
2135
DESCR("(internal)");
2136
DATA(insert OID = 911 (  inet_out			PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
2137 2138
DESCR("(internal)");

2139 2140 2141
/* for cidr type support */
DATA(insert OID = 1267 (  cidr_in           PGUID 11 f t f 1 f 650 "0" 100 0 0 100  foo bar ));
DESCR("(internal)");
2142 2143
DATA(insert OID = 1416 (  cidr_out			PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
DESCR("(internal)");
2144 2145

/* these are used for both inet and cidr */
B
Bruce Momjian 已提交
2146
DATA(insert OID = 920 (  network_eq		   PGUID 11 f t f 2 f 16 "869 869" 100 0 0 100  foo bar ));
2147
DESCR("equal");
B
Bruce Momjian 已提交
2148
DATA(insert OID = 921 (  network_lt		   PGUID 11 f t f 2 f 16 "869 869" 100 0 0 100  foo bar ));
2149
DESCR("less-than");
B
Bruce Momjian 已提交
2150
DATA(insert OID = 922 (  network_le		   PGUID 11 f t f 2 f 16 "869 869" 100 0 0 100  foo bar ));
2151
DESCR("less-than-or-equal");
B
Bruce Momjian 已提交
2152
DATA(insert OID = 923 (  network_gt		   PGUID 11 f t f 2 f 16 "869 869" 100 0 0 100  foo bar ));
2153
DESCR("greater-than");
B
Bruce Momjian 已提交
2154
DATA(insert OID = 924 (  network_ge		   PGUID 11 f t f 2 f 16 "869 869" 100 0 0 100  foo bar ));
2155
DESCR("greater-than-or-equal");
B
Bruce Momjian 已提交
2156
DATA(insert OID = 925 (  network_ne		   PGUID 11 f t f 2 f 16 "869 869" 100 0 0 100  foo bar ));
2157
DESCR("not equal");
B
Bruce Momjian 已提交
2158
DATA(insert OID = 926 (  network_cmp	   	   PGUID 11 f t f 2 f 23 "869 869" 100 0 0 100  foo bar ));
2159
DESCR("less-equal-greater");
B
Bruce Momjian 已提交
2160
DATA(insert OID = 927 (  network_sub	   	   PGUID 11 f t f 2 f 16 "869 869" 100 0 0 100  foo bar ));
2161
DESCR("is-subnet");
B
Bruce Momjian 已提交
2162
DATA(insert OID = 928 (  network_subeq  	   PGUID 11 f t f 2 f 16 "869 869" 100 0 0 100  foo bar ));
2163
DESCR("is-subnet-or-equal");
B
Bruce Momjian 已提交
2164
DATA(insert OID = 929 (  network_sup	   	   PGUID 11 f t f 2 f 16 "869 869" 100 0 0 100  foo bar ));
2165
DESCR("is-supernet");
B
Bruce Momjian 已提交
2166
DATA(insert OID = 930 (  network_supeq  	   PGUID 11 f t f 2 f 16 "869 869" 100 0 0 100  foo bar ));
2167 2168
DESCR("is-supernet-or-equal");

2169
/* inet/cidr versions */
B
Bruce Momjian 已提交
2170
DATA(insert OID = 940 (  network_netmask		PGUID 11 f t f 1 f 25 "869" 100 0 0 100  foo bar ));
B
Bruce Momjian 已提交
2171
DESCR("netmask of address");
B
Bruce Momjian 已提交
2172
DATA(insert OID = 941 (  network_masklen		PGUID 11 f t f 1 f 23 "869" 100 0 0 100  foo bar ));
2173
DESCR("netmask length");
B
Bruce Momjian 已提交
2174
DATA(insert OID = 945 (  network_broadcast		PGUID 11 f t f 1 f 25 "869" 100 0 0 100  foo bar ));
2175
DESCR("broadcast address");
B
Bruce Momjian 已提交
2176
DATA(insert OID = 682 (  network_host			PGUID 11 f t f 1 f 25 "869" 100 0 0 100  foo bar ));
2177
DESCR("host address");
B
Bruce Momjian 已提交
2178 2179
DATA(insert OID = 473 (  network_network		PGUID 11 f t f 1 f 25 "869" 100 0 0 100  foo bar ));
DESCR("network address");
2180

B
Bruce Momjian 已提交
2181 2182 2183 2184 2185 2186 2187 2188 2189 2190 2191
/* shortcut names */
DATA(insert OID = 696 (  netmask				PGUID 14 f t f 1 f 25 "869" 100 0 0 100  "select network_netmask($1)" - ));
DESCR("netmask of address");
DATA(insert OID = 697 (  masklen				PGUID 14 f t f 1 f 23 "869" 100 0 0 100  "select network_masklen($1)" - ));
DESCR("netmask length");
DATA(insert OID = 698 (  broadcast				PGUID 14 f t f 1 f 25 "869" 100 0 0 100  "select network_broadcast($1)" - ));
DESCR("broadcast address");
DATA(insert OID = 699 (  host					PGUID 14 f t f 1 f 25 "869" 100 0 0 100  "select network_host($1)" - ));
DESCR("host address");
DATA(insert OID = 683 (  network				PGUID 14 f t f 1 f 25 "869" 100 0 0 100  "select network_network($1)" - ));
DESCR("network address");
2192

2193 2194 2195 2196 2197 2198 2199 2200 2201 2202 2203 2204 2205 2206 2207 2208 2209 2210 2211 2212 2213 2214 2215 2216 2217 2218 2219 2220 2221 2222 2223 2224 2225 2226 2227 2228 2229 2230 2231 2232 2233 2234 2235 2236 2237 2238 2239 2240 2241 2242 2243 2244 2245 2246 2247 2248 2249 2250 2251 2252 2253 2254 2255 2256 2257 2258 2259 2260 2261 2262 2263 2264 2265 2266 2267 2268 2269 2270 2271 2272 2273 2274 2275 2276 2277 2278 2279 2280 2281 2282 2283 2284 2285 2286 2287 2288 2289 2290 2291 2292 2293 2294 2295 2296 2297 2298 2299 2300 2301 2302 2303 2304 2305
/* OID's 1700 - 1799 NUMERIC data type */
DATA(insert OID = 1701 ( numeric_in				PGUID 11 f t f 1 f 1700 "0" 100 0 0 100  foo bar ));
DESCR("(internal)");
DATA(insert OID = 1702 ( numeric_out			PGUID 11 f t f 1 f 23 "0" 100 0 0 100  foo bar ));
DESCR("(internal)");
DATA(insert OID = 1703 ( numeric				PGUID 11 f t f 2 f 1700 "1700 23" 100 0 0 100  foo bar ));
DESCR("(internal)");
DATA(insert OID = 1704 ( numeric_abs			PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100  foo bar ));
DESCR("absolute value");
DATA(insert OID = 1705 ( abs					PGUID 14 f t f 1 f 1700 "1700" 100 0 0 100  "select numeric_abs($1)" - ));
DESCR("absolute value");
DATA(insert OID = 1706 ( numeric_sign			PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100  foo bar ));
DESCR("sign of value");
DATA(insert OID = 1707 ( sign					PGUID 14 f t f 1 f 1700 "1700" 100 0 0 100  "select numeric_sign($1)" - ));
DESCR("sign of value");
DATA(insert OID = 1708 ( numeric_round			PGUID 11 f t f 2 f 1700 "1700 23" 100 0 0 100  foo bar ));
DESCR("value rounded to 'scale'");
DATA(insert OID = 1709 ( round					PGUID 14 f t f 2 f 1700 "1700 23" 100 0 0 100  "select numeric_round($1,$2)" - ));
DESCR("value rounded to 'scale'");
DATA(insert OID = 1710 ( round					PGUID 14 f t f 1 f 1700 "1700" 100 0 0 100  "select numeric_round($1,0)" - ));
DESCR("value rounded to 'scale' of zero");
DATA(insert OID = 1711 ( numeric_trunc			PGUID 11 f t f 2 f 1700 "1700 23" 100 0 0 100  foo bar ));
DESCR("value truncated to 'scale'");
DATA(insert OID = 1712 ( trunc					PGUID 14 f t f 2 f 1700 "1700 23" 100 0 0 100  "select numeric_trunc($1,$2)" - ));
DESCR("value truncated to 'scale'");
DATA(insert OID = 1713 ( trunc					PGUID 14 f t f 1 f 1700 "1700" 100 0 0 100  "select numeric_trunc($1,0)" - ));
DESCR("value truncated to 'scale' of zero");
DATA(insert OID = 1714 ( numeric_ceil			PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100  foo bar ));
DESCR("smallest integer >= value");
DATA(insert OID = 1715 ( ceil					PGUID 14 f t f 1 f 1700 "1700" 100 0 0 100  "select numeric_ceil($1)" - ));
DESCR("smallest integer >= value");
DATA(insert OID = 1716 ( numeric_floor			PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100  foo bar ));
DESCR("largest integer <= value");
DATA(insert OID = 1717 ( floor					PGUID 14 f t f 1 f 1700 "1700" 100 0 0 100  "select numeric_floor($1)" - ));
DESCR("largest integer <= value");
DATA(insert OID = 1718 ( numeric_eq				PGUID 11 f t f 2 f 16 "1700 1700" 100 0 0 100  foo bar ));
DESCR("equal");
DATA(insert OID = 1719 ( numeric_ne				PGUID 11 f t f 2 f 16 "1700 1700" 100 0 0 100  foo bar ));
DESCR("not equal");
DATA(insert OID = 1720 ( numeric_gt				PGUID 11 f t f 2 f 16 "1700 1700" 100 0 0 100  foo bar ));
DESCR("greater-than");
DATA(insert OID = 1721 ( numeric_ge				PGUID 11 f t f 2 f 16 "1700 1700" 100 0 0 100  foo bar ));
DESCR("greater-than-or-equal");
DATA(insert OID = 1722 ( numeric_lt				PGUID 11 f t f 2 f 16 "1700 1700" 100 0 0 100  foo bar ));
DESCR("lower-than");
DATA(insert OID = 1723 ( numeric_le				PGUID 11 f t f 2 f 16 "1700 1700" 100 0 0 100  foo bar ));
DESCR("lower-than-or-equal");
DATA(insert OID = 1724 ( numeric_add			PGUID 11 f t f 2 f 1700 "1700 1700" 100 0 0 100  foo bar ));
DESCR("addition");
DATA(insert OID = 1725 ( numeric_sub			PGUID 11 f t f 2 f 1700 "1700 1700" 100 0 0 100  foo bar ));
DESCR("subtract");
DATA(insert OID = 1726 ( numeric_mul			PGUID 11 f t f 2 f 1700 "1700 1700" 100 0 0 100  foo bar ));
DESCR("multiply");
DATA(insert OID = 1727 ( numeric_div			PGUID 11 f t f 2 f 1700 "1700 1700" 100 0 0 100  foo bar ));
DESCR("divide");
DATA(insert OID = 1728 ( numeric_mod			PGUID 11 f t f 2 f 1700 "1700 1700" 100 0 0 100  foo bar ));
DESCR("modulus");
DATA(insert OID = 1729 ( mod					PGUID 14 f t f 2 f 1700 "1700 1700" 100 0 0 100  "select numeric_mod($1,$2)" - ));
DESCR("modulus");
DATA(insert OID = 1730 ( numeric_sqrt			PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100  foo bar ));
DESCR("square root");
DATA(insert OID = 1731 ( sqrt					PGUID 14 f t f 1 f 1700 "1700" 100 0 0 100  "select numeric_sqrt($1)" - ));
DESCR("square root");
DATA(insert OID = 1732 ( numeric_exp			PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100  foo bar ));
DESCR("e raised to the power of n");
DATA(insert OID = 1733 ( exp					PGUID 14 f t f 1 f 1700 "1700" 100 0 0 100  "select numeric_exp($1)" - ));
DESCR("e raised to the power of n");
DATA(insert OID = 1734 ( numeric_ln				PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100  foo bar ));
DESCR("natural logarithm of n");
DATA(insert OID = 1735 ( ln						PGUID 14 f t f 1 f 1700 "1700" 100 0 0 100  "select numeric_ln($1)" - ));
DESCR("natural logarithm of n");
DATA(insert OID = 1736 ( numeric_log			PGUID 11 f t f 2 f 1700 "1700 1700" 100 0 0 100  foo bar ));
DESCR("logarithm base m of n");
DATA(insert OID = 1737 ( log					PGUID 14 f t f 2 f 1700 "1700 1700" 100 0 0 100  "select numeric_log($1,$2)" - ));
DESCR("logarithm base m of n");
DATA(insert OID = 1738 ( numeric_power			PGUID 11 f t f 2 f 1700 "1700 1700" 100 0 0 100  foo bar ));
DESCR("m raised to the power of n");
DATA(insert OID = 1739 ( power					PGUID 14 f t f 2 f 1700 "1700 1700" 100 0 0 100  "select numeric_power($1,$2)" - ));
DESCR("m raised to the power of n");
DATA(insert OID = 1740 ( int4_numeric			PGUID 11 f t f 1 f 1700 "23" 100 0 0 100  foo bar ));
DESCR("(internal)");
DATA(insert OID = 1741 ( numeric				PGUID 14 f t f 1 f 1700 "23" 100 0 0 100  "select int4_numeric($1)" - ));
DESCR("(internal)");
DATA(insert OID = 1742 ( float4_numeric			PGUID 11 f t f 1 f 1700 "700" 100 0 0 100  foo bar ));
DESCR("(internal)");
DATA(insert OID = 1743 ( numeric				PGUID 14 f t f 1 f 1700 "700" 100 0 0 100  "select float4_numeric($1)" - ));
DESCR("(internal)");
DATA(insert OID = 1744 ( float8_numeric			PGUID 11 f t f 1 f 1700 "701" 100 0 0 100  foo bar ));
DESCR("(internal)");
DATA(insert OID = 1745 ( numeric				PGUID 14 f t f 1 f 1700 "701" 100 0 0 100  "select float8_numeric($1)" - ));
DESCR("(internal)");
DATA(insert OID = 1746 ( numeric_int4			PGUID 11 f t f 1 f 23 "1700" 100 0 0 100  foo bar ));
DESCR("(internal)");
DATA(insert OID = 1747 ( int4					PGUID 14 f t f 1 f 23 "1700" 100 0 0 100  "select numeric_int4($1)" - ));
DESCR("(internal)");
DATA(insert OID = 1748 ( numeric_float4			PGUID 11 f t f 1 f 700 "1700" 100 0 0 100  foo bar ));
DESCR("(internal)");
DATA(insert OID = 1749 ( float4					PGUID 14 f t f 1 f 700 "1700" 100 0 0 100  "select numeric_float4($1)" - ));
DESCR("(internal)");
DATA(insert OID = 1750 ( numeric_float8			PGUID 11 f t f 1 f 701 "1700" 100 0 0 100  foo bar ));
DESCR("(internal)");
DATA(insert OID = 1751 ( float8					PGUID 14 f t f 1 f 701 "1700" 100 0 0 100  "select numeric_float8($1)" - ));
DESCR("(internal)");
DATA(insert OID = 1764 ( numeric_inc			PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100  foo bar ));
DESCR("increment by one");
DATA(insert OID = 1765 ( numeric_dec			PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100  foo bar ));
DESCR("decrement by one");
DATA(insert OID = 1766 ( numeric_smaller		PGUID 11 f t f 2 f 1700 "1700 1700" 100 0 0 100  foo bar ));
DESCR("smaller of two numbers");
DATA(insert OID = 1767 ( numeric_larger			PGUID 11 f t f 2 f 1700 "1700 1700" 100 0 0 100  foo bar ));
DESCR("larger of two numbers");


2306 2307
/*
 * prototypes for functions pg_proc.c
2308
 */
2309
extern Oid ProcedureCreate(char *procedureName,
2310 2311 2312 2313 2314 2315 2316 2317 2318 2319 2320
				bool returnsSet,
				char *returnTypeName,
				char *languageName,
				char *prosrc,
				char *probin,
				bool canCache,
				bool trusted,
				int32 byte_pct,
				int32 perbyte_cpu,
				int32 percall_cpu,
				int32 outin_ratio,
2321
				List *argList,
2322 2323 2324
				CommandDest dest);


2325
#endif	 /* PG_PROC_H */