1 /*-------------------------------------------------------------------------
4 * definition of the system "procedure" relation (pg_proc)
5 * along with the relation's initial contents.
7 * Copyright (c) 1994, Regents of the University of California
9 * $Id: pg_proc.h,v 1.96 1999/04/20 03:51:13 tgl Exp $
12 * The script catalog/genbki.sh reads this file and generates .bki
13 * information from the DATA() statements. utils/Gen_fmgrtab.sh
14 * generates fmgr.h and fmgrtab.c the same way.
16 * XXX do NOT break up DATA() statements into multiple lines!
17 * the scripts are not as smart as you might think...
18 * XXX (eg. #if 0 #endif won't do what you think)
20 *-------------------------------------------------------------------------
25 #include <tcop/dest.h>
28 * postgres.h contains the system type definintions and the
29 * CATALOG(), BOOTSTRAP and DATA() sugar words so this file
30 * can be read by both genbki.sh and the C compiler.
35 * pg_proc definition. cpp turns this into
36 * typedef struct FormData_pg_proc
39 CATALOG(pg_proc) BOOTSTRAP
55 text prosrc; /* VARIABLE LENGTH FIELD */
56 bytea probin; /* VARIABLE LENGTH FIELD */
60 * Form_pg_proc corresponds to a pointer to a tuple with
61 * the format of pg_proc relation.
64 typedef FormData_pg_proc *Form_pg_proc;
67 * compiler constants for pg_proc
70 #define Natts_pg_proc 16
71 #define Anum_pg_proc_proname 1
72 #define Anum_pg_proc_proowner 2
73 #define Anum_pg_proc_prolang 3
74 #define Anum_pg_proc_proisinh 4
75 #define Anum_pg_proc_proistrusted 5
76 #define Anum_pg_proc_proiscachable 6
77 #define Anum_pg_proc_pronargs 7
78 #define Anum_pg_proc_proretset 8
79 #define Anum_pg_proc_prorettype 9
80 #define Anum_pg_proc_proargtypes 10
81 #define Anum_pg_proc_probyte_pct 11
82 #define Anum_pg_proc_properbyte_cpu 12
83 #define Anum_pg_proc_propercall_cpu 13
84 #define Anum_pg_proc_prooutin_ratio 14
85 #define Anum_pg_proc_prosrc 15
86 #define Anum_pg_proc_probin 16
89 * initial contents of pg_proc
93 /* keep the following ordered by OID so that later changes can be made easier */
97 DATA(insert OID = 1242 ( boolin PGUID 11 f t f 1 f 16 "0" 100 0 0 100 boolin - ));
99 DATA(insert OID = 1243 ( boolout PGUID 11 f t f 1 f 23 "0" 100 0 0 100 boolout - ));
101 DATA(insert OID = 1244 ( byteain PGUID 11 f t f 1 f 17 "0" 100 0 0 100 byteain - ));
103 DATA(insert OID = 31 ( byteaout PGUID 11 f t f 1 f 23 "0" 100 0 0 100 byteaout - ));
105 DATA(insert OID = 1245 ( charin PGUID 11 f t f 1 f 18 "0" 100 0 0 100 charin - ));
107 DATA(insert OID = 33 ( charout PGUID 11 f t f 1 f 23 "0" 100 0 0 100 charout - ));
109 DATA(insert OID = 34 ( namein PGUID 11 f t f 1 f 19 "0" 100 0 0 100 namein - ));
111 DATA(insert OID = 35 ( nameout PGUID 11 f t f 1 f 23 "0" 100 0 0 100 nameout - ));
113 DATA(insert OID = 38 ( int2in PGUID 11 f t f 1 f 21 "0" 100 0 0 100 int2in - ));
115 DATA(insert OID = 39 ( int2out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 int2out - ));
117 DATA(insert OID = 40 ( int28in PGUID 11 f t f 1 f 22 "0" 100 0 0 100 int28in - ));
119 DATA(insert OID = 41 ( int28out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 int28out - ));
121 DATA(insert OID = 42 ( int4in PGUID 11 f t f 1 f 23 "0" 100 0 0 100 int4in - ));
123 DATA(insert OID = 43 ( int4out PGUID 11 f t f 1 f 19 "0" 100 0 0 100 int4out - ));
125 DATA(insert OID = 44 ( regprocin PGUID 11 f t f 1 f 24 "0" 100 0 0 100 regprocin - ));
127 DATA(insert OID = 45 ( regprocout PGUID 11 f t f 1 f 23 "0" 100 0 0 100 regprocout - ));
129 DATA(insert OID = 46 ( textin PGUID 11 f t f 1 f 25 "0" 100 0 0 100 textin - ));
131 DATA(insert OID = 47 ( textout PGUID 11 f t f 1 f 23 "0" 100 0 0 100 textout - ));
133 DATA(insert OID = 48 ( tidin PGUID 11 f t f 1 f 27 "0" 100 0 0 100 tidin - ));
135 DATA(insert OID = 49 ( tidout PGUID 11 f t f 1 f 23 "0" 100 0 0 100 tidout - ));
137 DATA(insert OID = 50 ( xidin PGUID 11 f t f 1 f 28 "0" 100 0 0 100 xidin - ));
139 DATA(insert OID = 51 ( xidout PGUID 11 f t f 1 f 23 "0" 100 0 0 100 xidout - ));
141 DATA(insert OID = 52 ( cidin PGUID 11 f t f 1 f 29 "0" 100 0 0 100 cidin - ));
143 DATA(insert OID = 53 ( cidout PGUID 11 f t f 1 f 23 "0" 100 0 0 100 cidout - ));
145 DATA(insert OID = 54 ( oid8in PGUID 11 f t f 1 f 30 "0" 100 0 0 100 oid8in - ));
147 DATA(insert OID = 55 ( oid8out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 oid8out - ));
149 DATA(insert OID = 56 ( boollt PGUID 11 f t f 2 f 16 "16 16" 100 0 0 100 boollt - ));
151 DATA(insert OID = 57 ( boolgt PGUID 11 f t f 2 f 16 "16 16" 100 0 0 100 boolgt - ));
152 DESCR("greater-than");
153 DATA(insert OID = 60 ( booleq PGUID 11 f t f 2 f 16 "16 16" 100 0 0 100 booleq - ));
155 DATA(insert OID = 61 ( chareq PGUID 11 f t f 2 f 16 "18 18" 100 0 0 100 chareq - ));
157 DATA(insert OID = 62 ( nameeq PGUID 11 f t f 2 f 16 "19 19" 100 0 0 100 nameeq - ));
159 DATA(insert OID = 63 ( int2eq PGUID 11 f t f 2 f 16 "21 21" 100 0 0 100 int2eq - ));
161 DATA(insert OID = 64 ( int2lt PGUID 11 f t f 2 f 16 "21 21" 100 0 0 100 int2lt - ));
163 DATA(insert OID = 65 ( int4eq PGUID 11 f t f 2 f 16 "23 23" 100 0 0 100 int4eq - ));
165 DATA(insert OID = 66 ( int4lt PGUID 11 f t f 2 f 16 "23 23" 100 0 0 100 int4lt - ));
167 DATA(insert OID = 67 ( texteq PGUID 11 f t f 2 f 16 "25 25" 100 0 0 0 texteq - ));
169 DATA(insert OID = 68 ( xideq PGUID 11 f t f 2 f 16 "28 28" 100 0 0 100 xideq - ));
171 DATA(insert OID = 69 ( cideq PGUID 11 f t f 2 f 16 "29 29" 100 0 0 100 cideq - ));
173 DATA(insert OID = 70 ( charne PGUID 11 f t f 2 f 16 "18 18" 100 0 0 100 charne - ));
175 DATA(insert OID = 1246 ( charlt PGUID 11 f t f 2 f 16 "18 18" 100 0 0 100 charlt - ));
177 DATA(insert OID = 72 ( charle PGUID 11 f t f 2 f 16 "18 18" 100 0 0 100 charle - ));
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 chargt - ));
180 DESCR("greater-than");
181 DATA(insert OID = 74 ( charge PGUID 11 f t f 2 f 16 "18 18" 100 0 0 100 charge - ));
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 charpl - ));
185 DATA(insert OID = 1250 ( charmi PGUID 11 f t f 2 f 18 "18 18" 100 0 0 100 charmi - ));
187 DATA(insert OID = 77 ( charmul PGUID 11 f t f 2 f 18 "18 18" 100 0 0 100 charmul - ));
189 DATA(insert OID = 78 ( chardiv PGUID 11 f t f 2 f 18 "18 18" 100 0 0 100 chardiv - ));
192 DATA(insert OID = 79 ( nameregexeq PGUID 11 f t f 2 f 16 "19 25" 100 0 0 100 nameregexeq - ));
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 nameregexne - ));
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 textregexeq - ));
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 textregexne - ));
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 textlen - ));
202 DATA(insert OID = 1258 ( textcat PGUID 11 f t f 2 f 25 "25 25" 100 0 1 0 textcat - ));
203 DESCR("concatenate");
204 DATA(insert OID = 1377 ( textoctetlen PGUID 11 f t f 1 f 23 "25" 100 0 1 0 textoctetlen - ));
205 DESCR("octet length");
207 DATA(insert OID = 84 ( boolne PGUID 11 f t f 2 f 16 "16 16" 100 0 0 100 boolne - ));
209 DATA(insert OID = 89 ( version PGUID 11 f t t 0 f 25 "" 100 0 0 100 version - ));
210 DESCR("PostgreSQL version string");
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 rtsel - ));
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 rtnpage - ));
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 btreesel - ));
217 DESCR("btree selectivity");
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 btreenpage - ));
223 DATA(insert OID = 1272 ( eqsel PGUID 11 f t f 5 f 701 "26 26 21 0 23" 100 0 0 100 eqsel - ));
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 neqsel - ));
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 intltsel - ));
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 intgtsel - ));
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 eqjoinsel - ));
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 neqjoinsel - ));
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 intltjoinsel - ));
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 intgtjoinsel - ));
238 DESCR("selectivity");
240 DATA(insert OID = 112 ( int4_text PGUID 11 f t f 1 f 25 "23" 100 0 0 100 int4_text - ));
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 int2_text - ));
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 oid_text - ));
245 DESCR("convert oid to text");
247 DATA(insert OID = 115 ( box_above PGUID 11 f t f 2 f 16 "603 603" 100 1 0 100 box_above - ));
249 DATA(insert OID = 116 ( box_below PGUID 11 f t f 2 f 16 "603 603" 100 1 0 100 box_below - ));
252 DATA(insert OID = 117 ( point_in PGUID 11 f t f 1 f 600 "0" 100 0 0 100 point_in - ));
254 DATA(insert OID = 118 ( point_out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 point_out - ));
256 DATA(insert OID = 119 ( lseg_in PGUID 11 f t f 1 f 601 "0" 100 0 0 100 lseg_in - ));
258 DATA(insert OID = 120 ( lseg_out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 lseg_out - ));
260 DATA(insert OID = 121 ( path_in PGUID 11 f t f 1 f 602 "0" 100 0 0 100 path_in - ));
262 DATA(insert OID = 122 ( path_out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 path_out - ));
264 DATA(insert OID = 123 ( box_in PGUID 11 f t f 1 f 603 "0" 100 0 0 100 box_in - ));
266 DATA(insert OID = 124 ( box_out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 box_out - ));
268 DATA(insert OID = 125 ( box_overlap PGUID 11 f t f 2 f 16 "603 603" 100 1 0 100 box_overlap - ));
270 DATA(insert OID = 126 ( box_ge PGUID 11 f t f 2 f 16 "603 603" 100 1 0 100 box_ge - ));
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 box_gt - ));
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 box_eq - ));
276 DATA(insert OID = 129 ( box_lt PGUID 11 f t f 2 f 16 "603 603" 100 1 0 100 box_lt - ));
278 DATA(insert OID = 130 ( box_le PGUID 11 f t f 2 f 16 "603 603" 100 1 0 100 box_le - ));
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 point_above - ));
282 DATA(insert OID = 132 ( point_left PGUID 11 f t f 2 f 16 "600 600" 100 0 0 100 point_left - ));
284 DATA(insert OID = 133 ( point_right PGUID 11 f t f 2 f 16 "600 600" 100 0 0 100 point_right - ));
286 DATA(insert OID = 134 ( point_below PGUID 11 f t f 2 f 16 "600 600" 100 0 0 100 point_below - ));
288 DATA(insert OID = 135 ( point_eq PGUID 11 f t f 2 f 16 "600 600" 100 0 0 100 point_eq - ));
290 DATA(insert OID = 136 ( on_pb PGUID 11 f t f 2 f 16 "600 603" 100 0 0 100 on_pb - ));
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 on_ppath - ));
293 DESCR("contained in");
294 DATA(insert OID = 138 ( box_center PGUID 11 f t f 1 f 600 "603" 100 1 0 100 box_center - ));
296 DATA(insert OID = 139 ( areasel PGUID 11 f t f 5 f 701 "26 26 21 0 23" 100 0 0 100 areasel - ));
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 areajoinsel - ));
299 DESCR("selectivity");
300 DATA(insert OID = 141 ( int4mul PGUID 11 f t f 2 f 23 "23 23" 100 0 0 100 int4mul - ));
302 DATA(insert OID = 142 ( int4fac PGUID 11 f t f 1 f 23 "23" 100 0 0 100 int4fac - ));
304 DATA(insert OID = 143 ( pointdist PGUID 11 f t f 2 f 23 "600 600" 100 0 0 100 pointdist - ));
306 DATA(insert OID = 144 ( int4ne PGUID 11 f t f 2 f 16 "23 23" 100 0 0 100 int4ne - ));
308 DATA(insert OID = 145 ( int2ne PGUID 11 f t f 2 f 16 "21 21" 100 0 0 100 int2ne - ));
310 DATA(insert OID = 146 ( int2gt PGUID 11 f t f 2 f 16 "21 21" 100 0 0 100 int2gt - ));
311 DESCR("greater-than");
312 DATA(insert OID = 147 ( int4gt PGUID 11 f t f 2 f 16 "23 23" 100 0 0 100 int4gt - ));
313 DESCR("greater-than");
314 DATA(insert OID = 148 ( int2le PGUID 11 f t f 2 f 16 "21 21" 100 0 0 100 int2le - ));
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 int4le - ));
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 int4ge - ));
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 int2ge - ));
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 int2mul - ));
324 DATA(insert OID = 153 ( int2div PGUID 11 f t f 2 f 21 "21 21" 100 0 0 100 int2div - ));
326 DATA(insert OID = 154 ( int4div PGUID 11 f t f 2 f 23 "23 23" 100 0 0 100 int4div - ));
328 DATA(insert OID = 155 ( int2mod PGUID 11 f t f 2 f 21 "21 21" 100 0 0 100 int2mod - ));
330 DATA(insert OID = 156 ( int4mod PGUID 11 f t f 2 f 23 "23 23" 100 0 0 100 int4mod - ));
332 DATA(insert OID = 157 ( textne PGUID 11 f t f 2 f 16 "25 25" 100 0 0 0 textne - ));
334 DATA(insert OID = 158 ( int24eq PGUID 11 f t f 2 f 16 "21 23" 100 0 0 100 int24eq - ));
336 DATA(insert OID = 159 ( int42eq PGUID 11 f t f 2 f 16 "23 21" 100 0 0 100 int42eq - ));
338 DATA(insert OID = 160 ( int24lt PGUID 11 f t f 2 f 16 "21 23" 100 0 0 100 int24lt - ));
340 DATA(insert OID = 161 ( int42lt PGUID 11 f t f 2 f 16 "23 21" 100 0 0 100 int42lt - ));
342 DATA(insert OID = 162 ( int24gt PGUID 11 f t f 2 f 16 "21 23" 100 0 0 100 int24gt - ));
343 DESCR("greater-than");
344 DATA(insert OID = 163 ( int42gt PGUID 11 f t f 2 f 16 "23 21" 100 0 0 100 int42gt - ));
345 DESCR("greater-than");
346 DATA(insert OID = 164 ( int24ne PGUID 11 f t f 2 f 16 "21 23" 100 0 0 100 int24ne - ));
348 DATA(insert OID = 165 ( int42ne PGUID 11 f t f 2 f 16 "23 21" 100 0 0 100 int42ne - ));
350 DATA(insert OID = 166 ( int24le PGUID 11 f t f 2 f 16 "21 23" 100 0 0 100 int24le - ));
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 int42le - ));
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 int24ge - ));
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 int42ge - ));
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 int24mul - ));
360 DATA(insert OID = 171 ( int42mul PGUID 11 f t f 2 f 23 "23 21" 100 0 0 100 int42mul - ));
362 DATA(insert OID = 172 ( int24div PGUID 11 f t f 2 f 23 "21 23" 100 0 0 100 int24div - ));
364 DATA(insert OID = 173 ( int42div PGUID 11 f t f 2 f 23 "23 21" 100 0 0 100 int42div - ));
366 DATA(insert OID = 174 ( int24mod PGUID 11 f t f 2 f 23 "21 23" 100 0 0 100 int24mod - ));
368 DATA(insert OID = 175 ( int42mod PGUID 11 f t f 2 f 23 "23 21" 100 0 0 100 int42mod - ));
370 DATA(insert OID = 176 ( int2pl PGUID 11 f t f 2 f 21 "21 21" 100 0 0 100 int2pl - ));
372 DATA(insert OID = 177 ( int4pl PGUID 11 f t f 2 f 23 "23 23" 100 0 0 100 int4pl - ));
374 DATA(insert OID = 178 ( int24pl PGUID 11 f t f 2 f 23 "21 23" 100 0 0 100 int24pl - ));
376 DATA(insert OID = 179 ( int42pl PGUID 11 f t f 2 f 23 "23 21" 100 0 0 100 int42pl - ));
378 DATA(insert OID = 180 ( int2mi PGUID 11 f t f 2 f 21 "21 21" 100 0 0 100 int2mi - ));
380 DATA(insert OID = 181 ( int4mi PGUID 11 f t f 2 f 23 "23 23" 100 0 0 100 int4mi - ));
382 DATA(insert OID = 182 ( int24mi PGUID 11 f t f 2 f 23 "21 23" 100 0 0 100 int24mi - ));
384 DATA(insert OID = 183 ( int42mi PGUID 11 f t f 2 f 23 "23 21" 100 0 0 100 int42mi - ));
386 DATA(insert OID = 184 ( oideq PGUID 11 f t f 2 f 16 "26 26" 100 0 0 100 oideq - ));
388 DATA(insert OID = 185 ( oidne PGUID 11 f t f 2 f 16 "26 26" 100 0 0 100 oidne - ));
390 DATA(insert OID = 186 ( box_same PGUID 11 f t f 2 f 16 "603 603" 100 0 0 100 box_same - ));
392 DATA(insert OID = 187 ( box_contain PGUID 11 f t f 2 f 16 "603 603" 100 0 0 100 box_contain - ));
394 DATA(insert OID = 188 ( box_left PGUID 11 f t f 2 f 16 "603 603" 100 0 0 100 box_left - ));
396 DATA(insert OID = 189 ( box_overleft PGUID 11 f t f 2 f 16 "603 603" 100 0 0 100 box_overleft - ));
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 box_overright - ));
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 box_right - ));
402 DATA(insert OID = 192 ( box_contained PGUID 11 f t f 2 f 16 "603 603" 100 0 0 100 box_contained - ));
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 rt_box_union - ));
406 DATA(insert OID = 194 ( rt_box_inter PGUID 11 f t f 2 f 603 "603 603" 100 0 0 100 rt_box_inter - ));
408 DATA(insert OID = 195 ( rt_box_size PGUID 11 f t f 2 f 700 "603 700" 100 0 0 100 rt_box_size - ));
410 DATA(insert OID = 196 ( rt_bigbox_size PGUID 11 f t f 2 f 700 "603 700" 100 0 0 100 rt_bigbox_size - ));
412 DATA(insert OID = 197 ( rt_poly_union PGUID 11 f t f 2 f 604 "604 604" 100 0 0 100 rt_poly_union - ));
414 DATA(insert OID = 198 ( rt_poly_inter PGUID 11 f t f 2 f 604 "604 604" 100 0 0 100 rt_poly_inter - ));
416 DATA(insert OID = 199 ( rt_poly_size PGUID 11 f t f 2 f 23 "604 23" 100 0 0 100 rt_poly_size - ));
421 DATA(insert OID = 200 ( float4in PGUID 11 f t f 1 f 700 "0" 100 0 0 100 float4in - ));
423 DATA(insert OID = 201 ( float4out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 float4out - ));
425 DATA(insert OID = 202 ( float4mul PGUID 11 f t f 2 f 700 "700 700" 100 0 0 100 float4mul - ));
427 DATA(insert OID = 203 ( float4div PGUID 11 f t f 2 f 700 "700 700" 100 0 0 100 float4div - ));
429 DATA(insert OID = 204 ( float4pl PGUID 11 f t f 2 f 700 "700 700" 100 0 0 100 float4pl - ));
431 DATA(insert OID = 205 ( float4mi PGUID 11 f t f 2 f 700 "700 700" 100 0 0 100 float4mi - ));
433 DATA(insert OID = 206 ( float4um PGUID 11 f t f 1 f 700 "700" 100 0 0 100 float4um - ));
435 DATA(insert OID = 207 ( float4abs PGUID 11 f t f 1 f 700 "700 700" 100 0 0 100 float4abs - ));
436 DESCR("absolute value");
437 DATA(insert OID = 208 ( float4inc PGUID 11 f t f 1 f 700 "700" 100 0 0 100 float4inc - ));
439 DATA(insert OID = 209 ( float4larger PGUID 11 f t f 2 f 700 "700 700" 100 0 0 100 float4larger - ));
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 float4smaller - ));
442 DESCR("smaller of two");
444 DATA(insert OID = 212 ( int4um PGUID 11 f t f 1 f 23 "23" 100 0 0 100 int4um - ));
446 DATA(insert OID = 213 ( int2um PGUID 11 f t f 1 f 21 "21" 100 0 0 100 int2um - ));
449 DATA(insert OID = 214 ( float8in PGUID 11 f t f 1 f 701 "0" 100 0 0 100 float8in - ));
451 DATA(insert OID = 215 ( float8out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 float8out - ));
453 DATA(insert OID = 216 ( float8mul PGUID 11 f t f 2 f 701 "701 701" 100 0 0 100 float8mul - ));
455 DATA(insert OID = 217 ( float8div PGUID 11 f t f 2 f 701 "701 701" 100 0 0 100 float8div - ));
457 DATA(insert OID = 218 ( float8pl PGUID 11 f t f 2 f 701 "701 701" 100 0 0 100 float8pl - ));
459 DATA(insert OID = 219 ( float8mi PGUID 11 f t f 2 f 701 "701 701" 100 0 0 100 float8mi - ));
461 DATA(insert OID = 220 ( float8um PGUID 11 f t f 1 f 701 "701" 100 0 0 100 float8um - ));
463 DATA(insert OID = 221 ( float8abs PGUID 11 f t f 1 f 701 "701" 100 0 0 100 float8abs - ));
464 DESCR("absolute value");
465 DATA(insert OID = 222 ( float8inc PGUID 11 f t f 1 f 701 "701" 100 0 0 100 float8inc - ));
467 DATA(insert OID = 223 ( float8larger PGUID 11 f t f 2 f 701 "701 701" 100 0 0 100 float8larger - ));
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 float8smaller - ));
470 DESCR("smaller of two");
472 DATA(insert OID = 225 ( lseg_center PGUID 11 f t f 1 f 600 "601" 100 0 0 100 lseg_center - ));
474 DATA(insert OID = 226 ( path_center PGUID 11 f t f 1 f 600 "602" 100 0 0 100 path_center - ));
476 DATA(insert OID = 227 ( poly_center PGUID 11 f t f 1 f 600 "604" 100 0 0 100 poly_center - ));
479 DATA(insert OID = 228 ( dround PGUID 11 f t f 1 f 701 "701" 100 0 0 100 dround - ));
480 DESCR("truncate to integer");
481 DATA(insert OID = 229 ( dtrunc PGUID 11 f t f 1 f 701 "701" 100 0 0 100 dtrunc - ));
482 DESCR("truncate to integer");
483 DATA(insert OID = 230 ( dsqrt PGUID 11 f t f 1 f 701 "701" 100 0 0 100 dsqrt - ));
484 DESCR("square root");
485 DATA(insert OID = 231 ( dcbrt PGUID 11 f t f 1 f 701 "701" 100 0 0 100 dcbrt - ));
487 DATA(insert OID = 232 ( dpow PGUID 11 f t f 2 f 701 "701 701" 100 0 0 100 dpow - ));
488 DESCR("exponentiation");
489 DATA(insert OID = 233 ( dexp PGUID 11 f t f 1 f 701 "701" 100 0 0 100 dexp - ));
490 DESCR("exponential");
491 DATA(insert OID = 234 ( dlog1 PGUID 11 f t f 1 f 701 "701" 100 0 0 100 dlog1 - ));
492 DESCR("natural logarithm (in psql, protect with ()");
494 DATA(insert OID = 235 ( i2tod PGUID 11 f t f 1 f 701 "21" 100 0 0 100 i2tod - ));
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 i2tof - ));
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 dtoi2 - ));
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 ftoi2 - ));
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 line_distance - ));
503 DESCR("distance between");
505 DATA(insert OID = 240 ( nabstimein PGUID 11 f t f 1 f 702 "0" 100 0 0 100 nabstimein - ));
507 DATA(insert OID = 241 ( nabstimeout PGUID 11 f t f 1 f 23 "0" 100 0 0 100 nabstimeout - ));
509 DATA(insert OID = 242 ( reltimein PGUID 11 f t f 1 f 703 "0" 100 0 0 100 reltimein - ));
511 DATA(insert OID = 243 ( reltimeout PGUID 11 f t f 1 f 23 "0" 100 0 0 100 reltimeout - ));
513 DATA(insert OID = 244 ( timepl PGUID 11 f t f 2 f 702 "702 703" 100 0 0 100 timepl - ));
515 DATA(insert OID = 245 ( timemi PGUID 11 f t f 2 f 702 "702 703" 100 0 0 100 timemi - ));
517 DATA(insert OID = 246 ( tintervalin PGUID 11 f t f 1 f 704 "0" 100 0 0 100 tintervalin - ));
519 DATA(insert OID = 247 ( tintervalout PGUID 11 f t f 1 f 23 "0" 100 0 0 100 tintervalout - ));
521 DATA(insert OID = 248 ( ininterval PGUID 11 f t f 2 f 16 "702 704" 100 0 0 100 ininterval - ));
522 DESCR("abstime in tinterval");
523 DATA(insert OID = 249 ( intervalrel PGUID 11 f t f 1 f 703 "704" 100 0 0 100 intervalrel - ));
525 DATA(insert OID = 250 ( timenow PGUID 11 f t f 0 f 702 "0" 100 0 0 100 timenow - ));
527 DATA(insert OID = 251 ( abstimeeq PGUID 11 f t f 2 f 16 "702 702" 100 0 0 100 abstimeeq - ));
529 DATA(insert OID = 252 ( abstimene PGUID 11 f t f 2 f 16 "702 702" 100 0 0 100 abstimene - ));
531 DATA(insert OID = 253 ( abstimelt PGUID 11 f t f 2 f 16 "702 702" 100 0 0 100 abstimelt - ));
533 DATA(insert OID = 254 ( abstimegt PGUID 11 f t f 2 f 16 "702 702" 100 0 0 100 abstimegt - ));
534 DESCR("greater-than");
535 DATA(insert OID = 255 ( abstimele PGUID 11 f t f 2 f 16 "702 702" 100 0 0 100 abstimele - ));
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 abstimege - ));
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 reltimeeq - ));
541 DATA(insert OID = 258 ( reltimene PGUID 11 f t f 2 f 16 "703 703" 100 0 0 100 reltimene - ));
543 DATA(insert OID = 259 ( reltimelt PGUID 11 f t f 2 f 16 "703 703" 100 0 0 100 reltimelt - ));
545 DATA(insert OID = 260 ( reltimegt PGUID 11 f t f 2 f 16 "703 703" 100 0 0 100 reltimegt - ));
546 DESCR("greater-than");
547 DATA(insert OID = 261 ( reltimele PGUID 11 f t f 2 f 16 "703 703" 100 0 0 100 reltimele - ));
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 reltimege - ));
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 intervalsame - ));
553 DATA(insert OID = 264 ( intervalct PGUID 11 f t f 2 f 16 "704 704" 100 0 0 100 intervalct - ));
555 DATA(insert OID = 265 ( intervalov PGUID 11 f t f 2 f 16 "704 704" 100 0 0 100 intervalov - ));
557 DATA(insert OID = 266 ( intervalleneq PGUID 11 f t f 2 f 16 "704 703" 100 0 0 100 intervalleneq - ));
558 DESCR("length equal");
559 DATA(insert OID = 267 ( intervallenne PGUID 11 f t f 2 f 16 "704 703" 100 0 0 100 intervallenne - ));
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 intervallenlt - ));
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 intervallengt - ));
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 intervallenle - ));
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 intervallenge - ));
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 intervalstart - ));
570 DESCR("start of interval");
571 DATA(insert OID = 273 ( intervalend PGUID 11 f t f 1 f 702 "704" 100 0 0 100 intervalend - ));
573 DATA(insert OID = 274 ( timeofday PGUID 11 f t f 0 f 25 "0" 100 0 0 100 timeofday - ));
575 DATA(insert OID = 275 ( abstime_finite PGUID 11 f t f 1 f 16 "702" 100 0 0 100 abstime_finite - ));
578 DATA(insert OID = 276 ( int2fac PGUID 11 f t f 1 f 21 "21" 100 0 0 100 int2fac - ));
581 DATA(insert OID = 277 ( inter_sl PGUID 11 f t f 2 f 16 "601 628" 100 0 0 100 inter_sl - ));
583 DATA(insert OID = 278 ( inter_lb PGUID 11 f t f 2 f 16 "628 603" 100 0 0 100 inter_lb - ));
586 DATA(insert OID = 279 ( float48mul PGUID 11 f t f 2 f 701 "700 701" 100 0 0 100 float48mul - ));
588 DATA(insert OID = 280 ( float48div PGUID 11 f t f 2 f 701 "700 701" 100 0 0 100 float48div - ));
590 DATA(insert OID = 281 ( float48pl PGUID 11 f t f 2 f 701 "700 701" 100 0 0 100 float48pl - ));
592 DATA(insert OID = 282 ( float48mi PGUID 11 f t f 2 f 701 "700 701" 100 0 0 100 float48mi - ));
594 DATA(insert OID = 283 ( float84mul PGUID 11 f t f 2 f 701 "701 700" 100 0 0 100 float84mul - ));
596 DATA(insert OID = 284 ( float84div PGUID 11 f t f 2 f 701 "701 700" 100 0 0 100 float84div - ));
598 DATA(insert OID = 285 ( float84pl PGUID 11 f t f 2 f 701 "701 700" 100 0 0 100 float84pl - ));
600 DATA(insert OID = 286 ( float84mi PGUID 11 f t f 2 f 701 "701 700" 100 0 0 100 float84mi - ));
603 DATA(insert OID = 287 ( float4eq PGUID 11 f t f 2 f 16 "700 700" 100 0 0 100 float4eq - ));
605 DATA(insert OID = 288 ( float4ne PGUID 11 f t f 2 f 16 "700 700" 100 0 0 100 float4ne - ));
607 DATA(insert OID = 289 ( float4lt PGUID 11 f t f 2 f 16 "700 700" 100 0 0 100 float4lt - ));
609 DATA(insert OID = 290 ( float4le PGUID 11 f t f 2 f 16 "700 700" 100 0 0 100 float4le - ));
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 float4gt - ));
612 DESCR("greater-than");
613 DATA(insert OID = 292 ( float4ge PGUID 11 f t f 2 f 16 "700 700" 100 0 0 100 float4ge - ));
614 DESCR("greater-than-or-equal");
616 DATA(insert OID = 293 ( float8eq PGUID 11 f t f 2 f 16 "701 701" 100 0 0 100 float8eq - ));
618 DATA(insert OID = 294 ( float8ne PGUID 11 f t f 2 f 16 "701 701" 100 0 0 100 float8ne - ));
620 DATA(insert OID = 295 ( float8lt PGUID 11 f t f 2 f 16 "701 701" 100 0 0 100 float8lt - ));
622 DATA(insert OID = 296 ( float8le PGUID 11 f t f 2 f 16 "701 701" 100 0 0 100 float8le - ));
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 float8gt - ));
625 DESCR("greater-than");
626 DATA(insert OID = 298 ( float8ge PGUID 11 f t f 2 f 16 "701 701" 100 0 0 100 float8ge - ));
627 DESCR("greater-than-or-equal");
629 DATA(insert OID = 299 ( float48eq PGUID 11 f t f 2 f 16 "700 701" 100 0 0 100 float48eq - ));
634 DATA(insert OID = 300 ( float48ne PGUID 11 f t f 2 f 16 "700 701" 100 0 0 100 float48ne - ));
636 DATA(insert OID = 301 ( float48lt PGUID 11 f t f 2 f 16 "700 701" 100 0 0 100 float48lt - ));
638 DATA(insert OID = 302 ( float48le PGUID 11 f t f 2 f 16 "700 701" 100 0 0 100 float48le - ));
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 float48gt - ));
641 DESCR("greater-than");
642 DATA(insert OID = 304 ( float48ge PGUID 11 f t f 2 f 16 "700 701" 100 0 0 100 float48ge - ));
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 float84eq - ));
646 DATA(insert OID = 306 ( float84ne PGUID 11 f t f 2 f 16 "701 700" 100 0 0 100 float84ne - ));
648 DATA(insert OID = 307 ( float84lt PGUID 11 f t f 2 f 16 "701 700" 100 0 0 100 float84lt - ));
650 DATA(insert OID = 308 ( float84le PGUID 11 f t f 2 f 16 "701 700" 100 0 0 100 float84le - ));
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 float84gt - ));
653 DESCR("greater-than");
654 DATA(insert OID = 310 ( float84ge PGUID 11 f t f 2 f 16 "701 700" 100 0 0 100 float84ge - ));
655 DESCR("greater-than-or-equal");
657 DATA(insert OID = 311 ( ftod PGUID 11 f t f 1 f 701 "700" 100 0 0 100 ftod - ));
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 dtof - ));
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 i2toi4 - ));
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 i4toi2 - ));
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 keyfirsteq - ));
667 DATA(insert OID = 316 ( i4tod PGUID 11 f t f 1 f 701 "23" 100 0 0 100 i4tod - ));
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 dtoi4 - ));
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 i4tof - ));
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 ftoi4 - ));
674 DESCR("convert float4 to int4");
676 DATA(insert OID = 320 ( rtinsert PGUID 11 f t f 5 f 23 "0" 100 0 0 100 rtinsert - ));
677 DESCR("r-tree(internal)");
678 DATA(insert OID = 321 ( rtdelete PGUID 11 f t f 2 f 23 "0" 100 0 0 100 rtdelete - ));
679 DESCR("r-tree(internal)");
680 DATA(insert OID = 322 ( rtgettuple PGUID 11 f t f 2 f 23 "0" 100 0 0 100 rtgettuple - ));
681 DESCR("r-tree(internal)");
682 DATA(insert OID = 323 ( rtbuild PGUID 11 f t f 9 f 23 "0" 100 0 0 100 rtbuild - ));
683 DESCR("r-tree(internal)");
684 DATA(insert OID = 324 ( rtbeginscan PGUID 11 f t f 4 f 23 "0" 100 0 0 100 rtbeginscan - ));
685 DESCR("r-tree(internal)");
686 DATA(insert OID = 325 ( rtendscan PGUID 11 f t f 1 f 23 "0" 100 0 0 100 rtendscan - ));
687 DESCR("r-tree(internal)");
688 DATA(insert OID = 326 ( rtmarkpos PGUID 11 f t f 1 f 23 "0" 100 0 0 100 rtmarkpos - ));
689 DESCR("r-tree(internal)");
690 DATA(insert OID = 327 ( rtrestrpos PGUID 11 f t f 1 f 23 "0" 100 0 0 100 rtrestrpos - ));
691 DESCR("r-tree(internal)");
692 DATA(insert OID = 328 ( rtrescan PGUID 11 f t f 3 f 23 "0" 100 0 0 100 rtrescan - ));
693 DESCR("r-tree(internal)");
695 DATA(insert OID = 330 ( btgettuple PGUID 11 f t f 2 f 23 "0" 100 0 0 100 btgettuple - ));
696 DESCR("btree(internal)");
697 DATA(insert OID = 331 ( btinsert PGUID 11 f t f 5 f 23 "0" 100 0 0 100 btinsert - ));
698 DESCR("btree(internal)");
699 DATA(insert OID = 332 ( btdelete PGUID 11 f t f 2 f 23 "0" 100 0 0 100 btdelete - ));
700 DESCR("btree(internal)");
701 DATA(insert OID = 333 ( btbeginscan PGUID 11 f t f 4 f 23 "0" 100 0 0 100 btbeginscan - ));
702 DESCR("btree(internal)");
703 DATA(insert OID = 334 ( btrescan PGUID 11 f t f 3 f 23 "0" 100 0 0 100 btrescan - ));
704 DESCR("btree(internal)");
705 DATA(insert OID = 335 ( btendscan PGUID 11 f t f 1 f 23 "0" 100 0 0 100 btendscan - ));
706 DESCR("btree(internal)");
707 DATA(insert OID = 336 ( btmarkpos PGUID 11 f t f 1 f 23 "0" 100 0 0 100 btmarkpos - ));
708 DESCR("btree(internal)");
709 DATA(insert OID = 337 ( btrestrpos PGUID 11 f t f 1 f 23 "0" 100 0 0 100 btrestrpos - ));
710 DESCR("btree(internal)");
711 DATA(insert OID = 338 ( btbuild PGUID 11 f t f 9 f 23 "0" 100 0 0 100 btbuild - ));
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 poly_same - ));
715 DATA(insert OID = 340 ( poly_contain PGUID 11 f t f 2 f 16 "604 604" 100 0 1 0 poly_contain - ));
717 DATA(insert OID = 341 ( poly_left PGUID 11 f t f 2 f 16 "604 604" 100 0 1 0 poly_left - ));
719 DATA(insert OID = 342 ( poly_overleft PGUID 11 f t f 2 f 16 "604 604" 100 0 1 0 poly_overleft - ));
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 poly_overright - ));
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 poly_right - ));
725 DATA(insert OID = 345 ( poly_contained PGUID 11 f t f 2 f 16 "604 604" 100 0 1 0 poly_contained - ));
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 poly_overlap - ));
729 DATA(insert OID = 347 ( poly_in PGUID 11 f t f 1 f 604 "0" 100 0 1 0 poly_in - ));
731 DATA(insert OID = 348 ( poly_out PGUID 11 f t f 1 f 23 "0" 100 0 1 0 poly_out - ));
734 DATA(insert OID = 350 ( btint2cmp PGUID 11 f t f 2 f 23 "21 21" 100 0 0 100 btint2cmp - ));
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 btint4cmp - ));
737 DESCR("btree less-equal-greater");
738 DATA(insert OID = 842 ( btint8cmp PGUID 11 f t f 2 f 23 "20 20" 100 0 0 100 btint8cmp - ));
739 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 btint42cmp - ));
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 btint24cmp - ));
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 btfloat4cmp - ));
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 btfloat8cmp - ));
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 btoidcmp - ));
749 DESCR("btree less-equal-greater");
750 DATA(insert OID = 404 ( btoid8cmp PGUID 11 f t f 2 f 23 "30 30" 100 0 0 100 btoid8cmp - ));
751 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 btabstimecmp - ));
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 btcharcmp - ));
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 btnamecmp - ));
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 bttextcmp - ));
759 DESCR("btree less-equal-greater");
761 DATA(insert OID = 361 ( lseg_distance PGUID 11 f t f 2 f 701 "601 601" 100 0 0 100 lseg_distance - ));
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 lseg_interpt - ));
765 DATA(insert OID = 363 ( dist_ps PGUID 11 f t f 2 f 701 "600 601" 100 0 0 100 dist_ps - ));
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 dist_pb - ));
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 dist_sb - ));
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 close_ps - ));
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 close_pb - ));
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 close_sb - ));
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 on_ps - ));
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 path_distance - ));
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 dist_ppath - ));
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 on_sb - ));
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 inter_sb - ));
790 DATA(insert OID = 406 ( name_text PGUID 11 f t f 1 f 25 "19" 100 0 0 100 name_text - ));
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 text_name - ));
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 name_bpchar - ));
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 bpchar_name - ));
797 DESCR("convert char() to name");
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 hashsel - ));
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 hashnpage - ));
804 DATA(insert OID = 440 ( hashgettuple PGUID 11 f t f 2 f 23 "0" 100 0 0 100 hashgettuple - ));
805 DESCR("hash(internal)");
806 DATA(insert OID = 441 ( hashinsert PGUID 11 f t f 5 f 23 "0" 100 0 0 100 hashinsert - ));
807 DESCR("hash(internal)");
808 DATA(insert OID = 442 ( hashdelete PGUID 11 f t f 2 f 23 "0" 100 0 0 100 hashdelete - ));
809 DESCR("hash(internal)");
810 DATA(insert OID = 443 ( hashbeginscan PGUID 11 f t f 4 f 23 "0" 100 0 0 100 hashbeginscan - ));
811 DESCR("hash(internal)");
812 DATA(insert OID = 444 ( hashrescan PGUID 11 f t f 3 f 23 "0" 100 0 0 100 hashrescan - ));
813 DESCR("hash(internal)");
814 DATA(insert OID = 445 ( hashendscan PGUID 11 f t f 1 f 23 "0" 100 0 0 100 hashendscan - ));
815 DESCR("hash(internal)");
816 DATA(insert OID = 446 ( hashmarkpos PGUID 11 f t f 1 f 23 "0" 100 0 0 100 hashmarkpos - ));
817 DESCR("hash(internal)");
818 DATA(insert OID = 447 ( hashrestrpos PGUID 11 f t f 1 f 23 "0" 100 0 0 100 hashrestrpos - ));
819 DESCR("hash(internal)");
820 DATA(insert OID = 448 ( hashbuild PGUID 11 f t f 9 f 23 "0" 100 0 0 100 hashbuild - ));
821 DESCR("hash(internal)");
822 DATA(insert OID = 449 ( hashint2 PGUID 11 f t f 1 f 23 "21" 100 0 0 100 hashint2 - ));
824 DATA(insert OID = 450 ( hashint4 PGUID 11 f t f 1 f 23 "23" 100 0 0 100 hashint4 - ));
826 DATA(insert OID = 949 ( hashint8 PGUID 11 f t f 1 f 23 "20" 100 0 0 100 hashint8 - ));
828 DATA(insert OID = 451 ( hashfloat4 PGUID 11 f t f 1 f 23 "700" 100 0 0 100 hashfloat4 - ));
830 DATA(insert OID = 452 ( hashfloat8 PGUID 11 f t f 1 f 23 "701" 100 0 0 100 hashfloat8 - ));
832 DATA(insert OID = 453 ( hashoid PGUID 11 f t f 1 f 23 "26" 100 0 0 100 hashoid - ));
834 DATA(insert OID = 454 ( hashchar PGUID 11 f t f 1 f 23 "18" 100 0 0 100 hashchar - ));
836 DATA(insert OID = 455 ( hashname PGUID 11 f t f 1 f 23 "19" 100 0 0 100 hashname - ));
838 DATA(insert OID = 456 ( hashtext PGUID 11 f t f 1 f 23 "25" 100 0 0 100 hashtext - ));
840 DATA(insert OID = 457 ( hashoid8 PGUID 11 f t f 1 f 23 "30" 100 0 0 100 hashoid8 - ));
842 DATA(insert OID = 458 ( text_larger PGUID 11 f t f 2 f 25 "25 25" 100 0 0 100 text_larger - ));
843 DESCR("larger of two");
844 DATA(insert OID = 459 ( text_smaller PGUID 11 f t f 2 f 25 "25 25" 100 0 0 100 text_smaller - ));
845 DESCR("smaller of two");
847 DATA(insert OID = 460 ( int8in PGUID 11 f t f 1 f 20 "0" 100 0 0 100 int8in - ));
849 DATA(insert OID = 461 ( int8out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 int8out - ));
851 DATA(insert OID = 462 ( int8um PGUID 11 f t f 1 f 20 "20" 100 0 0 100 int8um - ));
852 DESCR("unary minus");
853 DATA(insert OID = 463 ( int8pl PGUID 11 f t f 2 f 20 "20 20" 100 0 0 100 int8pl - ));
855 DATA(insert OID = 464 ( int8mi PGUID 11 f t f 2 f 20 "20 20" 100 0 0 100 int8mi - ));
856 DESCR("subtraction");
857 DATA(insert OID = 465 ( int8mul PGUID 11 f t f 2 f 20 "20 20" 100 0 0 100 int8mul - ));
859 DATA(insert OID = 466 ( int8div PGUID 11 f t f 2 f 20 "20 20" 100 0 0 100 int8div - ));
861 DATA(insert OID = 467 ( int8eq PGUID 11 f t f 2 f 16 "20 20" 100 0 0 100 int8eq - ));
863 DATA(insert OID = 468 ( int8ne PGUID 11 f t f 2 f 16 "20 20" 100 0 0 100 int8ne - ));
865 DATA(insert OID = 469 ( int8lt PGUID 11 f t f 2 f 16 "20 20" 100 0 0 100 int8lt - ));
867 DATA(insert OID = 470 ( int8gt PGUID 11 f t f 2 f 16 "20 20" 100 0 0 100 int8gt - ));
868 DESCR("greater-than");
869 DATA(insert OID = 471 ( int8le PGUID 11 f t f 2 f 16 "20 20" 100 0 0 100 int8le - ));
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 int8ge - ));
872 DESCR("greater-than-or-equal");
874 DATA(insert OID = 474 ( int84eq PGUID 11 f t f 2 f 16 "20 23" 100 0 0 100 int84eq - ));
876 DATA(insert OID = 475 ( int84ne PGUID 11 f t f 2 f 16 "20 23" 100 0 0 100 int84ne - ));
878 DATA(insert OID = 476 ( int84lt PGUID 11 f t f 2 f 16 "20 23" 100 0 0 100 int84lt - ));
880 DATA(insert OID = 477 ( int84gt PGUID 11 f t f 2 f 16 "20 23" 100 0 0 100 int84gt - ));
881 DESCR("greater-than");
882 DATA(insert OID = 478 ( int84le PGUID 11 f t f 2 f 16 "20 23" 100 0 0 100 int84le - ));
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 int84ge - ));
885 DESCR("greater-than-or-equal");
887 DATA(insert OID = 480 ( int84 PGUID 11 f t f 1 f 23 "20" 100 0 0 100 int84 - ));
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 int48 - ));
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 i8tod - ));
892 DESCR("convert int8 to float8");
893 DATA(insert OID = 483 ( dtoi8 PGUID 11 f t f 1 f 20 "701" 100 0 0 100 dtoi8 - ));
894 DESCR("convert float8 to int8");
900 DATA(insert OID = 1285 ( int4notin PGUID 11 f t f 2 f 16 "23 0" 100 0 0 100 int4notin - ));
902 DATA(insert OID = 1286 ( oidnotin PGUID 11 f t f 2 f 16 "26 0" 100 0 0 100 oidnotin - ));
904 DATA(insert OID = 1287 ( int44in PGUID 11 f t f 1 f 22 "0" 100 0 0 100 int44in - ));
906 DATA(insert OID = 653 ( int44out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 int44out - ));
908 DATA(insert OID = 655 ( namelt PGUID 11 f t f 2 f 16 "19 19" 100 0 0 100 namelt - ));
910 DATA(insert OID = 656 ( namele PGUID 11 f t f 2 f 16 "19 19" 100 0 0 100 namele - ));
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 namegt - ));
913 DESCR("greater-than");
914 DATA(insert OID = 658 ( namege PGUID 11 f t f 2 f 16 "19 19" 100 0 0 100 namege - ));
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 namene - ));
919 DATA(insert OID = 668 ( bpchar PGUID 11 f t f 2 f 1042 "1042 23" 100 0 0 100 bpchar - ));
920 DESCR("truncate char()");
921 DATA(insert OID = 669 ( varchar PGUID 11 f t f 2 f 1043 "1043 23" 100 0 0 100 varchar - ));
922 DESCR("truncate varchar()");
924 DATA(insert OID = 676 ( mktinterval PGUID 11 f t f 2 f 704 "702 702" 100 0 0 100 mktinterval - ));
925 DESCR("convert to interval");
926 DATA(insert OID = 619 ( oid8ne PGUID 11 f t f 2 f 16 "30 30" 100 0 0 100 oid8ne - ));
928 DATA(insert OID = 677 ( oid8lt PGUID 11 f t f 2 f 16 "30 30" 100 0 0 100 oid8lt - ));
930 DATA(insert OID = 678 ( oid8le PGUID 11 f t f 2 f 16 "30 30" 100 0 0 100 oid8le - ));
931 DESCR("less-than-or-equal");
932 DATA(insert OID = 679 ( oid8eq PGUID 11 f t f 2 f 16 "30 30" 100 0 0 100 oid8eq - ));
934 DATA(insert OID = 680 ( oid8ge PGUID 11 f t f 2 f 16 "30 30" 100 0 0 100 oid8ge - ));
935 DESCR("greater-than-or-equal");
936 DATA(insert OID = 681 ( oid8gt PGUID 11 f t f 2 f 16 "30 30" 100 0 0 100 oid8gt - ));
937 DESCR("greater-than");
940 DATA(insert OID = 710 ( getpgusername PGUID 11 f t f 0 f 19 "0" 100 0 0 100 getpgusername - ));
942 DATA(insert OID = 711 ( userfntest PGUID 11 f t f 1 f 23 "23" 100 0 0 100 userfntest - ));
944 DATA(insert OID = 713 ( oidrand PGUID 11 f t f 2 f 16 "26 23" 100 0 0 100 oidrand - ));
946 DATA(insert OID = 715 ( oidsrand PGUID 11 f t f 1 f 16 "23" 100 0 0 100 oidsrand - ));
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 oideqint4 - ));
950 DATA(insert OID = 717 ( int4eqoid PGUID 11 f t f 2 f 16 "23 26" 100 0 0 100 int4eqoid - ));
953 DATA(insert OID = 720 ( byteaGetSize PGUID 11 f t f 1 f 23 "17" 100 0 0 100 byteaGetSize - ));
955 DATA(insert OID = 721 ( byteaGetByte PGUID 11 f t f 2 f 23 "17 23" 100 0 0 100 byteaGetByte - ));
957 DATA(insert OID = 722 ( byteaSetByte PGUID 11 f t f 3 f 17 "17 23 23" 100 0 0 100 byteaSetByte - ));
959 DATA(insert OID = 723 ( byteaGetBit PGUID 11 f t f 2 f 23 "17 23" 100 0 0 100 byteaGetBit - ));
961 DATA(insert OID = 724 ( byteaSetBit PGUID 11 f t f 3 f 17 "17 23 23" 100 0 0 100 byteaSetBit - ));
964 DATA(insert OID = 725 ( dist_pl PGUID 11 f t f 2 f 701 "600 628" 100 0 0 100 dist_pl - ));
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 dist_lb - ));
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 dist_sl - ));
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 dist_cpoly - ));
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 poly_distance - ));
973 DESCR("distance between");
975 DATA(insert OID = 730 ( pqtest PGUID 11 f t f 1 f 23 "25" 100 0 0 100 pqtest - ));
978 DATA(insert OID = 740 ( text_lt PGUID 11 f t f 2 f 16 "25 25" 100 0 0 0 text_lt - ));
980 DATA(insert OID = 741 ( text_le PGUID 11 f t f 2 f 16 "25 25" 100 0 0 0 text_le - ));
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 text_gt - ));
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 text_ge - ));
985 DESCR("greater-than-or-equal");
987 DATA(insert OID = 744 ( array_eq PGUID 11 f t f 2 f 16 "0 0" 100 0 0 100 array_eq -));
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 array_assgn -));
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 array_clip -));
993 DATA(insert OID = 747 ( array_dims PGUID 11 f t f 1 f 25 "0" 100 0 0 100 array_dims -));
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 array_set -));
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 array_ref -));
999 DATA(insert OID = 750 ( array_in PGUID 11 f t f 3 f 23 "0 0 23" 100 0 0 100 array_in - ));
1001 DATA(insert OID = 751 ( array_out PGUID 11 f t f 2 f 23 "0 0" 100 0 0 100 array_out - ));
1004 DATA(insert OID = 752 ( filename_in PGUID 11 f t f 1 f 605 "0" 100 0 0 100 filename_in - ));
1005 DESCR("(internal)");
1006 DATA(insert OID = 753 ( filename_out PGUID 11 f t f 2 f 19 "0 0" 100 0 0 100 filename_out - ));
1007 DESCR("(internal)");
1009 DATA(insert OID = 760 ( smgrin PGUID 11 f t f 1 f 210 "0" 100 0 0 100 smgrin - ));
1010 DESCR("storage manager(internal)");
1011 DATA(insert OID = 761 ( smgrout PGUID 11 f t f 1 f 23 "0" 100 0 0 100 smgrout - ));
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 smgreq - ));
1014 DESCR("storage manager");
1015 DATA(insert OID = 763 ( smgrne PGUID 11 f t f 2 f 16 "210 210" 100 0 0 100 smgrne - ));
1016 DESCR("storage manager");
1018 DATA(insert OID = 764 ( lo_import PGUID 11 f t f 1 f 26 "25" 100 0 0 100 lo_import - ));
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 lo_export - ));
1021 DESCR("large object export");
1023 DATA(insert OID = 766 ( int4inc PGUID 11 f t f 1 f 23 "23" 100 0 0 100 int4inc - ));
1025 DATA(insert OID = 767 ( int2inc PGUID 11 f t f 1 f 21 "21" 100 0 0 100 int2inc - ));
1027 DATA(insert OID = 768 ( int4larger PGUID 11 f t f 2 f 23 "23 23" 100 0 0 100 int4larger - ));
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 int4smaller - ));
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 int2larger - ));
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 int2smaller - ));
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 gistsel - ));
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 gistnpage - ));
1039 DATA(insert OID = 774 ( gistgettuple PGUID 11 f t f 2 f 23 "0" 100 0 0 100 gistgettuple - ));
1040 DESCR("gist(internal)");
1041 DATA(insert OID = 775 ( gistinsert PGUID 11 f t f 5 f 23 "0" 100 0 0 100 gistinsert - ));
1042 DESCR("gist(internal)");
1043 DATA(insert OID = 776 ( gistdelete PGUID 11 f t f 2 f 23 "0" 100 0 0 100 gistdelete - ));
1044 DESCR("gist(internal)");
1045 DATA(insert OID = 777 ( gistbeginscan PGUID 11 f t f 4 f 23 "0" 100 0 0 100 gistbeginscan - ));
1046 DESCR("gist(internal)");
1047 DATA(insert OID = 778 ( gistrescan PGUID 11 f t f 3 f 23 "0" 100 0 0 100 gistrescan - ));
1048 DESCR("gist(internal)");
1049 DATA(insert OID = 779 ( gistendscan PGUID 11 f t f 1 f 23 "0" 100 0 0 100 gistendscan - ));
1050 DESCR("gist(internal)");
1051 DATA(insert OID = 780 ( gistmarkpos PGUID 11 f t f 1 f 23 "0" 100 0 0 100 gistmarkpos - ));
1052 DESCR("gist(internal)");
1053 DATA(insert OID = 781 ( gistrestrpos PGUID 11 f t f 1 f 23 "0" 100 0 0 100 gistrestrpos - ));
1054 DESCR("gist(internal)");
1055 DATA(insert OID = 782 ( gistbuild PGUID 11 f t f 9 f 23 "0" 100 0 0 100 gistbuild - ));
1056 DESCR("gist(internal)");
1058 DATA(insert OID = 784 ( intervaleq PGUID 11 f t f 2 f 16 "704 704" 100 0 0 100 intervaleq - ));
1060 DATA(insert OID = 785 ( intervalne PGUID 11 f t f 2 f 16 "704 704" 100 0 0 100 intervalne - ));
1062 DATA(insert OID = 786 ( intervallt PGUID 11 f t f 2 f 16 "704 704" 100 0 0 100 intervallt - ));
1064 DATA(insert OID = 787 ( intervalgt PGUID 11 f t f 2 f 16 "704 704" 100 0 0 100 intervalgt - ));
1065 DESCR("greater-than");
1066 DATA(insert OID = 788 ( intervalle PGUID 11 f t f 2 f 16 "704 704" 100 0 0 100 intervalle - ));
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 intervalge - ));
1069 DESCR("greater-than-or-equal");
1071 /* OIDS 800 - 899 */
1073 DATA(insert OID = 817 ( text_oid PGUID 11 f t f 1 f 26 "25" 100 0 0 100 text_oid -));
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 text_int2 -));
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 text_int4 -));
1078 DESCR("convert text to int4");
1080 DATA(insert OID = 838 ( text_float8 PGUID 11 f t f 1 f 701 "25" 100 0 0 100 text_float8 -));
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 text_float4 -));
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 float8_text -));
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 float4_text -));
1087 DESCR("convert float4 to text");
1089 DATA(insert OID = 846 ( cash_mul_flt4 PGUID 11 f t f 2 f 790 "790 700" 100 0 0 100 cash_mul_flt4 - ));
1091 DATA(insert OID = 847 ( cash_div_flt4 PGUID 11 f t f 2 f 790 "790 700" 100 0 0 100 cash_div_flt4 - ));
1093 DATA(insert OID = 848 ( flt4_mul_cash PGUID 11 f t f 2 f 790 "700 790" 100 0 0 100 flt4_mul_cash - ));
1096 DATA(insert OID = 849 ( textpos PGUID 11 f t f 2 f 23 "25 25" 100 0 1 0 textpos - ));
1097 DESCR("return position of substring");
1098 DATA(insert OID = 850 ( textlike PGUID 11 f t f 2 f 16 "25 25" 100 0 1 0 textlike - ));
1099 DESCR("matches LIKE expression");
1100 DATA(insert OID = 851 ( textnlike PGUID 11 f t f 2 f 16 "25 25" 100 0 1 0 textnlike - ));
1101 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 int48eq - ));
1105 DATA(insert OID = 853 ( int48ne PGUID 11 f t f 2 f 16 "23 20" 100 0 0 100 int48ne - ));
1107 DATA(insert OID = 854 ( int48lt PGUID 11 f t f 2 f 16 "23 20" 100 0 0 100 int48lt - ));
1109 DATA(insert OID = 855 ( int48gt PGUID 11 f t f 2 f 16 "23 20" 100 0 0 100 int48gt - ));
1110 DESCR("greater-than");
1111 DATA(insert OID = 856 ( int48le PGUID 11 f t f 2 f 16 "23 20" 100 0 0 100 int48le - ));
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 int48ge - ));
1114 DESCR("greater-than-or-equal");
1116 DATA(insert OID = 858 ( namelike PGUID 11 f t f 2 f 16 "19 25" 100 0 0 100 namelike - ));
1117 DESCR("matches LIKE expression");
1118 DATA(insert OID = 859 ( namenlike PGUID 11 f t f 2 f 16 "19 25" 100 0 0 100 namenlike - ));
1119 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 char_bpchar - ));
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 bpchar_char - ));
1124 DESCR("convert char() to char");
1126 DATA(insert OID = 862 ( int4_mul_cash PGUID 11 f t f 2 f 790 "23 790" 100 0 0 100 int4_mul_cash - ));
1128 DATA(insert OID = 863 ( int2_mul_cash PGUID 11 f t f 2 f 790 "21 790" 100 0 0 100 int2_mul_cash - ));
1130 DATA(insert OID = 864 ( cash_mul_int4 PGUID 11 f t f 2 f 790 "790 23" 100 0 0 100 cash_mul_int4 - ));
1132 DATA(insert OID = 865 ( cash_div_int4 PGUID 11 f t f 2 f 790 "790 23" 100 0 0 100 cash_div_int4 - ));
1134 DATA(insert OID = 866 ( cash_mul_int2 PGUID 11 f t f 2 f 790 "790 21" 100 0 0 100 cash_mul_int2 - ));
1136 DATA(insert OID = 867 ( cash_div_int2 PGUID 11 f t f 2 f 790 "790 21" 100 0 0 100 cash_div_int2 - ));
1139 DATA(insert OID = 886 ( cash_in PGUID 11 f t f 1 f 790 "0" 100 0 0 100 cash_in - ));
1140 DESCR("(internal)");
1141 DATA(insert OID = 887 ( cash_out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 cash_out - ));
1142 DESCR("(internal)");
1143 DATA(insert OID = 1273 ( cash_words_out PGUID 11 f t f 1 f 25 "790" 100 0 0 100 cash_words_out - ));
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 cash_eq - ));
1147 DATA(insert OID = 889 ( cash_ne PGUID 11 f t f 2 f 16 "790 790" 100 0 0 100 cash_ne - ));
1149 DATA(insert OID = 890 ( cash_lt PGUID 11 f t f 2 f 16 "790 790" 100 0 0 100 cash_lt - ));
1151 DATA(insert OID = 891 ( cash_le PGUID 11 f t f 2 f 16 "790 790" 100 0 0 100 cash_le - ));
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 cash_gt - ));
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 cash_ge - ));
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 cash_pl - ));
1159 DATA(insert OID = 895 ( cash_mi PGUID 11 f t f 2 f 790 "790 790" 100 0 0 100 cash_mi - ));
1161 DATA(insert OID = 896 ( cash_mul_flt8 PGUID 11 f t f 2 f 790 "790 701" 100 0 0 100 cash_mul_flt8 - ));
1163 DATA(insert OID = 897 ( cash_div_flt8 PGUID 11 f t f 2 f 790 "790 701" 100 0 0 100 cash_div_flt8 - ));
1165 DATA(insert OID = 898 ( cashlarger PGUID 11 f t f 2 f 790 "790 790" 100 0 0 100 cashlarger - ));
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 cashsmaller - ));
1168 DESCR("smaller of two");
1170 DATA(insert OID = 919 ( flt8_mul_cash PGUID 11 f t f 2 f 790 "701 790" 100 0 0 100 flt8_mul_cash - ));
1173 /* OIDS 900 - 999 */
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 isoldpath - ));
1178 DATA(insert OID = 937 ( upgradepath PGUID 11 f t f 1 f 602 "602" 100 0 0 100 upgradepath - ));
1180 DATA(insert OID = 938 ( upgradepoly PGUID 11 f t f 1 f 604 "604" 100 0 0 100 upgradepoly - ));
1182 DATA(insert OID = 939 ( revertpoly PGUID 11 f t f 1 f 604 "604" 100 0 0 100 revertpoly - ));
1185 DATA(insert OID = 942 ( char_text PGUID 11 f t f 1 f 25 "18" 100 0 0 100 char_text - ));
1186 DESCR("convert char to text");
1187 DATA(insert OID = 943 ( text_char PGUID 11 f t f 1 f 18 "25" 100 0 0 100 text_char - ));
1188 DESCR("convert text to char");
1189 DATA(insert OID = 944 ( char PGUID 11 f t f 1 f 18 "25" 100 0 0 100 text_char - ));
1190 DESCR("convert text to char()");
1191 DATA(insert OID = 946 ( text PGUID 11 f t f 1 f 25 "18" 100 0 0 100 char_text - ));
1192 DESCR("convert char to text");
1193 DATA(insert OID = 947 ( char PGUID 11 f t f 1 f 18 "1042" 100 0 0 100 bpchar_char - ));
1194 DESCR("convert char() to char");
1195 DATA(insert OID = 948 ( varchar PGUID 11 f t f 1 f 25 "1043" 100 0 0 100 bpchar_char - ));
1196 DESCR("convert char to text");
1198 DATA(insert OID = 950 ( istrue PGUID 11 f t f 1 f 16 "16" 100 0 0 100 istrue - ));
1200 DATA(insert OID = 951 ( isfalse PGUID 11 f t f 1 f 16 "16" 100 0 0 100 isfalse - ));
1203 DATA(insert OID = 952 ( lo_open PGUID 11 f t f 2 f 23 "26 23" 100 0 0 100 lo_open - ));
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 lo_close - ));
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 loread - ));
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 lowrite - ));
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 lo_lseek - ));
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 lo_creat - ));
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 lo_tell - ));
1216 DESCR("large object position");
1218 DATA(insert OID = 959 ( on_pl PGUID 11 f t f 2 f 16 "600 628" 100 0 10 100 on_pl - ));
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 on_sl - ));
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 close_pl - ));
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 close_sl - ));
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 close_lb - ));
1227 DESCR("closest point to line on box");
1229 DATA(insert OID = 964 ( lo_unlink PGUID 11 f t f 1 f 23 "26" 100 0 0 100 lo_unlink - ));
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 regproctooid - ));
1232 DESCR("get oid for regproc");
1234 DATA(insert OID = 973 ( path_inter PGUID 11 f t f 2 f 16 "602 602" 100 0 10 100 path_inter - ));
1236 DATA(insert OID = 975 ( box_area PGUID 11 f t f 1 f 701 "603" 100 0 0 100 box_area - ));
1238 DATA(insert OID = 976 ( box_width PGUID 11 f t f 1 f 701 "603" 100 0 0 100 box_width - ));
1240 DATA(insert OID = 977 ( box_height PGUID 11 f t f 1 f 701 "603" 100 0 0 100 box_height - ));
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 box_distance - ));
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 box_intersect - ));
1245 DESCR("intersects");
1246 DATA(insert OID = 981 ( box_diagonal PGUID 11 f t f 1 f 601 "603" 100 0 0 100 box_diagonal - ));
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 path_n_lt - ));
1250 DATA(insert OID = 983 ( path_n_gt PGUID 11 f t f 2 f 16 "602 602" 100 0 0 100 path_n_gt - ));
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 path_n_eq - ));
1254 DATA(insert OID = 985 ( path_n_le PGUID 11 f t f 2 f 16 "602 602" 100 0 0 100 path_n_le - ));
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 path_n_ge - ));
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 path_length - ));
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 point_ne - ));
1262 DATA(insert OID = 989 ( point_vert PGUID 11 f t f 2 f 16 "600 600" 100 0 0 100 point_vert - ));
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 point_horiz - ));
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 point_distance - ));
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 point_slope - ));
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 lseg_construct - ));
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 lseg_intersect - ));
1273 DESCR("intersects");
1274 DATA(insert OID = 995 ( lseg_parallel PGUID 11 f t f 2 f 16 "601 601" 100 0 0 100 lseg_parallel - ));
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 lseg_perp - ));
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 lseg_vertical - ));
1279 DESCR("is vertical");
1280 DATA(insert OID = 998 ( lseg_horizontal PGUID 11 f t f 1 f 16 "601" 100 0 0 100 lseg_horizontal - ));
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 lseg_eq - ));
1285 /* OIDS 1000 - 1999 */
1287 DATA(insert OID = 1029 ( nullvalue PGUID 11 f t f 1 f 16 "0" 100 0 0 100 nullvalue - ));
1288 DESCR("(internal)");
1289 DATA(insert OID = 1030 ( nonnullvalue PGUID 11 f t f 1 f 16 "0" 100 0 0 100 nonnullvalue - ));
1290 DESCR("(internal)");
1291 DATA(insert OID = 1031 ( aclitemin PGUID 11 f t f 1 f 1033 "0" 100 0 0 100 aclitemin - ));
1292 DESCR("(internal)");
1293 DATA(insert OID = 1032 ( aclitemout PGUID 11 f t f 1 f 23 "0" 100 0 0 100 aclitemout - ));
1294 DESCR("(internal)");
1295 DATA(insert OID = 1035 ( aclinsert PGUID 11 f t f 2 f 1034 "1034 1033" 100 0 0 100 aclinsert - ));
1297 DATA(insert OID = 1036 ( aclremove PGUID 11 f t f 2 f 1034 "1034 1033" 100 0 0 100 aclremove - ));
1299 DATA(insert OID = 1037 ( aclcontains PGUID 11 f t f 2 f 16 "1034 1033" 100 0 0 100 aclcontains - ));
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 seteval - ));
1303 DATA(insert OID = 1044 ( bpcharin PGUID 11 f t f 3 f 1042 "0 0 23" 100 0 0 100 bpcharin - ));
1304 DESCR("(internal)");
1305 DATA(insert OID = 1045 ( bpcharout PGUID 11 f t f 1 f 23 "0" 100 0 0 100 bpcharout - ));
1306 DESCR("(internal)");
1307 DATA(insert OID = 1046 ( varcharin PGUID 11 f t f 3 f 1043 "0 0 23" 100 0 0 100 varcharin - ));
1308 DESCR("(internal)");
1309 DATA(insert OID = 1047 ( varcharout PGUID 11 f t f 1 f 23 "0" 100 0 0 100 varcharout - ));
1310 DESCR("(internal)");
1311 DATA(insert OID = 1048 ( bpchareq PGUID 11 f t f 2 f 16 "1042 1042" 100 0 0 100 bpchareq - ));
1313 DATA(insert OID = 1049 ( bpcharlt PGUID 11 f t f 2 f 16 "1042 1042" 100 0 0 100 bpcharlt - ));
1315 DATA(insert OID = 1050 ( bpcharle PGUID 11 f t f 2 f 16 "1042 1042" 100 0 0 100 bpcharle - ));
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 bpchargt - ));
1318 DESCR("greater-than");
1319 DATA(insert OID = 1052 ( bpcharge PGUID 11 f t f 2 f 16 "1042 1042" 100 0 0 100 bpcharge - ));
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 bpcharne - ));
1323 DATA(insert OID = 1070 ( varchareq PGUID 11 f t f 2 f 16 "1043 1043" 100 0 0 100 varchareq - ));
1325 DATA(insert OID = 1071 ( varcharlt PGUID 11 f t f 2 f 16 "1043 1043" 100 0 0 100 varcharlt - ));
1327 DATA(insert OID = 1072 ( varcharle PGUID 11 f t f 2 f 16 "1043 1043" 100 0 0 100 varcharle - ));
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 varchargt - ));
1330 DESCR("greater-than");
1331 DATA(insert OID = 1074 ( varcharge PGUID 11 f t f 2 f 16 "1043 1043" 100 0 0 100 varcharge - ));
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 varcharne - ));
1335 DATA(insert OID = 1078 ( bpcharcmp PGUID 11 f t f 2 f 23 "1042 1042" 100 0 0 100 bpcharcmp - ));
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 varcharcmp - ));
1338 DESCR("less-equal-greater");
1339 DATA(insert OID = 1080 ( hashbpchar PGUID 11 f t f 1 f 23 "1042" 100 0 0 100 hashbpchar - ));
1341 DATA(insert OID = 1081 ( hashvarchar PGUID 11 f t f 1 f 23 "1043" 100 0 0 100 hashvarchar - ));
1344 DATA(insert OID = 1084 ( date_in PGUID 11 f t f 1 f 1082 "0" 100 0 0 100 date_in - ));
1345 DESCR("(internal)");
1346 DATA(insert OID = 1085 ( date_out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 date_out - ));
1347 DESCR("(internal)");
1348 DATA(insert OID = 1086 ( date_eq PGUID 11 f t f 2 f 16 "1082 1082" 100 0 0 100 date_eq - ));
1350 DATA(insert OID = 1087 ( date_lt PGUID 11 f t f 2 f 16 "1082 1082" 100 0 0 100 date_lt - ));
1352 DATA(insert OID = 1088 ( date_le PGUID 11 f t f 2 f 16 "1082 1082" 100 0 0 100 date_le - ));
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 date_gt - ));
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 date_ge - ));
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 date_ne - ));
1360 DATA(insert OID = 1092 ( date_cmp PGUID 11 f t f 2 f 23 "1082 1082" 100 0 0 100 date_cmp - ));
1361 DESCR("less-equal-greater");
1363 /* OIDS 1100 - 1199 */
1365 DATA(insert OID = 1102 ( time_lt PGUID 11 f t f 2 f 16 "1083 1083" 100 0 0 100 time_lt - ));
1367 DATA(insert OID = 1103 ( time_le PGUID 11 f t f 2 f 16 "1083 1083" 100 0 0 100 time_le - ));
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 time_gt - ));
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 time_ge - ));
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 time_ne - ));
1375 DATA(insert OID = 1107 ( time_cmp PGUID 11 f t f 2 f 23 "1083 1083" 100 0 0 100 time_cmp - ));
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 date_larger - ));
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 date_smaller - ));
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 date_mi - ));
1383 DATA(insert OID = 1141 ( date_pli PGUID 11 f t f 2 f 1082 "1082 23" 100 0 0 100 date_pli - ));
1385 DATA(insert OID = 1142 ( date_mii PGUID 11 f t f 2 f 1082 "1082 23" 100 0 0 100 date_mii - ));
1387 DATA(insert OID = 1143 ( time_in PGUID 11 f t f 1 f 1083 "0" 100 0 0 100 time_in - ));
1388 DESCR("(internal)");
1389 DATA(insert OID = 1144 ( time_out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 time_out - ));
1390 DESCR("(internal)");
1391 DATA(insert OID = 1145 ( time_eq PGUID 11 f t f 2 f 16 "1083 1083" 100 0 0 100 time_eq - ));
1394 DATA(insert OID = 1146 ( circle_add_pt PGUID 11 f t f 2 f 718 "718 600" 100 0 0 100 circle_add_pt - ));
1396 DATA(insert OID = 1147 ( circle_sub_pt PGUID 11 f t f 2 f 718 "718 600" 100 0 0 100 circle_sub_pt - ));
1398 DATA(insert OID = 1148 ( circle_mul_pt PGUID 11 f t f 2 f 718 "718 600" 100 0 0 100 circle_mul_pt - ));
1400 DATA(insert OID = 1149 ( circle_div_pt PGUID 11 f t f 2 f 718 "718 600" 100 0 0 100 circle_div_pt - ));
1403 DATA(insert OID = 1150 ( datetime_in PGUID 11 f t f 1 f 1184 "0" 100 0 0 100 datetime_in - ));
1404 DESCR("(internal)");
1405 DATA(insert OID = 1151 ( datetime_out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 datetime_out - ));
1406 DESCR("(internal)");
1407 DATA(insert OID = 1152 ( datetime_eq PGUID 11 f t f 2 f 16 "1184 1184" 100 0 0 100 datetime_eq - ));
1409 DATA(insert OID = 1153 ( datetime_ne PGUID 11 f t f 2 f 16 "1184 1184" 100 0 0 100 datetime_ne - ));
1411 DATA(insert OID = 1154 ( datetime_lt PGUID 11 f t f 2 f 16 "1184 1184" 100 0 0 100 datetime_lt - ));
1413 DATA(insert OID = 1155 ( datetime_le PGUID 11 f t f 2 f 16 "1184 1184" 100 0 0 100 datetime_le - ));
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 datetime_ge - ));
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 datetime_gt - ));
1418 DESCR("greater-than");
1419 DATA(insert OID = 1158 ( datetime_finite PGUID 11 f t f 1 f 16 "1184" 100 0 0 100 datetime_finite - ));
1421 DATA(insert OID = 1159 ( datetime_zone PGUID 11 f t f 2 f 25 "25 1184" 100 0 0 100 datetime_zone - ));
1424 DATA(insert OID = 1160 ( timespan_in PGUID 11 f t f 1 f 1186 "0" 100 0 0 100 timespan_in - ));
1425 DESCR("(internal)");
1426 DATA(insert OID = 1161 ( timespan_out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 timespan_out - ));
1427 DESCR("(internal)");
1428 DATA(insert OID = 1162 ( timespan_eq PGUID 11 f t f 2 f 16 "1186 1186" 100 0 0 100 timespan_eq - ));
1430 DATA(insert OID = 1163 ( timespan_ne PGUID 11 f t f 2 f 16 "1186 1186" 100 0 0 100 timespan_ne - ));
1432 DATA(insert OID = 1164 ( timespan_lt PGUID 11 f t f 2 f 16 "1186 1186" 100 0 0 100 timespan_lt - ));
1434 DATA(insert OID = 1165 ( timespan_le PGUID 11 f t f 2 f 16 "1186 1186" 100 0 0 100 timespan_le - ));
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 timespan_ge - ));
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 timespan_gt - ));
1439 DESCR("greater-than");
1440 DATA(insert OID = 1168 ( timespan_um PGUID 11 f t f 1 f 1186 "1186" 100 0 0 100 timespan_um - ));
1442 DATA(insert OID = 1169 ( timespan_pl PGUID 11 f t f 2 f 1186 "1186 1186" 100 0 0 100 timespan_pl - ));
1444 DATA(insert OID = 1170 ( timespan_mi PGUID 11 f t f 2 f 1186 "1186 1186" 100 0 0 100 timespan_mi - ));
1446 DATA(insert OID = 1171 ( datetime_part PGUID 11 f t f 2 f 701 "25 1184" 100 0 0 100 datetime_part - ));
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 timespan_part - ));
1449 DESCR("extract field from timespan");
1451 DATA(insert OID = 1173 ( abstime_datetime PGUID 11 f t f 1 f 1184 "702" 100 0 0 100 abstime_datetime - ));
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 date_datetime - ));
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 timestamp_datetime - ));
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 datetime_datetime - ));
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 reltime_timespan - ));
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 datetime_date - ));
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 abstime_date - ));
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 datetime_abstime - ));
1466 DESCR("convert datetime to abstime");
1468 DATA(insert OID = 1188 ( datetime_mi PGUID 11 f t f 2 f 1186 "1184 1184" 100 0 0 100 datetime_mi - ));
1470 DATA(insert OID = 1189 ( datetime_pl_span PGUID 11 f t f 2 f 1184 "1184 1186" 100 0 0 100 datetime_pl_span - ));
1472 DATA(insert OID = 1190 ( datetime_mi_span PGUID 11 f t f 2 f 1184 "1184 1186" 100 0 0 100 datetime_mi_span - ));
1474 DATA(insert OID = 1191 ( text_datetime PGUID 11 f t f 1 f 1184 "25" 100 0 0 100 text_datetime - ));
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 datetime_text - ));
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 timespan_text - ));
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 timespan_reltime - ));
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 datetime_smaller - ));
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 datetime_larger - ));
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 timespan_smaller - ));
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 timespan_larger - ));
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 datetime_age - ));
1491 DESCR("date difference preserving months and years");
1493 /* OIDS 1200 - 1299 */
1495 DATA(insert OID = 1200 ( int4reltime PGUID 11 f t f 1 f 703 "23" 100 0 0 100 int4reltime - ));
1496 DESCR("convert int4 to reltime");
1498 DATA(insert OID = 1217 ( datetime_trunc PGUID 11 f t f 2 f 1184 "25 1184" 100 0 0 100 datetime_trunc - ));
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 timespan_trunc - ));
1501 DESCR("truncate timespan to specified units");
1503 DATA(insert OID = 1230 ( bpchar PGUID 11 f t f 1 f 1042 "18" 100 0 0 100 char_bpchar - ));
1504 DESCR("convert char to char()");
1506 DATA(insert OID = 1236 ( int8larger PGUID 11 f t f 2 f 20 "20 20" 100 0 0 100 int8larger - ));
1507 DESCR("larger of two");
1508 DATA(insert OID = 1237 ( int8smaller PGUID 11 f t f 2 f 20 "20 20" 100 0 0 100 int8smaller - ));
1509 DESCR("smaller of two");
1511 DATA(insert OID = 1238 ( texticregexeq PGUID 11 f t f 2 f 16 "25 25" 100 0 1 0 texticregexeq - ));
1512 DESCR("matches regex., case-insensitive");
1513 DATA(insert OID = 1239 ( texticregexne PGUID 11 f t f 2 f 16 "25 25" 100 0 1 0 texticregexne - ));
1514 DESCR("does not match regex., case-insensitive");
1515 DATA(insert OID = 1240 ( nameicregexeq PGUID 11 f t f 2 f 16 "19 25" 100 0 0 100 nameicregexeq - ));
1516 DESCR("matches regex., case-insensitive");
1517 DATA(insert OID = 1241 ( nameicregexne PGUID 11 f t f 2 f 16 "19 25" 100 0 0 100 nameicregexne - ));
1518 DESCR("does not match regex., case-insensitive");
1520 DATA(insert OID = 1251 ( bpcharlen PGUID 11 f t f 1 f 23 "1042" 100 0 0 100 bpcharlen - ));
1521 DESCR("octet length");
1522 DATA(insert OID = 1378 ( bpcharoctetlen PGUID 11 f t f 1 f 23 "1042" 100 0 0 100 bpcharoctetlen - ));
1523 DESCR("octet length");
1524 DATA(insert OID = 1253 ( varcharlen PGUID 11 f t f 1 f 23 "1043" 100 0 0 100 varcharlen - ));
1525 DESCR("character length");
1526 DATA(insert OID = 1379 ( varcharoctetlen PGUID 11 f t f 1 f 23 "1043" 100 0 0 100 varcharoctetlen - ));
1527 DESCR("octet length");
1529 DATA(insert OID = 1263 ( text_timespan PGUID 11 f t f 1 f 1186 "25" 100 0 0 100 text_timespan - ));
1530 DESCR("convert text to timespan");
1531 DATA(insert OID = 1271 ( timespan_finite PGUID 11 f t f 1 f 16 "1186" 100 0 0 100 timespan_finite - ));
1532 DESCR("boolean test");
1534 DATA(insert OID = 1274 ( int84pl PGUID 11 f t f 2 f 20 "20 23" 100 0 0 100 int84pl - ));
1536 DATA(insert OID = 1275 ( int84mi PGUID 11 f t f 2 f 20 "20 23" 100 0 0 100 int84mi - ));
1537 DESCR("subtraction");
1538 DATA(insert OID = 1276 ( int84mul PGUID 11 f t f 2 f 20 "20 23" 100 0 0 100 int84mul - ));
1540 DATA(insert OID = 1277 ( int84div PGUID 11 f t f 2 f 20 "20 23" 100 0 0 100 int84div - ));
1542 DATA(insert OID = 1278 ( int48pl PGUID 11 f t f 2 f 20 "23 20" 100 0 0 100 int48pl - ));
1544 DATA(insert OID = 1279 ( int48mi PGUID 11 f t f 2 f 20 "23 20" 100 0 0 100 int48mi - ));
1545 DESCR("subtraction");
1546 DATA(insert OID = 1280 ( int48mul PGUID 11 f t f 2 f 20 "23 20" 100 0 0 100 int48mul - ));
1548 DATA(insert OID = 1281 ( int48div PGUID 11 f t f 2 f 20 "23 20" 100 0 0 100 int48div - ));
1551 DATA(insert OID = 1288 ( int8_text PGUID 11 f t f 1 f 25 "20" 100 0 0 100 int8_text - ));
1552 DESCR("convert int8 to text");
1553 DATA(insert OID = 1289 ( text_int8 PGUID 11 f t f 1 f 20 "25" 100 0 0 100 text_int8 - ));
1554 DESCR("convert text to int8");
1556 DATA(insert OID = 1297 ( timestamp_in PGUID 11 f t f 1 f 1296 "0" 100 0 0 100 timestamp_in - ));
1557 DESCR("(internal)");
1558 DATA(insert OID = 1298 ( timestamp_out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 timestamp_out - ));
1559 DESCR("(internal)");
1560 DATA(insert OID = 1299 ( now PGUID 11 f t f 0 f 1296 "0" 100 0 0 100 now - ));
1561 DESCR("current transaction time");
1563 /* OIDS 1300 - 1399 */
1565 DATA(insert OID = 1306 ( timestampeq PGUID 11 f t f 2 f 16 "1296 1296" 100 0 0 100 timestampeq - ));
1567 DATA(insert OID = 1307 ( timestampne PGUID 11 f t f 2 f 16 "1296 1296" 100 0 0 100 timestampne - ));
1569 DATA(insert OID = 1308 ( timestamplt PGUID 11 f t f 2 f 16 "1296 1296" 100 0 0 100 timestamplt - ));
1571 DATA(insert OID = 1309 ( timestampgt PGUID 11 f t f 2 f 16 "1296 1296" 100 0 0 100 timestampgt - ));
1572 DESCR("greater-than");
1573 DATA(insert OID = 1310 ( timestample PGUID 11 f t f 2 f 16 "1296 1296" 100 0 0 100 timestample - ));
1574 DESCR("less-than-or-equal");
1575 DATA(insert OID = 1311 ( timestampge PGUID 11 f t f 2 f 16 "1296 1296" 100 0 0 100 timestampge - ));
1576 DESCR("greater-than-or-equal");
1577 DATA(insert OID = 1314 ( datetime_cmp PGUID 11 f t f 2 f 23 "1184 1184" 100 0 0 100 datetime_cmp - ));
1578 DESCR("less-equal-greater");
1579 DATA(insert OID = 1315 ( timespan_cmp PGUID 11 f t f 2 f 23 "1186 1186" 100 0 0 100 timespan_cmp - ));
1580 DESCR("less-equal-greater");
1581 DATA(insert OID = 1316 ( datetime_time PGUID 11 f t f 1 f 1083 "1184" 100 0 0 100 datetime_time - ));
1582 DESCR("convert datetime to time");
1583 DATA(insert OID = 1318 ( datetime_timestamp PGUID 11 f t f 1 f 1296 "1184" 100 0 0 100 datetime_timestamp - ));
1584 DESCR("convert datetime to timestamp");
1585 DATA(insert OID = 1326 ( timespan_div PGUID 11 f t f 2 f 1186 "1186 701" 100 0 0 100 timespan_div - ));
1588 DATA(insert OID = 1339 ( date_zone PGUID 11 f t f 2 f 25 "25 1184" 100 0 0 100 datetime_zone - ));
1590 DATA(insert OID = 1340 ( text PGUID 11 f t f 1 f 25 "1184" 100 0 0 100 datetime_text - ));
1591 DESCR("convert datetime to text");
1592 DATA(insert OID = 1341 ( text PGUID 11 f t f 1 f 25 "1186" 100 0 0 100 timespan_text - ));
1593 DESCR("convert timespan to text");
1594 DATA(insert OID = 1342 ( text PGUID 11 f t f 1 f 25 "23" 100 0 0 100 int4_text - ));
1595 DESCR("convert int4 to text");
1596 DATA(insert OID = 1343 ( text PGUID 11 f t f 1 f 25 "21" 100 0 0 100 int2_text - ));
1597 DESCR("convert int2 to text");
1598 DATA(insert OID = 1344 ( text PGUID 11 f t f 1 f 25 "26" 100 0 0 100 oid_text - ));
1599 DESCR("convert oid to text");
1600 DATA(insert OID = 1345 ( oid PGUID 11 f t f 1 f 26 "25" 100 0 0 100 text_oid - ));
1601 DESCR("convert text to oid");
1602 DATA(insert OID = 1346 ( int2 PGUID 11 f t f 1 f 21 "25" 100 0 0 100 text_int2 - ));
1603 DESCR("convert text to int2");
1604 DATA(insert OID = 1347 ( int4 PGUID 11 f t f 1 f 23 "25" 100 0 0 100 text_int4 - ));
1605 DESCR("convert text to int4");
1606 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" - ));
1607 DESCR("get description for object id");
1608 DATA(insert OID = 1349 ( oid8types PGUID 11 f t f 1 f 25 "30" 100 0 0 100 oid8types - ));
1609 DESCR("print type names of oid8 field");
1611 DATA(insert OID = 1350 ( datetime PGUID 14 f t f 1 f 1184 "1184" 100 0 0 100 "select $1" - ));
1612 DESCR("convert (noop)");
1613 DATA(insert OID = 1351 ( datetime PGUID 11 f t f 1 f 1184 "25" 100 0 0 100 text_datetime - ));
1614 DESCR("convert text to datetime");
1615 DATA(insert OID = 1352 ( datetime PGUID 11 f t f 1 f 1184 "702" 100 0 0 100 abstime_datetime - ));
1616 DESCR("convert abstime to datetime");
1617 DATA(insert OID = 1353 ( datetime PGUID 11 f t f 1 f 1184 "1082" 100 0 0 100 date_datetime - ));
1618 DESCR("convert date to datetime");
1619 DATA(insert OID = 1354 ( datetime PGUID 11 f t f 1 f 1184 "1296" 100 0 0 100 timestamp_datetime - ));
1620 DESCR("convert timestamp to datetime");
1621 DATA(insert OID = 1355 ( datetime PGUID 11 f t f 2 f 1184 "1082 1083" 100 0 0 100 datetime_datetime - ));
1622 DESCR("convert date and time to datetime");
1623 DATA(insert OID = 1356 ( timespan PGUID 14 f t f 1 f 1186 "1186" 100 0 0 100 "select $1" - ));
1624 DESCR("convert (noop)");
1625 DATA(insert OID = 1357 ( timespan PGUID 11 f t f 1 f 1186 "703" 100 0 0 100 reltime_timespan - ));
1626 DESCR("convert reltime to timespan");
1627 DATA(insert OID = 1358 ( timespan PGUID 14 f t f 1 f 1186 "1083" 100 0 0 100 "select time_timespan($1)" - ));
1628 DESCR("convert time to timespan");
1629 DATA(insert OID = 1359 ( date PGUID 14 f t f 1 f 1082 "1082" 100 0 0 100 "select $1" - ));
1630 DESCR("convert (noop)");
1631 DATA(insert OID = 1360 ( date PGUID 11 f t f 1 f 1082 "1184" 100 0 0 100 datetime_date - ));
1632 DESCR("convert datetime to date");
1633 DATA(insert OID = 1361 ( date PGUID 11 f t f 1 f 1082 "702" 100 0 0 100 abstime_date - ));
1634 DESCR("convert abstime to date");
1635 DATA(insert OID = 1362 ( time PGUID 14 f t f 1 f 1083 "1083" 100 0 0 100 "select $1" - ));
1636 DESCR("convert (noop)");
1637 DATA(insert OID = 1363 ( time PGUID 11 f t f 1 f 1083 "1184" 100 0 0 100 datetime_time - ));
1638 DESCR("convert datetime to time");
1639 DATA(insert OID = 1364 ( time PGUID 14 f t f 1 f 1083 "702" 100 0 0 100 "select abstime_time($1)" - ));
1640 DESCR("convert abstime to time");
1641 DATA(insert OID = 1365 ( abstime PGUID 14 f t f 1 f 702 "702" 100 0 0 100 "select $1" - ));
1642 DESCR("convert (noop)");
1643 DATA(insert OID = 1366 ( abstime PGUID 11 f t f 1 f 702 "1184" 100 0 0 100 datetime_abstime - ));
1644 DESCR("convert datetime to abstime");
1645 DATA(insert OID = 1367 ( reltime PGUID 14 f t f 1 f 703 "703" 100 0 0 100 "select $1" - ));
1646 DESCR("convert (noop)");
1647 DATA(insert OID = 1368 ( reltime PGUID 11 f t f 1 f 703 "1186" 100 0 0 100 timespan_reltime - ));
1648 DESCR("convert timespan to reltime");
1649 DATA(insert OID = 1369 ( timestamp PGUID 14 f t f 1 f 1296 "1296" 100 0 0 100 "select $1" - ));
1650 DESCR("convert (noop)");
1651 DATA(insert OID = 1370 ( timestamp PGUID 14 f t f 1 f 1296 "1184" 100 0 0 100 "select datetime_stamp($1)" - ));
1652 DESCR("convert datetime to timestamp");
1653 DATA(insert OID = 1371 ( length PGUID 11 f t f 1 f 23 "25" 100 0 0 100 textlen - ));
1654 DESCR("character length");
1655 DATA(insert OID = 1372 ( length PGUID 11 f t f 1 f 23 "1042" 100 0 0 100 bpcharlen - ));
1656 DESCR("character length");
1657 DATA(insert OID = 1373 ( length PGUID 11 f t f 1 f 23 "1043" 100 0 0 100 varcharlen - ));
1658 DESCR("character length");
1660 DATA(insert OID = 1374 ( octet_length PGUID 11 f t f 1 f 23 "25" 100 0 0 100 textoctetlen - ));
1661 DESCR("octet length");
1662 DATA(insert OID = 1375 ( octet_length PGUID 11 f t f 1 f 23 "1042" 100 0 0 100 bpcharoctetlen - ));
1663 DESCR("octet length");
1664 DATA(insert OID = 1376 ( octet_length PGUID 11 f t f 1 f 23 "1043" 100 0 0 100 varcharoctetlen - ));
1665 DESCR("octet length");
1667 DATA(insert OID = 1380 ( date_part PGUID 11 f t f 2 f 701 "25 1184" 100 0 0 100 datetime_part - ));
1668 DESCR("extract field from datetime");
1669 DATA(insert OID = 1381 ( date_part PGUID 11 f t f 2 f 701 "25 1186" 100 0 0 100 timespan_part - ));
1670 DESCR("extract field from timespan");
1671 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))" - ));
1672 DESCR("extract field from abstime");
1673 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))" - ));
1674 DESCR("extract field from reltime");
1675 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))" - ));
1676 DESCR("extract field from date");
1677 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))" - ));
1678 DESCR("extract field from time");
1679 DATA(insert OID = 1386 ( date_trunc PGUID 11 f t f 2 f 1184 "25 1184" 100 0 0 100 datetime_trunc - ));
1680 DESCR("truncate datetime to field");
1681 DATA(insert OID = 1387 ( date_trunc PGUID 11 f t f 2 f 1186 "25 1186" 100 0 0 100 timespan_trunc - ));
1682 DESCR("truncate timespan to field");
1683 DATA(insert OID = 1388 ( age PGUID 11 f t f 2 f 1186 "1184 1184" 100 0 0 100 datetime_age - ));
1684 DESCR("difference between datetimes but leave years and months unresolved");
1685 DATA(insert OID = 1389 ( age PGUID 14 f t f 1 f 1186 "1184" 100 0 0 100 "select datetime_age(\'today\', $1)" - ));
1686 DESCR("difference between datetime and today but leave years and months unresolved");
1688 DATA(insert OID = 1390 ( isfinite PGUID 11 f t f 1 f 16 "1184" 100 0 0 100 datetime_finite - ));
1689 DESCR("boolean test");
1690 DATA(insert OID = 1391 ( isfinite PGUID 11 f t f 1 f 16 "1186" 100 0 0 100 timespan_finite - ));
1691 DESCR("boolean test");
1692 DATA(insert OID = 1392 ( isfinite PGUID 11 f t f 1 f 16 "702" 100 0 0 100 abstime_finite - ));
1693 DESCR("boolean test");
1695 DATA(insert OID = 1393 ( timespan PGUID 11 f t f 1 f 1186 "25" 100 0 0 100 text_timespan - ));
1696 DESCR("convert text to timespan");
1698 DATA(insert OID = 1394 ( name PGUID 11 f t f 1 f 19 "25" 100 0 0 100 text_name - ));
1699 DESCR("convert text to name");
1700 DATA(insert OID = 1395 ( text PGUID 11 f t f 1 f 25 "19" 100 0 0 100 name_text - ));
1701 DESCR("convert name to text");
1702 DATA(insert OID = 1396 ( name PGUID 11 f t f 1 f 19 "1042" 100 0 0 100 bpchar_name - ));
1703 DESCR("convert char() to name");
1704 DATA(insert OID = 1397 ( bpchar PGUID 11 f t f 1 f 1042 "19" 100 0 0 100 name_bpchar - ));
1705 DESCR("convert name to char()");
1706 DATA(insert OID = 1398 ( name PGUID 11 f t f 1 f 19 "1043" 100 0 0 100 text_name - ));
1707 DESCR("convert varchar to name");
1708 DATA(insert OID = 1399 ( varchar PGUID 11 f t f 1 f 1043 "19" 100 0 0 100 name_text - ));
1709 DESCR("convert convert name to varchar");
1711 /* OIDS 1400 - 1499 */
1713 DATA(insert OID = 1400 ( float PGUID 14 f t f 1 f 701 "701" 100 0 0 100 "select $1" - ));
1714 DESCR("convert float8 to float8 (no-op)");
1715 DATA(insert OID = 1401 ( float PGUID 11 f t f 1 f 701 "700" 100 0 0 100 ftod - ));
1716 DESCR("convert float4 to float8");
1717 DATA(insert OID = 1402 ( float4 PGUID 14 f t f 1 f 700 "700" 100 0 0 100 "select $1" - ));
1718 DESCR("convert float4 to float4 (no-op)");
1719 DATA(insert OID = 1403 ( float4 PGUID 11 f t f 1 f 700 "701" 100 0 0 100 dtof - ));
1720 DESCR("convert float8 to float4");
1721 DATA(insert OID = 1404 ( int PGUID 14 f t f 1 f 23 "23" 100 0 0 100 "select $1" - ));
1722 DESCR("convert (no-op)");
1723 DATA(insert OID = 1405 ( int2 PGUID 14 f t f 1 f 21 "21" 100 0 0 100 "select $1" - ));
1724 DESCR("convert (no-op)");
1725 DATA(insert OID = 1406 ( float8 PGUID 14 f t f 1 f 701 "701" 100 0 0 100 "select $1" - ));
1726 DESCR("convert (no-op)");
1727 DATA(insert OID = 1407 ( float8 PGUID 11 f t f 1 f 701 "700" 100 0 0 100 ftod - ));
1728 DESCR("convert float4 to float8");
1729 DATA(insert OID = 1408 ( float8 PGUID 11 f t f 1 f 701 "23" 100 0 0 100 i4tod - ));
1730 DESCR("convert int4 to float8");
1731 DATA(insert OID = 1409 ( float8 PGUID 11 f t f 1 f 701 "21" 100 0 0 100 i2tod - ));
1732 DESCR("convert int2 to float8");
1733 DATA(insert OID = 1410 ( float4 PGUID 11 f t f 1 f 700 "23" 100 0 0 100 i4tof - ));
1734 DESCR("convert int4 to float4");
1735 DATA(insert OID = 1411 ( float4 PGUID 11 f t f 1 f 700 "21" 100 0 0 100 i2tof - ));
1736 DESCR("convert int2 to float4");
1737 DATA(insert OID = 1412 ( int4 PGUID 14 f t f 1 f 23 "23" 100 0 0 100 "select $1" - ));
1738 DESCR("convert (no-op)");
1739 DATA(insert OID = 1413 ( int4 PGUID 11 f t f 1 f 23 "701" 100 0 0 100 dtoi4 - ));
1740 DESCR("convert float8 to int4");
1741 DATA(insert OID = 1414 ( int4 PGUID 11 f t f 1 f 23 "21" 100 0 0 100 i2toi4 - ));
1742 DESCR("convert int2 to int4");
1743 DATA(insert OID = 1415 ( int4 PGUID 11 f t f 1 f 23 "700" 100 0 0 100 ftoi4 - ));
1744 DESCR("convert float4 to int4");
1745 DATA(insert OID = 1417 ( int2 PGUID 11 f t f 1 f 21 "23" 100 0 0 100 i4toi2 - ));
1746 DESCR("convert int4 to int2");
1747 DATA(insert OID = 1418 ( int2 PGUID 11 f t f 1 f 21 "701" 100 0 0 100 dtoi2 - ));
1748 DESCR("convert float8 to int2");
1749 DATA(insert OID = 1419 ( int2 PGUID 11 f t f 1 f 21 "700" 100 0 0 100 ftoi2 - ));
1750 DESCR("convert float4 to int2");
1752 DATA(insert OID = 1421 ( box PGUID 11 f t f 2 f 603 "600 600" 100 0 0 100 box - ));
1753 DESCR("convert points to box");
1754 DATA(insert OID = 1422 ( box_add PGUID 11 f t f 2 f 603 "603 600" 100 0 0 100 box_add - ));
1755 DESCR("add point to box (translate)");
1756 DATA(insert OID = 1423 ( box_sub PGUID 11 f t f 2 f 603 "603 600" 100 0 0 100 box_sub - ));
1757 DESCR("subtract point from box (translate)");
1758 DATA(insert OID = 1424 ( box_mul PGUID 11 f t f 2 f 603 "603 600" 100 0 0 100 box_mul - ));
1759 DESCR("multiply box by point (scale)");
1760 DATA(insert OID = 1425 ( box_div PGUID 11 f t f 2 f 603 "603 600" 100 0 0 100 box_div - ));
1761 DESCR("divide box by point (scale)");
1762 DATA(insert OID = 1426 ( path_contain_pt PGUID 11 f t f 2 f 16 "602 600" 100 0 0 100 path_contain_pt - ));
1763 DESCR("path contains point?");
1764 DATA(insert OID = 1427 ( pt_contained_path PGUID 11 f t f 2 f 16 "600 602" 100 0 0 100 pt_contained_path - ));
1765 DESCR("point contained in path?");
1766 DATA(insert OID = 1428 ( poly_contain_pt PGUID 11 f t f 2 f 16 "604 600" 100 0 0 100 poly_contain_pt - ));
1767 DESCR("polygon contains point?");
1768 DATA(insert OID = 1429 ( pt_contained_poly PGUID 11 f t f 2 f 16 "600 604" 100 0 0 100 pt_contained_poly - ));
1769 DESCR("point contained by polygon?");
1771 DATA(insert OID = 1430 ( path_isclosed PGUID 11 f t f 1 f 16 "602" 100 0 0 100 path_isclosed - ));
1773 DATA(insert OID = 1431 ( path_isopen PGUID 11 f t f 1 f 16 "602" 100 0 0 100 path_isopen - ));
1775 DATA(insert OID = 1432 ( path_npoints PGUID 11 f t f 1 f 23 "602" 100 0 0 100 path_npoints - ));
1777 DATA(insert OID = 1433 ( path_close PGUID 11 f t f 1 f 602 "602" 100 0 0 100 path_close - ));
1779 DATA(insert OID = 1434 ( path_open PGUID 11 f t f 1 f 602 "602" 100 0 0 100 path_open - ));
1781 DATA(insert OID = 1435 ( path_add PGUID 11 f t f 2 f 602 "602 602" 100 0 0 100 path_add - ));
1783 DATA(insert OID = 1436 ( path_add_pt PGUID 11 f t f 2 f 602 "602 600" 100 0 0 100 path_add_pt - ));
1785 DATA(insert OID = 1437 ( path_sub_pt PGUID 11 f t f 2 f 602 "602 600" 100 0 0 100 path_sub_pt - ));
1787 DATA(insert OID = 1438 ( path_mul_pt PGUID 11 f t f 2 f 602 "602 600" 100 0 0 100 path_mul_pt - ));
1789 DATA(insert OID = 1439 ( path_div_pt PGUID 11 f t f 2 f 602 "602 600" 100 0 0 100 path_div_pt - ));
1792 DATA(insert OID = 1440 ( point PGUID 11 f t f 2 f 600 "701 701" 100 0 0 100 point - ));
1793 DESCR("convert x, y to point");
1794 DATA(insert OID = 1441 ( point_add PGUID 11 f t f 2 f 600 "600 600" 100 0 0 100 point_add - ));
1795 DESCR("add points (translate)");
1796 DATA(insert OID = 1442 ( point_sub PGUID 11 f t f 2 f 600 "600 600" 100 0 0 100 point_sub - ));
1797 DESCR("subtract points (translate)");
1798 DATA(insert OID = 1443 ( point_mul PGUID 11 f t f 2 f 600 "600 600" 100 0 0 100 point_mul - ));
1799 DESCR("multiply points (scale/rotate)");
1800 DATA(insert OID = 1444 ( point_div PGUID 11 f t f 2 f 600 "600 600" 100 0 0 100 point_div - ));
1801 DESCR("divide points (scale/rotate)");
1803 DATA(insert OID = 1445 ( poly_npoints PGUID 11 f t f 1 f 23 "604" 100 0 0 100 poly_npoints - ));
1804 DESCR("number of points in polygon");
1805 DATA(insert OID = 1446 ( poly_box PGUID 11 f t f 1 f 603 "604" 100 0 0 100 poly_box - ));
1806 DESCR("convert polygon to bounding box");
1807 DATA(insert OID = 1447 ( poly_path PGUID 11 f t f 1 f 602 "604" 100 0 0 100 poly_path - ));
1808 DESCR("convert polygon to path");
1809 DATA(insert OID = 1448 ( box_poly PGUID 11 f t f 1 f 604 "603" 100 0 0 100 box_poly - ));
1810 DESCR("convert box to polygon");
1811 DATA(insert OID = 1449 ( path_poly PGUID 11 f t f 1 f 604 "602" 100 0 0 100 path_poly - ));
1812 DESCR("convert path to polygon");
1814 DATA(insert OID = 1450 ( circle_in PGUID 11 f t f 1 f 718 "0" 100 0 1 0 circle_in - ));
1815 DESCR("(internal)");
1816 DATA(insert OID = 1451 ( circle_out PGUID 11 f t f 1 f 23 "0" 100 0 1 0 circle_out - ));
1817 DESCR("(internal)");
1818 DATA(insert OID = 1452 ( circle_same PGUID 11 f t f 2 f 16 "718 718" 100 0 1 0 circle_same - ));
1820 DATA(insert OID = 1453 ( circle_contain PGUID 11 f t f 2 f 16 "718 718" 100 0 1 0 circle_contain - ));
1822 DATA(insert OID = 1454 ( circle_left PGUID 11 f t f 2 f 16 "718 718" 100 0 1 0 circle_left - ));
1823 DESCR("is left of");
1824 DATA(insert OID = 1455 ( circle_overleft PGUID 11 f t f 2 f 16 "718 718" 100 0 1 0 circle_overleft - ));
1825 DESCR("overlaps, but does not extend to right of");
1826 DATA(insert OID = 1456 ( circle_overright PGUID 11 f t f 2 f 16 "718 718" 100 0 1 0 circle_overright - ));
1828 DATA(insert OID = 1457 ( circle_right PGUID 11 f t f 2 f 16 "718 718" 100 0 1 0 circle_right - ));
1829 DESCR("is left of");
1830 DATA(insert OID = 1458 ( circle_contained PGUID 11 f t f 2 f 16 "718 718" 100 0 1 0 circle_contained - ));
1832 DATA(insert OID = 1459 ( circle_overlap PGUID 11 f t f 2 f 16 "718 718" 100 0 1 0 circle_overlap - ));
1834 DATA(insert OID = 1460 ( circle_below PGUID 11 f t f 2 f 16 "718 718" 100 0 1 0 circle_below - ));
1836 DATA(insert OID = 1461 ( circle_above PGUID 11 f t f 2 f 16 "718 718" 100 0 1 0 circle_above - ));
1838 DATA(insert OID = 1462 ( circle_eq PGUID 11 f t f 2 f 16 "718 718" 100 0 1 0 circle_eq - ));
1840 DATA(insert OID = 1463 ( circle_ne PGUID 11 f t f 2 f 16 "718 718" 100 0 1 0 circle_ne - ));
1842 DATA(insert OID = 1464 ( circle_lt PGUID 11 f t f 2 f 16 "718 718" 100 0 1 0 circle_lt - ));
1844 DATA(insert OID = 1465 ( circle_gt PGUID 11 f t f 2 f 16 "718 718" 100 0 1 0 circle_gt - ));
1845 DESCR("greater-than");
1846 DATA(insert OID = 1466 ( circle_le PGUID 11 f t f 2 f 16 "718 718" 100 0 1 0 circle_le - ));
1847 DESCR("less-than-or-equal");
1848 DATA(insert OID = 1467 ( circle_ge PGUID 11 f t f 2 f 16 "718 718" 100 0 1 0 circle_ge - ));
1849 DESCR("greater-than-or-equal");
1850 DATA(insert OID = 1468 ( circle_area PGUID 11 f t f 1 f 701 "718" 100 0 1 0 circle_area - ));
1852 DATA(insert OID = 1469 ( circle_diameter PGUID 11 f t f 1 f 701 "718" 100 0 1 0 circle_diameter - ));
1854 DATA(insert OID = 1470 ( circle_radius PGUID 11 f t f 1 f 701 "718" 100 0 1 0 circle_radius - ));
1856 DATA(insert OID = 1471 ( circle_distance PGUID 11 f t f 2 f 701 "718 718" 100 0 1 0 circle_distance - ));
1857 DESCR("distance between");
1858 DATA(insert OID = 1472 ( circle_center PGUID 11 f t f 1 f 600 "718" 100 0 1 0 circle_center - ));
1860 DATA(insert OID = 1473 ( circle PGUID 11 f t f 2 f 718 "600 701" 100 0 1 0 circle - ));
1861 DESCR("convert point and radius to circle");
1862 DATA(insert OID = 1474 ( poly_circle PGUID 11 f t f 1 f 718 "604" 100 0 1 0 poly_circle - ));
1863 DESCR("convert polygon to circle");
1864 DATA(insert OID = 1475 ( circle_poly PGUID 11 f t f 2 f 604 "23 718" 100 0 1 0 circle_poly - ));
1865 DESCR("convert vertex count and circle to polygon");
1866 DATA(insert OID = 1476 ( dist_pc PGUID 11 f t f 2 f 701 "600 718" 100 0 1 0 dist_pc - ));
1867 DESCR("distance between");
1868 DATA(insert OID = 1477 ( circle_contain_pt PGUID 11 f t f 2 f 16 "718 600" 100 0 0 100 circle_contain_pt - ));
1870 DATA(insert OID = 1478 ( pt_contained_circle PGUID 11 f t f 2 f 16 "600 718" 100 0 0 100 pt_contained_circle - ));
1872 DATA(insert OID = 1479 ( box_circle PGUID 11 f t f 1 f 718 "603" 100 0 1 0 box_circle - ));
1873 DESCR("convert box to circle");
1874 DATA(insert OID = 1480 ( circle_box PGUID 11 f t f 1 f 603 "718" 100 0 1 0 circle_box - ));
1875 DESCR("convert circle to box");
1877 DATA(insert OID = 1481 ( text_substr PGUID 11 f t f 3 f 25 "25 23 23" 100 0 0 100 text_substr - ));
1878 DESCR("return portion of string");
1880 DATA(insert OID = 1482 ( lseg_ne PGUID 11 f t f 2 f 16 "601 601" 100 0 0 100 lseg_ne - ));
1882 DATA(insert OID = 1483 ( lseg_lt PGUID 11 f t f 2 f 16 "601 601" 100 0 0 100 lseg_lt - ));
1884 DATA(insert OID = 1484 ( lseg_le PGUID 11 f t f 2 f 16 "601 601" 100 0 0 100 lseg_le - ));
1885 DESCR("less-than-or-equal");
1886 DATA(insert OID = 1485 ( lseg_gt PGUID 11 f t f 2 f 16 "601 601" 100 0 0 100 lseg_gt - ));
1887 DESCR("greater-than");
1888 DATA(insert OID = 1486 ( lseg_ge PGUID 11 f t f 2 f 16 "601 601" 100 0 0 100 lseg_ge - ));
1889 DESCR("greater-than-or-equal");
1890 DATA(insert OID = 1487 ( lseg_length PGUID 11 f t f 1 f 701 "601" 100 0 1 0 lseg_length - ));
1891 DESCR("distance between endpoints");
1892 DATA(insert OID = 1488 ( close_ls PGUID 11 f t f 2 f 600 "628 601" 100 0 10 100 close_ls - ));
1893 DESCR("closest point to line on line segment");
1894 DATA(insert OID = 1489 ( close_lseg PGUID 11 f t f 2 f 600 "601 601" 100 0 10 100 close_lseg - ));
1895 DESCR("closest point to line segment on line segment");
1897 DATA(insert OID = 1490 ( line_in PGUID 11 f t f 1 f 628 "0" 100 0 0 100 line_in - ));
1898 DESCR("(internal)");
1899 DATA(insert OID = 1491 ( line_out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 line_out - ));
1900 DESCR("(internal)");
1901 DATA(insert OID = 1492 ( line_eq PGUID 11 f t f 2 f 16 "628 628" 100 0 0 100 line_eq - ));
1902 DESCR("lines equal?");
1903 DATA(insert OID = 1493 ( line_construct_pp PGUID 11 f t f 2 f 628 "600 600" 100 0 0 100 line_construct_pp - ));
1904 DESCR("line from points");
1905 DATA(insert OID = 1494 ( line_interpt PGUID 11 f t f 2 f 600 "628 628" 100 0 0 100 line_interpt - ));
1906 DESCR("intersection point");
1907 DATA(insert OID = 1495 ( line_intersect PGUID 11 f t f 2 f 16 "628 628" 100 0 0 100 line_intersect - ));
1908 DESCR("lines intersect?");
1909 DATA(insert OID = 1496 ( line_parallel PGUID 11 f t f 2 f 16 "628 628" 100 0 0 100 line_parallel - ));
1910 DESCR("lines parallel?");
1911 DATA(insert OID = 1497 ( line_perp PGUID 11 f t f 2 f 16 "628 628" 100 0 0 100 line_perp - ));
1912 DESCR("lines perpendicular?");
1913 DATA(insert OID = 1498 ( line_vertical PGUID 11 f t f 1 f 16 "628" 100 0 0 100 line_vertical - ));
1914 DESCR("lines vertical?");
1915 DATA(insert OID = 1499 ( line_horizontal PGUID 11 f t f 1 f 16 "628" 100 0 0 100 line_horizontal - ));
1916 DESCR("lines horizontal?");
1918 /* OIDS 1500 - 1599 */
1920 DATA(insert OID = 1530 ( point PGUID 11 f t f 2 f 600 "601 601" 100 0 0 100 lseg_interpt - ));
1921 DESCR("convert two line segments to point (intersection)");
1922 DATA(insert OID = 1531 ( point PGUID 11 f t f 1 f 600 "718" 100 0 0 100 circle_center - ));
1923 DESCR("convert circle to point (center)");
1924 DATA(insert OID = 1532 ( isvertical PGUID 11 f t f 2 f 16 "600 600" 100 0 0 100 point_vert - ));
1926 DATA(insert OID = 1533 ( ishorizontal PGUID 11 f t f 2 f 16 "600 600" 100 0 0 100 point_horiz - ));
1928 DATA(insert OID = 1534 ( slope PGUID 11 f t f 2 f 701 "600 600" 100 0 0 100 point_slope - ));
1931 DATA(insert OID = 1540 ( lseg PGUID 11 f t f 2 f 601 "600 600" 100 0 0 100 lseg_construct - ));
1933 DATA(insert OID = 1541 ( lseg PGUID 11 f t f 1 f 601 "603" 100 0 0 100 box_diagonal - ));
1935 DATA(insert OID = 1542 ( isparallel PGUID 11 f t f 2 f 16 "601 601" 100 0 0 100 lseg_parallel - ));
1937 DATA(insert OID = 1543 ( isperpendicular PGUID 11 f t f 2 f 16 "601 601" 100 0 0 100 lseg_perp - ));
1939 DATA(insert OID = 1544 ( isvertical PGUID 11 f t f 1 f 16 "601" 100 0 0 100 lseg_vertical - ));
1941 DATA(insert OID = 1545 ( ishorizontal PGUID 11 f t f 1 f 16 "601" 100 0 0 100 lseg_horizontal - ));
1944 /* pclose and popen might better be named close and open, but that crashes initdb.
1948 DATA(insert OID = 1550 ( path PGUID 11 f t f 1 f 602 "604" 100 0 0 100 poly_path - ));
1950 DATA(insert OID = 1551 ( length PGUID 11 f t f 1 f 701 "602" 100 0 1 0 path_length - ));
1951 DESCR("sum of lengths of path segments");
1952 DATA(insert OID = 1552 ( points PGUID 11 f t f 1 f 23 "602" 100 0 0 100 path_npoints - ));
1954 DATA(insert OID = 1553 ( pclose PGUID 11 f t f 1 f 602 "602" 100 0 0 100 path_close - ));
1956 DATA(insert OID = 1554 ( popen PGUID 11 f t f 1 f 602 "602" 100 0 0 100 path_open - ));
1958 DATA(insert OID = 1555 ( isopen PGUID 11 f t f 1 f 16 "602" 100 0 0 100 path_isopen - ));
1960 DATA(insert OID = 1556 ( isclosed PGUID 11 f t f 1 f 16 "602" 100 0 0 100 path_isclosed - ));
1963 DATA(insert OID = 1560 ( box PGUID 11 f t f 2 f 603 "603 603" 100 0 0 100 box_intersect - ));
1964 DESCR("convert boxes to box (intersection)");
1965 DATA(insert OID = 1561 ( box PGUID 11 f t f 1 f 603 "604" 100 0 0 100 poly_box - ));
1966 DESCR("convert polygon to box");
1967 DATA(insert OID = 1562 ( width PGUID 11 f t f 1 f 701 "603" 100 0 0 100 box_width - ));
1969 DATA(insert OID = 1563 ( height PGUID 11 f t f 1 f 701 "603" 100 0 0 100 box_height - ));
1970 DESCR("box height");
1971 DATA(insert OID = 1564 ( center PGUID 11 f t f 1 f 600 "603" 100 0 0 100 box_center - ));
1972 DESCR("box center");
1973 DATA(insert OID = 1565 ( area PGUID 11 f t f 1 f 701 "603" 100 0 0 100 box_area - ));
1975 DATA(insert OID = 1569 ( box PGUID 11 f t f 1 f 603 "718" 100 0 0 100 circle_box - ));
1976 DESCR("convert circle to box");
1978 DATA(insert OID = 1570 ( polygon PGUID 11 f t f 1 f 604 "602" 100 0 0 100 path_poly - ));
1979 DESCR("convert path to polygon");
1980 DATA(insert OID = 1571 ( polygon PGUID 11 f t f 1 f 604 "603" 100 0 0 100 box_poly - ));
1981 DESCR("convert box to polygon");
1982 DATA(insert OID = 1572 ( polygon PGUID 11 f t f 2 f 604 "23 718" 100 0 0 100 circle_poly - ));
1983 DESCR("convert circle to polygon");
1984 DATA(insert OID = 1573 ( polygon PGUID 14 f t f 1 f 604 "718" 100 0 0 100 "select circle_poly(12, $1)" - ));
1985 DESCR("convert circle to 12-vertex polygon");
1986 DATA(insert OID = 1574 ( points PGUID 11 f t f 1 f 23 "604" 100 0 0 100 poly_npoints - ));
1988 DATA(insert OID = 1575 ( center PGUID 11 f t f 1 f 600 "604" 100 0 0 100 poly_center - ));
1990 DATA(insert OID = 1576 ( length PGUID 11 f t f 1 f 701 "601" 100 0 1 0 lseg_length - ));
1991 DESCR("distance between endpoints");
1993 DATA(insert OID = 1579 ( circle PGUID 11 f t f 1 f 718 "603" 100 0 0 100 box_circle - ));
1994 DESCR("convert box to circle");
1995 DATA(insert OID = 1580 ( circle PGUID 11 f t f 1 f 718 "604" 100 0 0 100 poly_circle - ));
1996 DESCR("convert polygon to circle");
1997 DATA(insert OID = 1581 ( center PGUID 11 f t f 1 f 600 "718" 100 0 0 100 circle_center - ));
1998 DESCR("center of circle");
1999 DATA(insert OID = 1582 ( radius PGUID 11 f t f 1 f 701 "718" 100 0 0 100 circle_radius - ));
2000 DESCR("radius of circle");
2001 DATA(insert OID = 1583 ( diameter PGUID 11 f t f 1 f 701 "718" 100 0 0 100 circle_diameter - ));
2002 DESCR("diameter of circle");
2003 DATA(insert OID = 1584 ( area PGUID 11 f t f 1 f 701 "718" 100 0 0 100 circle_area - ));
2004 DESCR("area of circle");
2006 DATA(insert OID = 1592 ( int8 PGUID 14 f t f 1 f 20 "20" 100 0 0 100 "select $1" - ));
2007 DESCR("convert int8 to int8 (no-op)");
2008 DATA(insert OID = 1593 ( int8 PGUID 11 f t f 1 f 20 "23" 100 0 0 100 int48 - ));
2009 DESCR("convert int4 to int8");
2010 DATA(insert OID = 1594 ( int8 PGUID 11 f t f 1 f 20 "701" 100 0 0 100 dtoi8 - ));
2011 DESCR("convert float8 to int8");
2012 DATA(insert OID = 1595 ( int4 PGUID 11 f t f 1 f 23 "20" 100 0 0 100 int84 - ));
2013 DESCR("convert int8 to int4");
2014 DATA(insert OID = 1596 ( float8 PGUID 11 f t f 1 f 701 "20" 100 0 0 100 i8tod - ));
2015 DESCR("convert int8 to float8");
2017 /* OIDS 1600 - 1699 */
2019 DATA(insert OID = 1600 ( line PGUID 11 f t f 2 f 628 "600 600" 100 0 0 100 line_construct_pp - ));
2020 DESCR("points to line");
2021 DATA(insert OID = 1601 ( ishorizontal PGUID 11 f t f 1 f 16 "628" 100 0 0 100 line_horizontal - ));
2022 DESCR("is line horizontal?");
2023 DATA(insert OID = 1602 ( isvertical PGUID 11 f t f 1 f 16 "628" 100 0 0 100 line_vertical - ));
2024 DESCR("is line vertical?");
2025 DATA(insert OID = 1603 ( isparallel PGUID 11 f t f 2 f 16 "628 628" 100 0 0 100 line_parallel - ));
2026 DESCR("are lines parallel?");
2028 DATA(insert OID = 1604 ( float8 PGUID 11 f t f 1 f 701 "25" 100 0 0 100 text_float8 - ));
2029 DESCR("convert text to float8");
2030 DATA(insert OID = 1605 ( float4 PGUID 11 f t f 1 f 700 "25" 100 0 0 100 text_float4 - ));
2031 DESCR("convert text to float4");
2032 DATA(insert OID = 1606 ( text PGUID 11 f t f 1 f 25 "701" 100 0 0 100 float8_text - ));
2033 DESCR("convert float8 to text");
2034 DATA(insert OID = 1607 ( text PGUID 11 f t f 1 f 25 "700" 100 0 0 100 float4_text - ));
2035 DESCR("convert float4 to text");
2037 DATA(insert OID = 1619 ( varchar PGUID 11 f t f 1 f 1043 "23" 100 0 0 100 int4_text - ));
2038 DESCR("convert int4 to varchar");
2039 DATA(insert OID = 1620 ( int4 PGUID 11 f t f 1 f 23 "1043" 100 0 0 100 text_int4 - ));
2040 DESCR("convert varchar to int4");
2041 DATA(insert OID = 1621 ( text PGUID 11 f t f 1 f 25 "20" 100 0 0 100 int8_text - ));
2042 DESCR("convert int8 to text");
2043 DATA(insert OID = 1622 ( int8 PGUID 11 f t f 1 f 20 "25" 100 0 0 100 text_int8 - ));
2044 DESCR("convert text to int8");
2045 DATA(insert OID = 1623 ( varchar PGUID 11 f t f 1 f 1043 "20" 100 0 0 100 int8_text - ));
2046 DESCR("convert int8 to varchar");
2047 DATA(insert OID = 1624 ( int8 PGUID 11 f t f 1 f 20 "1043" 100 0 0 100 text_int8 - ));
2048 DESCR("convert varchar to int8");
2050 /* Oracle Compatibility Related Functions - By Edmund Mergl <E.Mergl@bawue.de> */
2051 DATA(insert OID = 868 ( strpos PGUID 11 f t f 2 f 23 "25 25" 100 0 0 100 textpos - ));
2052 DESCR("find position of substring");
2053 DATA(insert OID = 870 ( lower PGUID 11 f t f 1 f 25 "25" 100 0 0 100 lower - ));
2055 DATA(insert OID = 871 ( upper PGUID 11 f t f 1 f 25 "25" 100 0 0 100 upper - ));
2057 DATA(insert OID = 872 ( initcap PGUID 11 f t f 1 f 25 "25" 100 0 0 100 initcap - ));
2058 DESCR("capitalize each word");
2059 DATA(insert OID = 873 ( lpad PGUID 11 f t f 3 f 25 "25 23 25" 100 0 0 100 lpad - ));
2060 DESCR("left-pad string to length");
2061 DATA(insert OID = 874 ( rpad PGUID 11 f t f 3 f 25 "25 23 25" 100 0 0 100 rpad - ));
2062 DESCR("right-pad string to length");
2063 DATA(insert OID = 875 ( ltrim PGUID 11 f t f 2 f 25 "25 25" 100 0 0 100 ltrim - ));
2064 DESCR("left-pad string to length");
2065 DATA(insert OID = 876 ( rtrim PGUID 11 f t f 2 f 25 "25 25" 100 0 0 100 rtrim - ));
2066 DESCR("right-pad string to length");
2067 DATA(insert OID = 877 ( substr PGUID 11 f t f 3 f 25 "25 23 23" 100 0 0 100 text_substr - ));
2068 DESCR("return portion of string");
2069 DATA(insert OID = 878 ( translate PGUID 11 f t f 3 f 25 "25 18 18" 100 0 0 100 translate - ));
2070 DESCR("modify string by substring replacement");
2071 DATA(insert OID = 879 ( lpad PGUID 14 f t f 2 f 25 "25 23" 100 0 0 100 "select lpad($1, $2, \' \')" - ));
2072 DESCR("left-pad string to length");
2073 DATA(insert OID = 880 ( rpad PGUID 14 f t f 2 f 25 "25 23" 100 0 0 100 "select rpad($1, $2, \' \')" - ));
2074 DESCR("right-pad string to length");
2075 DATA(insert OID = 881 ( ltrim PGUID 14 f t f 1 f 25 "25" 100 0 0 100 "select ltrim($1, \' \')" - ));
2076 DESCR("remove initial characters from string");
2077 DATA(insert OID = 882 ( rtrim PGUID 14 f t f 1 f 25 "25" 100 0 0 100 "select rtrim($1, \' \')" - ));
2078 DESCR("remove trailing characters from string");
2079 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)" - ));
2080 DESCR("return portion of string");
2081 DATA(insert OID = 884 ( btrim PGUID 11 f t f 2 f 25 "25 25" 100 0 0 100 btrim - ));
2082 DESCR("trim both ends of string");
2083 DATA(insert OID = 885 ( btrim PGUID 14 f t f 1 f 25 "25" 100 0 0 100 "select btrim($1, \' \')" - ));
2084 DESCR("trim both ends of string");
2087 /* SEQUENCEs nextval & currval functions */
2088 DATA(insert OID = 1317 ( nextval PGUID 11 f t f 1 f 23 "25" 100 0 0 100 nextval - ));
2089 DESCR("sequence next value");
2090 DATA(insert OID = 1319 ( currval PGUID 11 f t f 1 f 23 "25" 100 0 0 100 currval - ));
2091 DESCR("sequence current value");
2092 DATA(insert OID = 1618 ( setval PGUID 11 f t f 2 f 23 "25 23" 100 0 0 100 setval - ));
2093 DESCR("sequence set value");
2095 /* for multi-byte support */
2096 DATA(insert OID = 1039 ( getdatabaseencoding PGUID 11 f t f 0 f 19 "0" 100 0 0 100 getdatabaseencoding - ));
2098 /* System-view support functions */
2099 DATA(insert OID = 1640 ( pg_get_ruledef PGUID 11 f t f 1 f 25 "19" 100 0 0 100 pg_get_ruledef - ));
2100 DESCR("source text of a rule");
2101 DATA(insert OID = 1641 ( pg_get_viewdef PGUID 11 f t f 1 f 25 "19" 100 0 0 100 pg_get_viewdef - ));
2102 DESCR("select statement of a view");
2103 DATA(insert OID = 1642 ( pg_get_userbyid PGUID 11 f t f 1 f 19 "23" 100 0 0 100 pg_get_userbyid - ));
2104 DESCR("user name by UID (with fallback)");
2105 DATA(insert OID = 1643 ( pg_get_indexdef PGUID 11 f t f 1 f 25 "26" 100 0 0 100 pg_get_indexdef - ));
2106 DESCR("index description");
2108 /* for mac type support */
2109 DATA(insert OID = 436 ( macaddr_in PGUID 11 f t f 1 f 829 "0" 100 0 0 100 macaddr_in - ));
2110 DESCR("(internal)");
2111 DATA(insert OID = 437 ( macaddr_out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 macaddr_out - ));
2112 DESCR("(internal)");
2114 DATA(insert OID = 830 ( macaddr_eq PGUID 11 f t f 2 f 16 "829 829" 100 0 0 100 macaddr_eq - ));
2116 DATA(insert OID = 831 ( macaddr_lt PGUID 11 f t f 2 f 16 "829 829" 100 0 0 100 macaddr_lt - ));
2118 DATA(insert OID = 832 ( macaddr_le PGUID 11 f t f 2 f 16 "829 829" 100 0 0 100 macaddr_le - ));
2119 DESCR("less-than-or-equal");
2120 DATA(insert OID = 833 ( macaddr_gt PGUID 11 f t f 2 f 16 "829 829" 100 0 0 100 macaddr_gt - ));
2121 DESCR("greater-than");
2122 DATA(insert OID = 834 ( macaddr_ge PGUID 11 f t f 2 f 16 "829 829" 100 0 0 100 macaddr_ge - ));
2123 DESCR("greater-than-or-equal");
2124 DATA(insert OID = 835 ( macaddr_ne PGUID 11 f t f 2 f 16 "829 829" 100 0 0 100 macaddr_ne - ));
2126 DATA(insert OID = 836 ( macaddr_cmp PGUID 11 f t f 2 f 23 "829 829" 100 0 0 100 macaddr_cmp - ));
2127 DESCR("less-equal-greater");
2128 DATA(insert OID = 837 ( macaddr_manuf PGUID 11 f t f 1 f 25 "829" 100 0 0 100 macaddr_manuf - ));
2129 DESCR("MAC manufacturer");
2131 /* for inet type support */
2132 DATA(insert OID = 910 ( inet_in PGUID 11 f t f 1 f 869 "0" 100 0 0 100 inet_in - ));
2133 DESCR("(internal)");
2134 DATA(insert OID = 911 ( inet_out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 inet_out - ));
2135 DESCR("(internal)");
2137 /* for cidr type support */
2138 DATA(insert OID = 1267 ( cidr_in PGUID 11 f t f 1 f 650 "0" 100 0 0 100 cidr_in - ));
2139 DESCR("(internal)");
2140 DATA(insert OID = 1416 ( cidr_out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 cidr_out - ));
2141 DESCR("(internal)");
2143 /* these are used for both inet and cidr */
2144 DATA(insert OID = 920 ( network_eq PGUID 11 f t f 2 f 16 "869 869" 100 0 0 100 network_eq - ));
2146 DATA(insert OID = 921 ( network_lt PGUID 11 f t f 2 f 16 "869 869" 100 0 0 100 network_lt - ));
2148 DATA(insert OID = 922 ( network_le PGUID 11 f t f 2 f 16 "869 869" 100 0 0 100 network_le - ));
2149 DESCR("less-than-or-equal");
2150 DATA(insert OID = 923 ( network_gt PGUID 11 f t f 2 f 16 "869 869" 100 0 0 100 network_gt - ));
2151 DESCR("greater-than");
2152 DATA(insert OID = 924 ( network_ge PGUID 11 f t f 2 f 16 "869 869" 100 0 0 100 network_ge - ));
2153 DESCR("greater-than-or-equal");
2154 DATA(insert OID = 925 ( network_ne PGUID 11 f t f 2 f 16 "869 869" 100 0 0 100 network_ne - ));
2156 DATA(insert OID = 926 ( network_cmp PGUID 11 f t f 2 f 23 "869 869" 100 0 0 100 network_cmp - ));
2157 DESCR("less-equal-greater");
2158 DATA(insert OID = 927 ( network_sub PGUID 11 f t f 2 f 16 "869 869" 100 0 0 100 network_sub - ));
2160 DATA(insert OID = 928 ( network_subeq PGUID 11 f t f 2 f 16 "869 869" 100 0 0 100 network_subeq - ));
2161 DESCR("is-subnet-or-equal");
2162 DATA(insert OID = 929 ( network_sup PGUID 11 f t f 2 f 16 "869 869" 100 0 0 100 network_sup - ));
2163 DESCR("is-supernet");
2164 DATA(insert OID = 930 ( network_supeq PGUID 11 f t f 2 f 16 "869 869" 100 0 0 100 network_supeq - ));
2165 DESCR("is-supernet-or-equal");
2167 /* inet/cidr versions */
2168 DATA(insert OID = 940 ( network_netmask PGUID 11 f t f 1 f 25 "869" 100 0 0 100 network_netmask - ));
2169 DESCR("netmask of address");
2170 DATA(insert OID = 941 ( network_masklen PGUID 11 f t f 1 f 23 "869" 100 0 0 100 network_masklen - ));
2171 DESCR("netmask length");
2172 DATA(insert OID = 945 ( network_broadcast PGUID 11 f t f 1 f 25 "869" 100 0 0 100 network_broadcast - ));
2173 DESCR("broadcast address");
2174 DATA(insert OID = 682 ( network_host PGUID 11 f t f 1 f 25 "869" 100 0 0 100 network_host - ));
2175 DESCR("host address");
2176 DATA(insert OID = 473 ( network_network PGUID 11 f t f 1 f 25 "869" 100 0 0 100 network_network - ));
2177 DESCR("network address");
2179 /* shortcut names */
2180 DATA(insert OID = 696 ( netmask PGUID 11 f t f 1 f 25 "869" 100 0 0 100 network_netmask - ));
2181 DESCR("netmask of address");
2182 DATA(insert OID = 697 ( masklen PGUID 11 f t f 1 f 23 "869" 100 0 0 100 network_masklen - ));
2183 DESCR("netmask length");
2184 DATA(insert OID = 698 ( broadcast PGUID 11 f t f 1 f 25 "869" 100 0 0 100 network_broadcast - ));
2185 DESCR("broadcast address");
2186 DATA(insert OID = 699 ( host PGUID 11 f t f 1 f 25 "869" 100 0 0 100 network_host - ));
2187 DESCR("host address");
2188 DATA(insert OID = 683 ( network PGUID 11 f t f 1 f 25 "869" 100 0 0 100 network_network - ));
2189 DESCR("network address");
2191 /* OID's 1700 - 1799 NUMERIC data type */
2192 DATA(insert OID = 1701 ( numeric_in PGUID 11 f t f 1 f 1700 "0" 100 0 0 100 numeric_in - ));
2193 DESCR("(internal)");
2194 DATA(insert OID = 1702 ( numeric_out PGUID 11 f t f 1 f 23 "0" 100 0 0 100 numeric_out - ));
2195 DESCR("(internal)");
2196 DATA(insert OID = 1703 ( numeric PGUID 11 f t f 2 f 1700 "1700 23" 100 0 0 100 numeric - ));
2197 DESCR("(internal)");
2198 DATA(insert OID = 1704 ( numeric_abs PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100 numeric_abs - ));
2199 DESCR("absolute value");
2200 DATA(insert OID = 1705 ( abs PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100 numeric_abs - ));
2201 DESCR("absolute value");
2202 DATA(insert OID = 1706 ( numeric_sign PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100 numeric_sign - ));
2203 DESCR("sign of value");
2204 DATA(insert OID = 1707 ( sign PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100 numeric_sign - ));
2205 DESCR("sign of value");
2206 DATA(insert OID = 1708 ( numeric_round PGUID 11 f t f 2 f 1700 "1700 23" 100 0 0 100 numeric_round - ));
2207 DESCR("value rounded to 'scale'");
2208 DATA(insert OID = 1709 ( round PGUID 11 f t f 2 f 1700 "1700 23" 100 0 0 100 numeric_round - ));
2209 DESCR("value rounded to 'scale'");
2210 DATA(insert OID = 1710 ( round PGUID 14 f t f 1 f 1700 "1700" 100 0 0 100 "select numeric_round($1,0)" - ));
2211 DESCR("value rounded to 'scale' of zero");
2212 DATA(insert OID = 1711 ( numeric_trunc PGUID 11 f t f 2 f 1700 "1700 23" 100 0 0 100 numeric_trunc - ));
2213 DESCR("value truncated to 'scale'");
2214 DATA(insert OID = 1712 ( trunc PGUID 11 f t f 2 f 1700 "1700 23" 100 0 0 100 numeric_trunc - ));
2215 DESCR("value truncated to 'scale'");
2216 DATA(insert OID = 1713 ( trunc PGUID 14 f t f 1 f 1700 "1700" 100 0 0 100 "select numeric_trunc($1,0)" - ));
2217 DESCR("value truncated to 'scale' of zero");
2218 DATA(insert OID = 1714 ( numeric_ceil PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100 numeric_ceil - ));
2219 DESCR("smallest integer >= value");
2220 DATA(insert OID = 1715 ( ceil PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100 numeric_ceil - ));
2221 DESCR("smallest integer >= value");
2222 DATA(insert OID = 1716 ( numeric_floor PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100 numeric_floor - ));
2223 DESCR("largest integer <= value");
2224 DATA(insert OID = 1717 ( floor PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100 numeric_floor - ));
2225 DESCR("largest integer <= value");
2226 DATA(insert OID = 1718 ( numeric_eq PGUID 11 f t f 2 f 16 "1700 1700" 100 0 0 100 numeric_eq - ));
2228 DATA(insert OID = 1719 ( numeric_ne PGUID 11 f t f 2 f 16 "1700 1700" 100 0 0 100 numeric_ne - ));
2230 DATA(insert OID = 1720 ( numeric_gt PGUID 11 f t f 2 f 16 "1700 1700" 100 0 0 100 numeric_gt - ));
2231 DESCR("greater-than");
2232 DATA(insert OID = 1721 ( numeric_ge PGUID 11 f t f 2 f 16 "1700 1700" 100 0 0 100 numeric_ge - ));
2233 DESCR("greater-than-or-equal");
2234 DATA(insert OID = 1722 ( numeric_lt PGUID 11 f t f 2 f 16 "1700 1700" 100 0 0 100 numeric_lt - ));
2235 DESCR("lower-than");
2236 DATA(insert OID = 1723 ( numeric_le PGUID 11 f t f 2 f 16 "1700 1700" 100 0 0 100 numeric_le - ));
2237 DESCR("lower-than-or-equal");
2238 DATA(insert OID = 1724 ( numeric_add PGUID 11 f t f 2 f 1700 "1700 1700" 100 0 0 100 numeric_add - ));
2240 DATA(insert OID = 1725 ( numeric_sub PGUID 11 f t f 2 f 1700 "1700 1700" 100 0 0 100 numeric_sub - ));
2242 DATA(insert OID = 1726 ( numeric_mul PGUID 11 f t f 2 f 1700 "1700 1700" 100 0 0 100 numeric_mul - ));
2244 DATA(insert OID = 1727 ( numeric_div PGUID 11 f t f 2 f 1700 "1700 1700" 100 0 0 100 numeric_div - ));
2246 DATA(insert OID = 1728 ( numeric_mod PGUID 11 f t f 2 f 1700 "1700 1700" 100 0 0 100 numeric_mod - ));
2248 DATA(insert OID = 1729 ( mod PGUID 11 f t f 2 f 1700 "1700 1700" 100 0 0 100 numeric_mod - ));
2250 DATA(insert OID = 1730 ( numeric_sqrt PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100 numeric_sqrt - ));
2251 DESCR("square root");
2252 DATA(insert OID = 1731 ( sqrt PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100 numeric_sqrt - ));
2253 DESCR("square root");
2254 DATA(insert OID = 1732 ( numeric_exp PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100 numeric_exp - ));
2255 DESCR("e raised to the power of n");
2256 DATA(insert OID = 1733 ( exp PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100 numeric_exp - ));
2257 DESCR("e raised to the power of n");
2258 DATA(insert OID = 1734 ( numeric_ln PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100 numeric_ln - ));
2259 DESCR("natural logarithm of n");
2260 DATA(insert OID = 1735 ( ln PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100 numeric_ln - ));
2261 DESCR("natural logarithm of n");
2262 DATA(insert OID = 1736 ( numeric_log PGUID 11 f t f 2 f 1700 "1700 1700" 100 0 0 100 numeric_log - ));
2263 DESCR("logarithm base m of n");
2264 DATA(insert OID = 1737 ( log PGUID 11 f t f 2 f 1700 "1700 1700" 100 0 0 100 numeric_log - ));
2265 DESCR("logarithm base m of n");
2266 DATA(insert OID = 1738 ( numeric_power PGUID 11 f t f 2 f 1700 "1700 1700" 100 0 0 100 numeric_power - ));
2267 DESCR("m raised to the power of n");
2268 DATA(insert OID = 1739 ( power PGUID 11 f t f 2 f 1700 "1700 1700" 100 0 0 100 numeric_power - ));
2269 DESCR("m raised to the power of n");
2270 DATA(insert OID = 1740 ( int4_numeric PGUID 11 f t f 1 f 1700 "23" 100 0 0 100 int4_numeric - ));
2271 DESCR("(internal)");
2272 DATA(insert OID = 1741 ( numeric PGUID 11 f t f 1 f 1700 "23" 100 0 0 100 int4_numeric - ));
2273 DESCR("(internal)");
2274 DATA(insert OID = 1742 ( float4_numeric PGUID 11 f t f 1 f 1700 "700" 100 0 0 100 float4_numeric - ));
2275 DESCR("(internal)");
2276 DATA(insert OID = 1743 ( numeric PGUID 11 f t f 1 f 1700 "700" 100 0 0 100 float4_numeric - ));
2277 DESCR("(internal)");
2278 DATA(insert OID = 1744 ( float8_numeric PGUID 11 f t f 1 f 1700 "701" 100 0 0 100 float8_numeric - ));
2279 DESCR("(internal)");
2280 DATA(insert OID = 1745 ( numeric PGUID 11 f t f 1 f 1700 "701" 100 0 0 100 float8_numeric - ));
2281 DESCR("(internal)");
2282 DATA(insert OID = 1746 ( numeric_int4 PGUID 11 f t f 1 f 23 "1700" 100 0 0 100 numeric_int4 - ));
2283 DESCR("(internal)");
2284 DATA(insert OID = 1747 ( int4 PGUID 11 f t f 1 f 23 "1700" 100 0 0 100 numeric_int4 - ));
2285 DESCR("(internal)");
2286 DATA(insert OID = 1748 ( numeric_float4 PGUID 11 f t f 1 f 700 "1700" 100 0 0 100 numeric_float4 - ));
2287 DESCR("(internal)");
2288 DATA(insert OID = 1749 ( float4 PGUID 11 f t f 1 f 700 "1700" 100 0 0 100 numeric_float4 - ));
2289 DESCR("(internal)");
2290 DATA(insert OID = 1750 ( numeric_float8 PGUID 11 f t f 1 f 701 "1700" 100 0 0 100 numeric_float8 - ));
2291 DESCR("(internal)");
2292 DATA(insert OID = 1751 ( float8 PGUID 11 f t f 1 f 701 "1700" 100 0 0 100 numeric_float8 - ));
2293 DESCR("(internal)");
2294 DATA(insert OID = 1764 ( numeric_inc PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100 numeric_inc - ));
2295 DESCR("increment by one");
2296 DATA(insert OID = 1765 ( numeric_dec PGUID 11 f t f 1 f 1700 "1700" 100 0 0 100 numeric_dec - ));
2297 DESCR("decrement by one");
2298 DATA(insert OID = 1766 ( numeric_smaller PGUID 11 f t f 2 f 1700 "1700 1700" 100 0 0 100 numeric_smaller - ));
2299 DESCR("smaller of two numbers");
2300 DATA(insert OID = 1767 ( numeric_larger PGUID 11 f t f 2 f 1700 "1700 1700" 100 0 0 100 numeric_larger - ));
2301 DESCR("larger of two numbers");
2305 * prototypes for functions pg_proc.c
2307 extern Oid ProcedureCreate(char *procedureName,
2309 char *returnTypeName,
2323 #endif /* PG_PROC_H */