New to ecb, using cedet-1.0beta1c with ecb 2.xx:
When I open the following source it feels like I trigger
an n-squared behavior because the progress bar starts
growing initially as quickly as in other typical files
and then becomes increasingly slow. Even after the bar
reaches the right hand delimiter emacs remains locked
in a compute-bound state for a minute or more.
Is there anything I can do to ameliorate this situation?
(My emacs configuration treats .h headers as c++ in case
that is relevant. My gc-cons-threshold is 5*10**7.)
/john
/*-----------------------------------------------------------------------=
--
*
* pg_proc.h
* definition of the system "procedure" relation (pg_proc)
* along with the relation's initial contents.
*
* Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
* Portions Copyright (c) 1994, Regents of the University of California
*
* $Id: pg_proc.h,v 1.70 2004/01/09 23:57:59 jballard Exp $
*
* NOTES
* The script catalog/genbki.sh reads this file and generates .bki
* information from the DATA() statements. utils/Gen_fmgrtab.sh
* generates fmgroids.h and fmgrtab.c the same way.
*
* XXX do NOT break up DATA() statements into multiple lines!
* the scripts are not as smart as you might think...
* XXX (eg. #if 0 #endif won't do what you think)
*
=
*------------------------------------------------------------------------=
-
*/
#ifndef PG_PROC_H
#define PG_PROC_H
#include "tcop/dest.h"
/* ----------------
* postgres.h contains the system type definintions and the
* CATALOG(), BOOTSTRAP and DATA() sugar words so this file
* can be read by both genbki.sh and the C compiler.
* ----------------
*/
/* ----------------
* pg_proc definition. cpp turns this into
* typedef struct FormData_pg_proc
* ----------------
*/
CATALOG(_t_proc) BOOTSTRAP
{
NameData proname;
int4 proowner;
Oid prolang;
bool proisinh;
bool proistrusted;
bool proiscachable;
bool proisstrict;
int2 pronargs;
bool proretset;
Oid prorettype;
oidvector proargtypes;
int4 probyte_pct;
int4 properbyte_cpu;
int4 propercall_cpu;
int4 prooutin_ratio;
text prosrc; /* VARIABLE LENGTH FIELD */
bytea probin; /* VARIABLE LENGTH FIELD */
text prosizer; /* VARIABLE LENGTH FIELD */
} FormData_pg_proc;
/* ----------------
* Form_pg_proc corresponds to a pointer to a tuple with
* the format of pg_proc relation.
* ----------------
*/
typedef FormData_pg_proc *Form_pg_proc;
/* ----------------
* compiler constants for pg_proc
* ----------------
*/
#define Natts_pg_proc 18
#define Anum_pg_proc_proname 1
#define Anum_pg_proc_proowner 2
#define Anum_pg_proc_prolang 3
#define Anum_pg_proc_proisinh 4
#define Anum_pg_proc_proistrusted 5
#define Anum_pg_proc_proiscachable 6
#define Anum_pg_proc_proisstrict 7
#define Anum_pg_proc_pronargs 8
#define Anum_pg_proc_proretset 9
#define Anum_pg_proc_prorettype 10
#define Anum_pg_proc_proargtypes 11
#define Anum_pg_proc_probyte_pct 12
#define Anum_pg_proc_properbyte_cpu 13
#define Anum_pg_proc_propercall_cpu 14
#define Anum_pg_proc_prooutin_ratio 15
#define Anum_pg_proc_prosrc 16
#define Anum_pg_proc_probin 17
#define Anum_pg_proc_prosizer 18
/* ----------------
* initial contents of pg_proc
* ----------------
*/
/* keep the following ordered by OID so that later changes can be made =
easier */
/* OIDS 1 - 99 */
DATA(insert OID =3D 1242 ( boolin PGUID 12 f t t t 1 f 16 "0" =
100 0 0 100 boolin - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1243 ( boolout PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 boolout - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1244 ( byteain PGUID 12 f t t t 1 f 17 "0" =
100 0 0 100 byteain - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 31 ( byteaout PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 byteaout - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1245 ( charin PGUID 12 f t t t 1 f 18 "0" =
100 0 0 100 charin - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 33 ( charout PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 charout - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 34 ( namein PGUID 12 f t t t 1 f 19 "0" =
100 0 0 100 namein - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 35 ( nameout PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 nameout - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 38 ( int2in PGUID 12 f t t t 1 f 21 "0" =
100 0 0 100 int2in - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 39 ( int2out PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 int2out - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 40 ( int2vectorin PGUID 12 f t t t 1 f 22 "0" =
100 0 0 100 int2vectorin - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 41 ( int2vectorout PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 int2vectorout - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 42 ( int4in PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 int4in - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 43 ( int4out PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 int4out - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 44 ( regprocin PGUID 12 f t f t 1 f 24 "0" =
100 0 0 100 regprocin - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 45 ( regprocout PGUID 12 f t f t 1 f 23 "0" =
100 0 0 100 regprocout - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 46 ( textin PGUID 12 f t t t 1 f 25 "0" =
100 0 0 100 textin - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 47 ( textout PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 textout - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 48 ( tidin PGUID 12 f t t t 1 f 27 "0" =
100 0 0 100 tidin - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 49 ( tidout PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 tidout - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 50 ( xidin PGUID 12 f t t t 1 f 28 "0" =
100 0 0 100 xidin - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 51 ( xidout PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 xidout - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 52 ( cidin PGUID 12 f t t t 1 f 29 "0" =
100 0 0 100 cidin - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 53 ( cidout PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 cidout - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 54 ( oidvectorin PGUID 12 f t t t 1 f 30 "0" =
100 0 0 100 oidvectorin - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 55 ( oidvectorout PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 oidvectorout - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 56 ( boollt PGUID 12 f t t t 2 f 16 "16 =
16" 100 0 0 100 boollt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 57 ( boolgt PGUID 12 f t t t 2 f 16 "16 =
16" 100 0 0 100 boolgt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 60 ( booleq PGUID 12 f t t t 2 f 16 "16 =
16" 100 0 0 100 booleq - 0 ));
DESCR("equal");
DATA(insert OID =3D 61 ( chareq PGUID 12 f t t t 2 f 16 "18 =
18" 100 0 0 100 chareq - 0 ));
DESCR("equal");
DATA(insert OID =3D 62 ( nameeq PGUID 12 f t t t 2 f 16 "19 =
19" 100 0 0 100 nameeq - 0 ));
DESCR("equal");
DATA(insert OID =3D 63 ( int2eq PGUID 12 f t t t 2 f 16 "21 =
21" 100 0 0 100 int2eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 64 ( int2lt PGUID 12 f t t t 2 f 16 "21 =
21" 100 0 0 100 int2lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 65 ( int4eq PGUID 12 f t t t 2 f 16 "23 =
23" 100 0 0 100 int4eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 66 ( int4lt PGUID 12 f t t t 2 f 16 "23 =
23" 100 0 0 100 int4lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 67 ( texteq PGUID 12 f t t t 2 f 16 "25 =
25" 100 0 0 100 texteq - 0 ));
DESCR("equal");
DATA(insert OID =3D 68 ( xideq PGUID 12 f t t t 2 f 16 "28 =
28" 100 0 0 100 xideq - 0 ));
DESCR("equal");
DATA(insert OID =3D 69 ( cideq PGUID 12 f t t t 2 f 16 "29 =
29" 100 0 0 100 cideq - 0 ));
DESCR("equal");
DATA(insert OID =3D 70 ( charne PGUID 12 f t t t 2 f 16 "18 =
18" 100 0 0 100 charne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 1246 ( charlt PGUID 12 f t t t 2 f 16 "18 =
18" 100 0 0 100 charlt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 72 ( charle PGUID 12 f t t t 2 f 16 "18 =
18" 100 0 0 100 charle - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 73 ( chargt PGUID 12 f t t t 2 f 16 "18 =
18" 100 0 0 100 chargt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 74 ( charge PGUID 12 f t t t 2 f 16 "18 =
18" 100 0 0 100 charge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 1248 ( charpl PGUID 12 f t t t 2 f 18 "18 =
18" 100 0 0 100 charpl - 0 ));
DESCR("add");
DATA(insert OID =3D 1250 ( charmi PGUID 12 f t t t 2 f 18 "18 =
18" 100 0 0 100 charmi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 77 ( charmul PGUID 12 f t t t 2 f 18 "18 =
18" 100 0 0 100 charmul - 0 ));
DESCR("multiply");
DATA(insert OID =3D 78 ( chardiv PGUID 12 f t t t 2 f 18 "18 =
18" 100 0 0 100 chardiv - 0 ));
DESCR("divide");
DATA(insert OID =3D 79 ( nameregexeq PGUID 12 f t t t 2 f 16 "19 =
25" 100 0 0 100 nameregexeq - 0 ));
DESCR("matches regex., case-sensitive");
DATA(insert OID =3D 1252 ( nameregexne PGUID 12 f t t t 2 f 16 "19 =
25" 100 0 0 100 nameregexne - 0 ));
DESCR("does not match regex., case-sensitive");
DATA(insert OID =3D 1254 ( textregexeq PGUID 12 f t t t 2 f 16 "25 =
25" 100 0 0 100 textregexeq - 0 ));
DESCR("matches regex., case-sensitive");
DATA(insert OID =3D 1256 ( textregexne PGUID 12 f t t t 2 f 16 "25 =
25" 100 0 0 100 textregexne - 0 ));
DESCR("does not match regex., case-sensitive");
DATA(insert OID =3D 1257 ( textlen PGUID 12 f t t t 1 f 23 =
"25" 100 0 0 100 textlen - 0 ));
DESCR("length");
DATA(insert OID =3D 1258 ( varcharcat PGUID 12 f t t t 2 f 1043 =
"1043 1043" 100 0 0 100 varcharcat - varcharcat_sizer ));
DESCR("concatenate");
DATA(insert OID =3D 1180 ( textcat PGUID 12 f t t t 2 f 25 "25 =
25" 100 0 0 100 textcat - to_text_sizer ));
DESCR("concatenate");
DATA(insert OID =3D 84 ( boolne PGUID 12 f t t t 2 f 16 "16 =
16" 100 0 0 100 boolne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 89 ( version PGUID 12 f t f t 0 f 1043 =
"" 100 0 0 100 pgsql_version - wag_sizer ));
DESCR("Netezza SQL version string");
DATA(insert OID =3D 1265 ( rtcostestimate PGUID 12 f t f t 7 f 0 "0 0 =
0 0 0 0 0" 100 0 0 100 rtcostestimate - 0 ));
DESCR("r-tree cost estimator");
DATA(insert OID =3D 1268 ( btcostestimate PGUID 12 f t f t 7 f 0 "0 0 =
0 0 0 0 0" 100 0 0 100 btcostestimate - 0 ));
DESCR("btree cost estimator");
/* OIDS 100 - 199 */
DATA(insert OID =3D 100 ( int8fac PGUID 12 f t t t 1 f 20 =
"20" 100 0 0 100 int8fac - 0 ));
DESCR("factorial");
DATA(insert OID =3D 101 ( eqsel PGUID 12 f t f t 5 f 701 =
"26 26 21 0 23" 100 0 0 100 eqsel - 0 ));
DESCR("restriction selectivity of =3D and related operators");
DATA(insert OID =3D 102 ( neqsel PGUID 12 f t f t 5 f 701 =
"26 26 21 0 23" 100 0 0 100 neqsel - 0 ));
DESCR("restriction selectivity of <> and related operators");
DATA(insert OID =3D 103 ( scalarltsel PGUID 12 f t f t 5 f 701 =
"26 26 21 0 23" 100 0 0 100 scalarltsel - 0 ));
DESCR("restriction selectivity of < and related operators on scalar =
datatypes");
DATA(insert OID =3D 104 ( scalargtsel PGUID 12 f t f t 5 f 701 =
"26 26 21 0 23" 100 0 0 100 scalargtsel - 0 ));
DESCR("restriction selectivity of > and related operators on scalar =
datatypes");
DATA(insert OID =3D 105 ( eqjoinsel PGUID 12 f t f t 5 f 701 =
"26 26 21 26 21" 100 0 0 100 eqjoinsel - 0 ));
DESCR("join selectivity of =3D and related operators");
DATA(insert OID =3D 106 ( neqjoinsel PGUID 12 f t f t 5 f 701 =
"26 26 21 26 21" 100 0 0 100 neqjoinsel - 0 ));
DESCR("join selectivity of <> and related operators");
DATA(insert OID =3D 107 ( scalarltjoinsel PGUID 12 f t f t 5 f 701 =
"26 26 21 26 21" 100 0 0 100 scalarltjoinsel - 0 ));
DESCR("join selectivity of < and related operators on scalar =
datatypes");
DATA(insert OID =3D 108 ( scalargtjoinsel PGUID 12 f t f t 5 f 701 =
"26 26 21 26 21" 100 0 0 100 scalargtjoinsel - 0 ));
DESCR("join selectivity of > and related operators on scalar =
datatypes");
DATA(insert OID =3D 114 ( text PGUID 12 f t t t 1 f 25 =
"26" 100 0 0 100 oid_text - int4_text_sizer ));
DESCR("convert oid to text");
DATA(insert OID =3D 141 ( int4mul PGUID 12 f t t t 2 f 23 "23 =
23" 100 0 0 100 int4mul - 0 ));
DESCR("multiply");
DATA(insert OID =3D 142 ( int4fac PGUID 12 f t t t 1 f 20 =
"23" 100 0 0 100 int4fac - 0 ));
DESCR("factorial");
DATA(insert OID =3D 144 ( int4ne PGUID 12 f t t t 2 f 16 "23 =
23" 100 0 0 100 int4ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 145 ( int2ne PGUID 12 f t t t 2 f 16 "21 =
21" 100 0 0 100 int2ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 146 ( int2gt PGUID 12 f t t t 2 f 16 "21 =
21" 100 0 0 100 int2gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 147 ( int4gt PGUID 12 f t t t 2 f 16 "23 =
23" 100 0 0 100 int4gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 148 ( int2le PGUID 12 f t t t 2 f 16 "21 =
21" 100 0 0 100 int2le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 149 ( int4le PGUID 12 f t t t 2 f 16 "23 =
23" 100 0 0 100 int4le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 150 ( int4ge PGUID 12 f t t t 2 f 16 "23 =
23" 100 0 0 100 int4ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 151 ( int2ge PGUID 12 f t t t 2 f 16 "21 =
21" 100 0 0 100 int2ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 152 ( int2mul PGUID 12 f t t t 2 f 21 "21 =
21" 100 0 0 100 int2mul - 0 ));
DESCR("multiply");
DATA(insert OID =3D 153 ( int2div PGUID 12 f t t t 2 f 21 "21 =
21" 100 0 0 100 int2div - 0 ));
DESCR("divide");
DATA(insert OID =3D 154 ( int4div PGUID 12 f t t t 2 f 23 "23 =
23" 100 0 0 100 int4div - 0 ));
DESCR("divide");
DATA(insert OID =3D 155 ( int2mod PGUID 12 f t t t 2 f 21 "21 =
21" 100 0 0 100 int2mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 156 ( int4mod PGUID 12 f t t t 2 f 23 "23 =
23" 100 0 0 100 int4mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 157 ( textne PGUID 12 f t t t 2 f 16 "25 =
25" 100 0 0 100 textne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 158 ( int24eq PGUID 12 f t t t 2 f 16 "21 =
23" 100 0 0 100 int24eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 159 ( int42eq PGUID 12 f t t t 2 f 16 "23 =
21" 100 0 0 100 int42eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 160 ( int24lt PGUID 12 f t t t 2 f 16 "21 =
23" 100 0 0 100 int24lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 161 ( int42lt PGUID 12 f t t t 2 f 16 "23 =
21" 100 0 0 100 int42lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 162 ( int24gt PGUID 12 f t t t 2 f 16 "21 =
23" 100 0 0 100 int24gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 163 ( int42gt PGUID 12 f t t t 2 f 16 "23 =
21" 100 0 0 100 int42gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 164 ( int24ne PGUID 12 f t t t 2 f 16 "21 =
23" 100 0 0 100 int24ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 165 ( int42ne PGUID 12 f t t t 2 f 16 "23 =
21" 100 0 0 100 int42ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 166 ( int24le PGUID 12 f t t t 2 f 16 "21 =
23" 100 0 0 100 int24le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 167 ( int42le PGUID 12 f t t t 2 f 16 "23 =
21" 100 0 0 100 int42le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 168 ( int24ge PGUID 12 f t t t 2 f 16 "21 =
23" 100 0 0 100 int24ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 169 ( int42ge PGUID 12 f t t t 2 f 16 "23 =
21" 100 0 0 100 int42ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 170 ( int24mul PGUID 12 f t t t 2 f 23 "21 =
23" 100 0 0 100 int24mul - 0 ));
DESCR("multiply");
DATA(insert OID =3D 171 ( int42mul PGUID 12 f t t t 2 f 23 "23 =
21" 100 0 0 100 int42mul - 0 ));
DESCR("multiply");
DATA(insert OID =3D 172 ( int24div PGUID 12 f t t t 2 f 23 "21 =
23" 100 0 0 100 int24div - 0 ));
DESCR("divide");
DATA(insert OID =3D 173 ( int42div PGUID 12 f t t t 2 f 23 "23 =
21" 100 0 0 100 int42div - 0 ));
DESCR("divide");
DATA(insert OID =3D 174 ( int24mod PGUID 12 f t t t 2 f 23 "21 =
23" 100 0 0 100 int24mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 175 ( int42mod PGUID 12 f t t t 2 f 23 "23 =
21" 100 0 0 100 int42mod - 0 ));
DESCR("modulus");
/* conditional on JB_INTEGER_MATH_CHANGE =20
* DATA(insert OID =3D 176 ( int2pl PGUID 12 f t t t 2 f 20 =
"21 21" 100 0 0 100 int2pl - intpl_sizer ));
* DESCR("add");
* DATA(insert OID =3D 177 ( int4pl PGUID 12 f t t t 2 f 20 =
"23 23" 100 0 0 100 int4pl - intpl_sizer ));
* DESCR("add");
* DATA(insert OID =3D 178 ( int24pl PGUID 12 f t t t 2 f 20 "21 =
23" 100 0 0 100 int24pl - intpl_sizer ));
* DESCR("add");
* DATA(insert OID =3D 179 ( int42pl PGUID 12 f t t t 2 f 20 "23 =
21" 100 0 0 100 int42pl - intpl_sizer ));
* DESCR("add");
*/=20
DATA(insert OID =3D 176 ( int2pl PGUID 12 f t t t 2 f 21 "21 =
21" 100 0 0 100 int2pl - 0 ));
DESCR("add");
DATA(insert OID =3D 177 ( int4pl PGUID 12 f t t t 2 f 23 "23 =
23" 100 0 0 100 int4pl - 0 ));
DESCR("add");
DATA(insert OID =3D 178 ( int24pl PGUID 12 f t t t 2 f 23 "21 =
23" 100 0 0 100 int24pl - 0 ));
DESCR("add");
DATA(insert OID =3D 179 ( int42pl PGUID 12 f t t t 2 f 23 "23 =
21" 100 0 0 100 int42pl - 0 ));
DESCR("add");
DATA(insert OID =3D 180 ( int2mi PGUID 12 f t t t 2 f 21 "21 =
21" 100 0 0 100 int2mi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 181 ( int4mi PGUID 12 f t t t 2 f 23 "23 =
23" 100 0 0 100 int4mi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 182 ( int24mi PGUID 12 f t t t 2 f 23 "21 =
23" 100 0 0 100 int24mi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 183 ( int42mi PGUID 12 f t t t 2 f 23 "23 =
21" 100 0 0 100 int42mi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 184 ( oideq PGUID 12 f t t t 2 f 16 "26 =
26" 100 0 0 100 oideq - 0 ));
DESCR("equal");
DATA(insert OID =3D 185 ( oidne PGUID 12 f t t t 2 f 16 "26 =
26" 100 0 0 100 oidne - 0 ));
DESCR("not equal");
/* OIDS 200 - 299 */
DATA(insert OID =3D 200 ( float4in PGUID 12 f t t t 1 f 700 =
"0" 100 0 0 100 float4in - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 201 ( float4out PGUID 12 f t t t 1 f 23 =
"700" 100 0 0 100 float4out - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 202 ( float4mul PGUID 12 f t t t 2 f 700 =
"700 700" 100 0 0 100 float4mul - 0 ));
DESCR("multiply");
DATA(insert OID =3D 203 ( float4div PGUID 12 f t t t 2 f 700 =
"700 700" 100 0 0 100 float4div - 0 ));
DESCR("divide");
DATA(insert OID =3D 204 ( float4pl PGUID 12 f t t t 2 f 700 =
"700 700" 100 0 0 100 float4pl - 0 ));
DESCR("add");
DATA(insert OID =3D 205 ( float4mi PGUID 12 f t t t 2 f 700 =
"700 700" 100 0 0 100 float4mi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 206 ( float4um PGUID 12 f t t t 1 f 700 =
"700" 100 0 0 100 float4um - 0 ));
DESCR("negate");
DATA(insert OID =3D 207 ( float4abs PGUID 12 f t t t 1 f 700 =
"700" 100 0 0 100 float4abs - 0 ));
DESCR("absolute value");
DATA(insert OID =3D 208 ( float4_accum PGUID 12 f t t t 2 f 1022 =
"1022 700" 100 0 0 100 float4_accum - 0 ));
DESCR("aggregate transition function");
DATA(insert OID =3D 209 ( float4larger PGUID 12 f t t t 2 f 700 =
"700 700" 100 0 0 100 float4larger - 0 ));
DESCR("larger of two");
DATA(insert OID =3D 211 ( float4smaller PGUID 12 f t t t 2 f 700 =
"700 700" 100 0 0 100 float4smaller - 0 ));
DESCR("smaller of two");
DATA(insert OID =3D 212 ( int4um PGUID 12 f t t t 1 f 23 =
"23" 100 0 0 100 int4um - 0 ));
DESCR("negate");
DATA(insert OID =3D 213 ( int2um PGUID 12 f t t t 1 f 21 =
"21" 100 0 0 100 int2um - 0 ));
DESCR("negate");
DATA(insert OID =3D 214 ( float8in PGUID 12 f t t t 1 f 701 =
"0" 100 0 0 100 float8in - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 215 ( float8out PGUID 12 f t t t 1 f 23 =
"701" 100 0 0 100 float8out - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 216 ( float8mul PGUID 12 f t t t 2 f 701 =
"701 701" 100 0 0 100 float8mul - 0 ));
DESCR("multiply");
DATA(insert OID =3D 217 ( float8div PGUID 12 f t t t 2 f 701 =
"701 701" 100 0 0 100 float8div - 0 ));
DESCR("divide");
DATA(insert OID =3D 218 ( float8pl PGUID 12 f t t t 2 f 701 =
"701 701" 100 0 0 100 float8pl - 0 ));
DESCR("add");
DATA(insert OID =3D 219 ( float8mi PGUID 12 f t t t 2 f 701 =
"701 701" 100 0 0 100 float8mi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 220 ( float8um PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 float8um - 0 ));
DESCR("negate");
DATA(insert OID =3D 221 ( float8abs PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 float8abs - 0 ));
DESCR("absolute value");
DATA(insert OID =3D 222 ( float8_accum PGUID 12 f t t t 2 f 1022 =
"1022 701" 100 0 0 100 float8_accum - 0 ));
DESCR("aggregate transition function");
DATA(insert OID =3D 223 ( float8larger PGUID 12 f t t t 2 f 701 =
"701 701" 100 0 0 100 float8larger - 0 ));
DESCR("larger of two");
DATA(insert OID =3D 224 ( float8smaller PGUID 12 f t t t 2 f 701 =
"701 701" 100 0 0 100 float8smaller - 0 ));
DESCR("smaller of two");
DATA(insert OID =3D 228 ( dround PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 dround - 0 ));
DESCR("round to nearest integer");
DATA(insert OID =3D 229 ( dtrunc PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 dtrunc - 0 ));
DESCR("truncate to integer");
DATA(insert OID =3D 230 ( dsqrt PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 dsqrt - 0 ));
DESCR("square root");
DATA(insert OID =3D 232 ( dpow PGUID 12 f t t t 2 f 701 =
"701 701" 100 0 0 100 dpow - 0 ));
DESCR("exponentiation (x^y)");
DATA(insert OID =3D 233 ( dexp PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 dexp - 0 ));
DESCR("natural exponential (e^x)");
DATA(insert OID =3D 234 ( dlog1 PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 dlog1 - 0 ));
DESCR("natural logarithm");
DATA(insert OID =3D 235 ( float8 PGUID 12 f t t t 1 f 701 =
"21" 100 0 0 100 i2tod - 0 ));
DESCR("convert int2 to float8");
DATA(insert OID =3D 236 ( float4 PGUID 12 f t t t 1 f 700 =
"21" 100 0 0 100 i2tof - 0 ));
DESCR("convert int2 to float4");
DATA(insert OID =3D 237 ( int2 PGUID 12 f t t t 1 f 21 =
"701" 100 0 0 100 dtoi2 - 0 ));
DESCR("convert float8 to int2");
DATA(insert OID =3D 238 ( int2 PGUID 12 f t t t 1 f 21 =
"700" 100 0 0 100 ftoi2 - 0 ));
DESCR("convert float4 to int2");
DATA(insert OID =3D 240 ( nabstimein PGUID 12 f t f t 1 f 702 =
"0" 100 0 0 100 nabstimein - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 241 ( nabstimeout PGUID 12 f t f t 1 f 23 =
"0" 100 0 0 100 nabstimeout - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 244 ( timepl PGUID 12 f t f t 2 f 702 =
"702 703" 100 0 0 100 timepl - 0 ));
DESCR("add");
DATA(insert OID =3D 245 ( timemi PGUID 12 f t f t 2 f 702 =
"702 703" 100 0 0 100 timemi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 246 ( substr PGUID 12 f t t t 3 f 25 "25 =
23 23" 100 0 0 100 text_substr - substr_sizer ));
DESCR("return portion of text data");
DATA(insert OID =3D 247 ( substr PGUID 12 f t t t 2 f 25 "25 =
23" 100 0 0 100 text_substr - substr_sizer ));
DESCR("return portion of text data");
DATA(insert OID =3D 248 ( substring PGUID 12 f t t t 3 f 25 "25 =
23 23" 100 0 0 100 text_substr - substr_sizer ));
DESCR("return portion of text data");
DATA(insert OID =3D 249 ( substring PGUID 12 f t t t 2 f 25 "25 =
23" 100 0 0 100 text_substr - substr_sizer ));
DESCR("return portion of text data");
DATA(insert OID =3D 583 ( substr PGUID 12 f t t t 3 f 2568 =
"2568 23 23" 100 0 0 100 blob_substr - substr_sizer ));
DESCR("return portion of blob data");
DATA(insert OID =3D 676 ( substr PGUID 12 f t t t 2 f 2568 =
"2568 23" 100 0 0 100 blob_substr - substr_sizer ));
DESCR("return portion of blob data");
DATA(insert OID =3D 473 ( substring PGUID 12 f t t t 3 f 2568 =
"2568 23 23" 100 0 0 100 blob_substr - substr_sizer ));
DESCR("return portion of blob data");
DATA(insert OID =3D 566 ( substring PGUID 12 f t t t 2 f 2568 =
"2568 23" 100 0 0 100 blob_substr - substr_sizer ));
DESCR("return portion of blob data");
/* Removed until SubstNucl implemented in spubind.cpp
* Search for SUBSTR_NUCL_SUPPORT to find related code to enable
*
* run "duplicateoids" in pg/include/catalog after you enable this !!!
*
* and confirm that oids in pcodegen.h for these funcs are correct
*
* DATA(insert OID =3D 109 ( substr PGUID 12 f t t t 3 f =
2569 "2569 23 23" 100 0 0 100 nucl_substr - substr_sizer ));
* DESCR("return portion of nucleotide data");
* DATA(insert OID =3D 110 ( substr PGUID 12 f t t t 2 f =
2569 "2569 23" 100 0 0 100 nucl_substr - substr_sizer ));
* DESCR("return portion of nucleotide data");
* DATA(insert OID =3D 111 ( substring PGUID 12 f t t t 3 f =
2569 "2569 23 23" 100 0 0 100 nucl_substr - substr_sizer ));
* DESCR("return portion of nucleotide data");
* DATA(insert OID =3D 112 ( substring PGUID 12 f t t t 2 f =
2569 "2569 23" 100 0 0 100 nucl_substr - substr_sizer ));
* DESCR("return portion of nucleotide data");
*/
DATA(insert OID =3D 773 ( substr PGUID 12 f t t t 3 f 2570 =
"2570 23 23" 100 0 0 100 prot_substr - substr_sizer ));
DESCR("return portion of protein data");
DATA(insert OID =3D 886 ( substr PGUID 12 f t t t 2 f 2570 =
"2570 23" 100 0 0 100 prot_substr - substr_sizer ));
DESCR("return portion of protein data");
DATA(insert OID =3D 949 ( substring PGUID 12 f t t t 3 f 2570 =
"2570 23 23" 100 0 0 100 prot_substr - substr_sizer ));
DESCR("return portion of protein data");
DATA(insert OID =3D 973 ( substring PGUID 12 f t t t 2 f 2570 =
"2570 23" 100 0 0 100 prot_substr - substr_sizer ));
DESCR("return portion of protein' data");
DATA(insert OID =3D 1014 ( nucl PGUID 12 f t t t 1 f 2569 =
"25" 100 0 0 100 text_nucl - 0 ));
DESCR("convert text to nucleotide");
DATA(insert OID =3D 1015 ( text PGUID 12 f t t t 1 f 25 =
"2569" 100 0 0 100 nucl_text - to_text_sizer ));
DESCR("convert nucleotide to text");
DATA(insert OID =3D 1016 ( text PGUID 12 f t t t 1 f 2570 =
"25" 100 0 0 100 text_prot - 0 ));
DESCR("convert text to protein");
DATA(insert OID =3D 1017 ( text PGUID 12 f t t t 1 f 25 =
"2570" 100 0 0 100 prot_text - to_text_sizer ));
DESCR("convert protein to text");
DATA(insert OID =3D 1018 ( lower PGUID 12 f t t t 1 f 25 =
"25" 100 0 0 100 textlower - to_text_sizer ));
DESCR("lowercase");
DATA(insert OID =3D 250 ( timenow PGUID 12 f t f t 0 f 702 =
"0" 100 0 0 100 timenow - 0 ));
DESCR("Current date and time (abstime)");
DATA(insert OID =3D 251 ( abstimeeq PGUID 12 f t f t 2 f 16 =
"702 702" 100 0 0 100 abstimeeq - 0 ));
DESCR("equal");
DATA(insert OID =3D 252 ( abstimene PGUID 12 f t f t 2 f 16 =
"702 702" 100 0 0 100 abstimene - 0 ));
DESCR("not equal");
DATA(insert OID =3D 253 ( abstimelt PGUID 12 f t f t 2 f 16 =
"702 702" 100 0 0 100 abstimelt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 254 ( abstimegt PGUID 12 f t f t 2 f 16 =
"702 702" 100 0 0 100 abstimegt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 255 ( abstimele PGUID 12 f t f t 2 f 16 =
"702 702" 100 0 0 100 abstimele - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 256 ( abstimege PGUID 12 f t f t 2 f 16 =
"702 702" 100 0 0 100 abstimege - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 274 ( timeofday PGUID 12 f t f t 0 f 1043 =
"0" 100 0 0 100 timeofday - wag_sizer ));
DESCR("Current date and time with microseconds");
DATA(insert OID =3D 275 ( isfinite PGUID 12 f t f t 1 f 16 =
"702" 100 0 0 100 abstime_finite - 0 ));
DESCR("");
DATA(insert OID =3D 276 ( int2fac PGUID 12 f t t t 1 f 20 =
"21" 100 0 0 100 int2fac - 0 ));
DESCR("factorial");
DATA(insert OID =3D 279 ( float48mul PGUID 12 f t t t 2 f 701 =
"700 701" 100 0 0 100 float48mul - 0 ));
DESCR("multiply");
DATA(insert OID =3D 280 ( float48div PGUID 12 f t t t 2 f 701 =
"700 701" 100 0 0 100 float48div - 0 ));
DESCR("divide");
DATA(insert OID =3D 281 ( float48pl PGUID 12 f t t t 2 f 701 =
"700 701" 100 0 0 100 float48pl - 0 ));
DESCR("add");
DATA(insert OID =3D 282 ( float48mi PGUID 12 f t t t 2 f 701 =
"700 701" 100 0 0 100 float48mi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 283 ( float84mul PGUID 12 f t t t 2 f 701 =
"701 700" 100 0 0 100 float84mul - 0 ));
DESCR("multiply");
DATA(insert OID =3D 284 ( float84div PGUID 12 f t t t 2 f 701 =
"701 700" 100 0 0 100 float84div - 0 ));
DESCR("divide");
DATA(insert OID =3D 285 ( float84pl PGUID 12 f t t t 2 f 701 =
"701 700" 100 0 0 100 float84pl - 0 ));
DESCR("add");
DATA(insert OID =3D 286 ( float84mi PGUID 12 f t t t 2 f 701 =
"701 700" 100 0 0 100 float84mi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 287 ( float4eq PGUID 12 f t t t 2 f 16 =
"700 700" 100 0 0 100 float4eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 288 ( float4ne PGUID 12 f t t t 2 f 16 =
"700 700" 100 0 0 100 float4ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 289 ( float4lt PGUID 12 f t t t 2 f 16 =
"700 700" 100 0 0 100 float4lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 290 ( float4le PGUID 12 f t t t 2 f 16 =
"700 700" 100 0 0 100 float4le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 291 ( float4gt PGUID 12 f t t t 2 f 16 =
"700 700" 100 0 0 100 float4gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 292 ( float4ge PGUID 12 f t t t 2 f 16 =
"700 700" 100 0 0 100 float4ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 293 ( float8eq PGUID 12 f t t t 2 f 16 =
"701 701" 100 0 0 100 float8eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 294 ( float8ne PGUID 12 f t t t 2 f 16 =
"701 701" 100 0 0 100 float8ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 295 ( float8lt PGUID 12 f t t t 2 f 16 =
"701 701" 100 0 0 100 float8lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 296 ( float8le PGUID 12 f t t t 2 f 16 =
"701 701" 100 0 0 100 float8le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 297 ( float8gt PGUID 12 f t t t 2 f 16 =
"701 701" 100 0 0 100 float8gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 298 ( float8ge PGUID 12 f t t t 2 f 16 =
"701 701" 100 0 0 100 float8ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 299 ( float48eq PGUID 12 f t t t 2 f 16 =
"700 701" 100 0 0 100 float48eq - 0 ));
DESCR("equal");
/* OIDS 300 - 399 */
DATA(insert OID =3D 300 ( float48ne PGUID 12 f t t t 2 f 16 =
"700 701" 100 0 0 100 float48ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 301 ( float48lt PGUID 12 f t t t 2 f 16 =
"700 701" 100 0 0 100 float48lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 302 ( float48le PGUID 12 f t t t 2 f 16 =
"700 701" 100 0 0 100 float48le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 303 ( float48gt PGUID 12 f t t t 2 f 16 =
"700 701" 100 0 0 100 float48gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 304 ( float48ge PGUID 12 f t t t 2 f 16 =
"700 701" 100 0 0 100 float48ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 305 ( float84eq PGUID 12 f t t t 2 f 16 =
"701 700" 100 0 0 100 float84eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 306 ( float84ne PGUID 12 f t t t 2 f 16 =
"701 700" 100 0 0 100 float84ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 307 ( float84lt PGUID 12 f t t t 2 f 16 =
"701 700" 100 0 0 100 float84lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 308 ( float84le PGUID 12 f t t t 2 f 16 =
"701 700" 100 0 0 100 float84le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 309 ( float84gt PGUID 12 f t t t 2 f 16 =
"701 700" 100 0 0 100 float84gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 310 ( float84ge PGUID 12 f t t t 2 f 16 =
"701 700" 100 0 0 100 float84ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 311 ( float8 PGUID 12 f t t t 1 f 701 =
"700" 100 0 0 100 ftod - 0 ));
DESCR("convert float4 to float8");
DATA(insert OID =3D 312 ( float4 PGUID 12 f t t t 1 f 700 =
"701" 100 0 0 100 dtof - 0 ));
DESCR("convert float8 to float4");
DATA(insert OID =3D 313 ( int4 PGUID 12 f t t t 1 f 23 =
"21" 100 0 0 100 i2toi4 - 0 ));
DESCR("convert int2 to int4");
DATA(insert OID =3D 314 ( int2 PGUID 12 f t t t 1 f 21 =
"23" 100 0 0 100 i4toi2 - 0 ));
DESCR("convert int4 to int2");
DATA(insert OID =3D 315 ( int2vectoreq PGUID 12 f t t t 2 f 16 =
"22 22" 100 0 0 100 int2vectoreq - 0 ));
DESCR("equal");
DATA(insert OID =3D 316 ( float8 PGUID 12 f t t t 1 f 701 =
"23" 100 0 0 100 i4tod - 0 ));
DESCR("convert int4 to float8");
DATA(insert OID =3D 317 ( int4 PGUID 12 f t t t 1 f 23 =
"701" 100 0 0 100 dtoi4 - 0 ));
DESCR("convert float8 to int4");
DATA(insert OID =3D 318 ( float4 PGUID 12 f t t t 1 f 700 =
"23" 100 0 0 100 i4tof - 0 ));
DESCR("convert int4 to float4");
DATA(insert OID =3D 319 ( int4 PGUID 12 f t t t 1 f 23 =
"700" 100 0 0 100 ftoi4 - 0 ));
DESCR("convert float4 to int4");
DATA(insert OID =3D 320 ( rtinsert PGUID 12 f t f t 5 f 23 "0 =
0 0 0 0" 100 0 0 100 rtinsert - 0 ));
DESCR("r-tree(internal)");
DATA(insert OID =3D 321 ( rtdelete PGUID 12 f t f t 2 f 23 "0 =
0" 100 0 0 100 rtdelete - 0 ));
DESCR("r-tree(internal)");
DATA(insert OID =3D 322 ( rtgettuple PGUID 12 f t f t 2 f 23 "0 =
0" 100 0 0 100 rtgettuple - 0 ));
DESCR("r-tree(internal)");
DATA(insert OID =3D 323 ( rtbuild PGUID 12 f t f t 5 f 23 "0 =
0 0 0 0" 100 0 0 100 rtbuild - 0 ));
DESCR("r-tree(internal)");
DATA(insert OID =3D 324 ( rtbeginscan PGUID 12 f t f t 4 f 23 "0 =
0 0 0" 100 0 0 100 rtbeginscan - 0 ));
DESCR("r-tree(internal)");
DATA(insert OID =3D 325 ( rtendscan PGUID 12 f t f t 1 f 23 "0" =
100 0 0 100 rtendscan - 0 ));
DESCR("r-tree(internal)");
DATA(insert OID =3D 326 ( rtmarkpos PGUID 12 f t f t 1 f 23 "0" =
100 0 0 100 rtmarkpos - 0 ));
DESCR("r-tree(internal)");
DATA(insert OID =3D 327 ( rtrestrpos PGUID 12 f t f t 1 f 23 "0" =
100 0 0 100 rtrestrpos - 0 ));
DESCR("r-tree(internal)");
DATA(insert OID =3D 328 ( rtrescan PGUID 12 f t f t 3 f 23 "0 =
0 0" 100 0 0 100 rtrescan - 0 ));
DESCR("r-tree(internal)");
DATA(insert OID =3D 330 ( btgettuple PGUID 12 f t f t 2 f 23 "0 =
0" 100 0 0 100 btgettuple - 0 ));
DESCR("btree(internal)");
DATA(insert OID =3D 331 ( btinsert PGUID 12 f t f t 5 f 23 "0 =
0 0 0 0" 100 0 0 100 btinsert - 0 ));
DESCR("btree(internal)");
DATA(insert OID =3D 332 ( btdelete PGUID 12 f t f t 2 f 23 "0 =
0" 100 0 0 100 btdelete - 0 ));
DESCR("btree(internal)");
DATA(insert OID =3D 333 ( btbeginscan PGUID 12 f t f t 4 f 23 "0 =
0 0 0" 100 0 0 100 btbeginscan - 0 ));
DESCR("btree(internal)");
DATA(insert OID =3D 334 ( btrescan PGUID 12 f t f t 3 f 23 "0 =
0 0" 100 0 0 100 btrescan - 0 ));
DESCR("btree(internal)");
DATA(insert OID =3D 335 ( btendscan PGUID 12 f t f t 1 f 23 "0" =
100 0 0 100 btendscan - 0 ));
DESCR("btree(internal)");
DATA(insert OID =3D 336 ( btmarkpos PGUID 12 f t f t 1 f 23 "0" =
100 0 0 100 btmarkpos - 0 ));
DESCR("btree(internal)");
DATA(insert OID =3D 337 ( btrestrpos PGUID 12 f t f t 1 f 23 "0" =
100 0 0 100 btrestrpos - 0 ));
DESCR("btree(internal)");
DATA(insert OID =3D 338 ( btbuild PGUID 12 f t f t 5 f 23 "0 =
0 0 0 0" 100 0 0 100 btbuild - 0 ));
DESCR("btree(internal)");
DATA(insert OID =3D 350 ( btint2cmp PGUID 12 f t t t 2 f 23 "21 =
21" 100 0 0 100 btint2cmp - 0 ));
DESCR("btree less-equal-greater");
DATA(insert OID =3D 351 ( btint4cmp PGUID 12 f t t t 2 f 23 "23 =
23" 100 0 0 100 btint4cmp - 0 ));
DESCR("btree less-equal-greater");
DATA(insert OID =3D 842 ( btint8cmp PGUID 12 f t t t 2 f 23 "20 =
20" 100 0 0 100 btint8cmp - 0 ));
DESCR("btree less-equal-greater");
DATA(insert OID =3D 354 ( btfloat4cmp PGUID 12 f t t t 2 f 23 =
"700 700" 100 0 0 100 btfloat4cmp - 0 ));
DESCR("btree less-equal-greater");
DATA(insert OID =3D 355 ( btfloat8cmp PGUID 12 f t t t 2 f 23 =
"701 701" 100 0 0 100 btfloat8cmp - 0 ));
DESCR("btree less-equal-greater");
DATA(insert OID =3D 356 ( btoidcmp PGUID 12 f t t t 2 f 23 "26 =
26" 100 0 0 100 btoidcmp - 0 ));
DESCR("btree less-equal-greater");
DATA(insert OID =3D 404 ( btoidvectorcmp PGUID 12 f t t t 2 f 23 "30 =
30" 100 0 0 100 btoidvectorcmp - 0 ));
DESCR("btree less-equal-greater");
DATA(insert OID =3D 357 ( btabstimecmp PGUID 12 f t f t 2 f 23 =
"702 702" 100 0 0 100 btabstimecmp - 0 ));
DESCR("btree less-equal-greater");
DATA(insert OID =3D 358 ( btcharcmp PGUID 12 f t t t 2 f 23 "18 =
18" 100 0 0 100 btcharcmp - 0 ));
DESCR("btree less-equal-greater");
DATA(insert OID =3D 359 ( btnamecmp PGUID 12 f t t t 2 f 23 "19 =
19" 100 0 0 100 btnamecmp - 0 ));
DESCR("btree less-equal-greater");
DATA(insert OID =3D 360 ( bttextcmp PGUID 12 f t t t 2 f 23 "25 =
25" 100 0 0 100 bttextcmp - 0 ));
DESCR("btree less-equal-greater");
/* OIDS 400 - 499 */
DATA(insert OID =3D 406 ( text PGUID 12 f t t t 1 f 25 =
"19" 100 0 0 100 name_text - char_sizer ));
DESCR("convert name to text");
DATA(insert OID =3D 407 ( name PGUID 12 f t t t 1 f 19 =
"25" 100 0 0 100 text_name - char_sizer ));
DESCR("convert text to name");
DATA(insert OID =3D 408 ( bpchar PGUID 12 f t t t 1 f 1042 =
"19" 100 0 0 100 name_bpchar - char_sizer ));
DESCR("convert name to char()");
DATA(insert OID =3D 409 ( name PGUID 12 f t t t 1 f 19 =
"1042" 100 0 0 100 bpchar_name - char_sizer ));
DESCR("convert char() to name");
DATA(insert OID =3D 438 ( hashcostestimate PGUID 12 f t f t 7 f 0 "0 0 =
0 0 0 0 0" 100 0 0 100 hashcostestimate - 0 ));
DESCR("hash index cost estimator");
DATA(insert OID =3D 440 ( hashgettuple PGUID 12 f t f t 2 f 23 "0 =
0" 100 0 0 100 hashgettuple - 0 ));
DESCR("hash(internal)");
DATA(insert OID =3D 441 ( hashinsert PGUID 12 f t f t 5 f 23 "0 =
0 0 0 0" 100 0 0 100 hashinsert - 0 ));
DESCR("hash(internal)");
DATA(insert OID =3D 442 ( hashdelete PGUID 12 f t f t 2 f 23 "0 =
0" 100 0 0 100 hashdelete - 0 ));
DESCR("hash(internal)");
DATA(insert OID =3D 443 ( hashbeginscan PGUID 12 f t f t 4 f 23 "0 =
0 0 0" 100 0 0 100 hashbeginscan - 0 ));
DESCR("hash(internal)");
DATA(insert OID =3D 444 ( hashrescan PGUID 12 f t f t 3 f 23 "0 =
0 0" 100 0 0 100 hashrescan - 0 ));
DESCR("hash(internal)");
DATA(insert OID =3D 445 ( hashendscan PGUID 12 f t f t 1 f 23 "0" =
100 0 0 100 hashendscan - 0 ));
DESCR("hash(internal)");
DATA(insert OID =3D 446 ( hashmarkpos PGUID 12 f t f t 1 f 23 "0" =
100 0 0 100 hashmarkpos - 0 ));
DESCR("hash(internal)");
DATA(insert OID =3D 447 ( hashrestrpos PGUID 12 f t f t 1 f 23 "0" =
100 0 0 100 hashrestrpos - 0 ));
DESCR("hash(internal)");
DATA(insert OID =3D 448 ( hashbuild PGUID 12 f t f t 5 f 23 "0 =
0 0 0 0" 100 0 0 100 hashbuild - 0 ));
DESCR("hash(internal)");
//DATA(insert OID =3D 449 ( hashint2 PGUID 12 f t t t 1 f 23 =
"21" 100 0 0 100 hashint2 - 0 ));
//DESCR("hash");
//DATA(insert OID =3D 450 ( hashint4 PGUID 12 f t t t 1 f 23 =
"23" 100 0 0 100 hashint4 - 0 ));
//DESCR("hash");
//DATA(insert OID =3D 949 ( hashint8 PGUID 12 f t t t 1 f 23 =
"20" 100 0 0 100 hashint8 - 0 ));
//DESCR("hash");
//DATA(insert OID =3D 451 ( hashfloat4 PGUID 12 f t t t 1 f 23 =
"700" 100 0 0 100 hashfloat4 - 0 ));
//DESCR("hash");
//DATA(insert OID =3D 452 ( hashfloat8 PGUID 12 f t t t 1 f 23 =
"701" 100 0 0 100 hashfloat8 - 0 ));
//DESCR("hash");
//DATA(insert OID =3D 453 ( hashoid PGUID 12 f t t t 1 f 23 =
"26" 100 0 0 100 hashoid - 0 ));
//DESCR("hash");
//DATA(insert OID =3D 454 ( hashchar PGUID 12 f t t t 1 f 23 =
"18" 100 0 0 100 hashchar - 0 ));
//DESCR("hash");
//DATA(insert OID =3D 455 ( hashname PGUID 12 f t t t 1 f 23 =
"19" 100 0 0 100 hashname - 0 ));
//DESCR("hash");
//DATA(insert OID =3D 456 ( hashvarlena PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 hashvarlena - 0 ));
//DESCR("hash any varlena type");
//DATA(insert OID =3D 457 ( hashoidvector PGUID 12 f t t t 1 f 23 =
"30" 100 0 0 100 hashoidvector - 0 ));
//DESCR("hash");
DATA(insert OID =3D 458 ( text_larger PGUID 12 f t t t 2 f 25 "0 =
0" 100 0 0 100 text_larger - 0 ));
DESCR("larger of two");
DATA(insert OID =3D 459 ( text_smaller PGUID 12 f t t t 2 f 25 "0 =
0" 100 0 0 100 text_smaller - 0 ));
DESCR("smaller of two");
DATA(insert OID =3D 460 ( int8in PGUID 12 f t t t 1 f 20 "0" =
100 0 0 100 int8in - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 461 ( int8out PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 int8out - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 462 ( int8um PGUID 12 f t t t 1 f 20 =
"20" 100 0 0 100 int8um - 0 ));
DESCR("negate");
/* conditional on JB_INTEGER_MATH_CHANGE =20
* DATA(insert OID =3D 463 ( int8pl PGUID 12 f t t t 2 f 20 =
"20 20" 100 0 0 100 int8pl - intpl_sizer ));
* DESCR("add");
*/=20
DATA(insert OID =3D 463 ( int8pl PGUID 12 f t t t 2 f 20 "20 =
20" 100 0 0 100 int8pl - 0 ));
DESCR("add");
DATA(insert OID =3D 464 ( int8mi PGUID 12 f t t t 2 f 20 "20 =
20" 100 0 0 100 int8mi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 465 ( int8mul PGUID 12 f t t t 2 f 20 "20 =
20" 100 0 0 100 int8mul - 0 ));
DESCR("multiply");
DATA(insert OID =3D 466 ( int8div PGUID 12 f t t t 2 f 20 "20 =
20" 100 0 0 100 int8div - 0 ));
DESCR("divide");
DATA(insert OID =3D 467 ( int8eq PGUID 12 f t t t 2 f 16 "20 =
20" 100 0 0 100 int8eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 468 ( int8ne PGUID 12 f t t t 2 f 16 "20 =
20" 100 0 0 100 int8ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 469 ( int8lt PGUID 12 f t t t 2 f 16 "20 =
20" 100 0 0 100 int8lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 470 ( int8gt PGUID 12 f t t t 2 f 16 "20 =
20" 100 0 0 100 int8gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 471 ( int8le PGUID 12 f t t t 2 f 16 "20 =
20" 100 0 0 100 int8le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 472 ( int8ge PGUID 12 f t t t 2 f 16 "20 =
20" 100 0 0 100 int8ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 474 ( int84eq PGUID 12 f t t t 2 f 16 "20 =
23" 100 0 0 100 int84eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 475 ( int84ne PGUID 12 f t t t 2 f 16 "20 =
23" 100 0 0 100 int84ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 476 ( int84lt PGUID 12 f t t t 2 f 16 "20 =
23" 100 0 0 100 int84lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 477 ( int84gt PGUID 12 f t t t 2 f 16 "20 =
23" 100 0 0 100 int84gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 478 ( int84le PGUID 12 f t t t 2 f 16 "20 =
23" 100 0 0 100 int84le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 479 ( int84ge PGUID 12 f t t t 2 f 16 "20 =
23" 100 0 0 100 int84ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 480 ( int4 PGUID 12 f t t t 1 f 23 =
"20" 100 0 0 100 int84 - 0 ));
DESCR("convert int8 to int4");
DATA(insert OID =3D 481 ( int8 PGUID 12 f t t t 1 f 20 =
"23" 100 0 0 100 int48 - 0 ));
DESCR("convert int4 to int8");
DATA(insert OID =3D 482 ( float8 PGUID 12 f t t t 1 f 701 =
"20" 100 0 0 100 i8tod - 0 ));
DESCR("convert int8 to float8");
DATA(insert OID =3D 483 ( int8 PGUID 12 f t t t 1 f 20 =
"701" 100 0 0 100 dtoi8 - 0 ));
DESCR("convert float8 to int8");
// Added by Aarti - Bug #966
DATA(insert OID =3D 485 ( int8 PGUID 12 f t t t 1 f 20 =
"21" 100 0 0 100 i2toi8 - 0 ));
DESCR("convert int2 to int8");
DATA(insert OID =3D 486 ( int2 PGUID 12 f t t t 1 f 21 =
"20" 100 0 0 100 i8toi2 - 0 ));
DESCR("convert int8 to int2");
DATA(insert OID =3D 487 ( int2 PGUID 12 f t t t 1 f 21 =
"2500" 100 0 0 100 i1toi2 - 0 ));
DESCR("convert int1 to int2");
DATA(insert OID =3D 488 ( float4 PGUID 12 f t t t 1 f 700 =
"2500" 100 0 0 100 i1tof - 0 ));
DESCR("convert int1 to float4");
DATA(insert OID =3D 489 ( float8 PGUID 12 f t t t 1 f 701 =
"2500" 100 0 0 100 i1tod - 0 ));
DESCR("convert int1 to float8");
DATA(insert OID =3D 490 ( int1 PGUID 12 f t t t 1 f 2500 =
"21" 100 0 0 100 i2toi1 - 0 ));
DESCR("convert int2 to int1");
DATA(insert OID =3D 491 ( float4 PGUID 12 f t t t 1 f 700 =
"20" 100 0 0 100 i8tof - 0 ));
DESCR("convert int8 to float4");
DATA(insert OID =3D 492 ( int8 PGUID 12 f t t t 1 f 20 =
"700" 100 0 0 100 ftoi8 - 0 ));
DESCR("convert float4 to int8");
DATA(insert OID =3D 493 ( int1 PGUID 12 f t t t 1 f 2500 =
"700" 100 0 0 100 ftoi1 - 0 ));
DESCR("convert float4 to int1");
DATA(insert OID =3D 494 ( int1 PGUID 12 f t t t 1 f 2500 =
"701" 100 0 0 100 dtoi1 - 0 ));
DESCR("convert float8 to int1");
/* OIDS 500 - 599 */
/* OIDS 600 - 699 */
DATA(insert OID =3D 1285 ( int4notin PGUID 12 f t f t 2 f 16 "23 =
25" 100 0 0 100 int4notin - 0 ));
DESCR("not in");
DATA(insert OID =3D 1286 ( oidnotin PGUID 12 f t f t 2 f 16 "26 =
25" 100 0 0 100 oidnotin - 0 ));
DESCR("not in");
DATA(insert OID =3D 1287 ( int44in PGUID 12 f t t t 1 f 22 "0" =
100 0 0 100 int44in - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 653 ( int44out PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 int44out - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 655 ( namelt PGUID 12 f t t t 2 f 16 "19 =
19" 100 0 0 100 namelt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 656 ( namele PGUID 12 f t t t 2 f 16 "19 =
19" 100 0 0 100 namele - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 657 ( namegt PGUID 12 f t t t 2 f 16 "19 =
19" 100 0 0 100 namegt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 658 ( namege PGUID 12 f t t t 2 f 16 "19 =
19" 100 0 0 100 namege - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 659 ( namene PGUID 12 f t t t 2 f 16 "19 =
19" 100 0 0 100 namene - 0 ));
DESCR("not equal");
DATA(insert OID =3D 668 ( bpchar PGUID 12 f t t t 3 f 1042 =
"1042 23 23" 100 0 0 100 bpchar - char_sizer ));
DESCR("adjust char() to typmod length");
DATA(insert OID =3D 669 ( varchar PGUID 12 f t t t 3 f 1043 =
"1043 23 23" 100 0 0 100 varchar - char_sizer ));
DESCR("adjust varchar() to typmod length");
DATA(insert OID =3D 619 ( oidvectorne PGUID 12 f t t t 2 f 16 "30 =
30" 100 0 0 100 oidvectorne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 677 ( oidvectorlt PGUID 12 f t t t 2 f 16 "30 =
30" 100 0 0 100 oidvectorlt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 678 ( oidvectorle PGUID 12 f t t t 2 f 16 "30 =
30" 100 0 0 100 oidvectorle - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 679 ( oidvectoreq PGUID 12 f t t t 2 f 16 "30 =
30" 100 0 0 100 oidvectoreq - 0 ));
DESCR("equal");
DATA(insert OID =3D 680 ( oidvectorge PGUID 12 f t t t 2 f 16 "30 =
30" 100 0 0 100 oidvectorge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 681 ( oidvectorgt PGUID 12 f t t t 2 f 16 "30 =
30" 100 0 0 100 oidvectorgt - 0 ));
DESCR("greater-than");
/* OIDS 700 - 799 */
DATA(insert OID =3D 711 ( userfntest PGUID 12 f t t t 1 f 23 =
"23" 100 0 0 100 userfntest - 0 ));
DESCR("");
DATA(insert OID =3D 713 ( oidrand PGUID 12 f t f t 2 f 16 "26 =
23" 100 0 0 100 oidrand - 0 ));
DESCR("random");
DATA(insert OID =3D 715 ( oidsrand PGUID 12 f t f t 1 f 16 =
"23" 100 0 0 100 oidsrand - 0 ));
DESCR("seed random number generator");
DATA(insert OID =3D 716 ( oidlt PGUID 12 f t t t 2 f 16 "26 =
26" 100 0 0 100 oidlt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 717 ( oidle PGUID 12 f t t t 2 f 16 "26 =
26" 100 0 0 100 oidle - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 720 ( octet_length PGUID 12 f t t t 1 f 23 =
"17" 100 0 0 100 byteaoctetlen - 0 ));
DESCR("octet length");
DATA(insert OID =3D 721 ( get_byte PGUID 12 f t t t 2 f 23 "17 =
23" 100 0 0 100 byteaGetByte - 0 ));
DESCR("");
DATA(insert OID =3D 722 ( set_byte PGUID 12 f t t t 3 f 17 "17 =
23 23" 100 0 0 100 byteaSetByte - 0 ));
DESCR("");
DATA(insert OID =3D 723 ( get_bit PGUID 12 f t t t 2 f 23 "17 =
23" 100 0 0 100 byteaGetBit - 0 ));
DESCR("");
DATA(insert OID =3D 724 ( set_bit PGUID 12 f t t t 3 f 17 "17 =
23 23" 100 0 0 100 byteaSetBit - 0 ));
DESCR("");
DATA(insert OID =3D 740 ( text_lt PGUID 12 f t t t 2 f 16 "25 =
25" 100 0 0 100 text_lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 741 ( text_le PGUID 12 f t t t 2 f 16 "25 =
25" 100 0 0 100 text_le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 742 ( text_gt PGUID 12 f t t t 2 f 16 "25 =
25" 100 0 0 100 text_gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 743 ( text_ge PGUID 12 f t t t 2 f 16 "25 =
25" 100 0 0 100 text_ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 744 ( array_eq PGUID 12 f t t t 2 f 16 "0 =
0" 100 0 0 100 array_eq - 0 ));
DESCR("array equal");
DATA(insert OID =3D 745 ( current_user PGUID 12 f t f t 0 f 1042 =
"0" 100 0 0 100 current_user - 0 ));
DESCR("current user name");
DATA(insert OID =3D 746 ( session_user PGUID 12 f t f t 0 f 1042 =
"0" 100 0 0 100 session_user - 0 ));
DESCR("session user name");
DATA(insert OID =3D 752 ( current_useroid PGUID 12 f t f t 0 f 23 "0" =
100 0 0 100 current_useroid - 0 ));
DESCR("current user oid");
DATA(insert OID =3D 753 ( current_userid PGUID 12 f t f t 0 f 23 "0" =
100 0 0 100 current_userid - 0 ));
DESCR("current user sysid");
DATA(insert OID =3D 754 ( current_dbid PGUID 12 f t f t 0 f 23 "0" =
100 0 0 100 current_dbid - 0 ));
DESCR("current database id");
DATA(insert OID =3D 755 ( current_catalog PGUID 12 f t f t 0 f 1042 =
"0" 100 0 0 100 current_catalog - 0 ));
DESCR("current catalog name");
DATA(insert OID =3D 756 ( current_schema PGUID 12 f t f t 0 f 1042 =
"0" 100 0 0 100 current_user - 0 ));
DESCR("current schema name");
DATA(insert OID =3D 757 ( current_sid PGUID 12 f t f t 0 f 23 "0" =
100 0 0 100 current_sid - 0 ));
DESCR("current session id");
DATA(insert OID =3D 747 ( array_dims PGUID 12 f t t t 1 f 1043 =
"0" 100 0 0 100 array_dims - wag_sizer ));
DESCR("array dimensions");
DATA(insert OID =3D 750 ( array_in PGUID 12 f t t t 3 f 23 "0 =
26 23" 100 0 0 100 array_in - 0 ));
DESCR("array");
DATA(insert OID =3D 751 ( array_out PGUID 12 f t t t 2 f 23 "0 =
26" 100 0 0 100 array_out - 0 ));
DESCR("array");
DATA(insert OID =3D 760 ( smgrin PGUID 12 f t f t 1 f 210 =
"0" 100 0 0 100 smgrin - 0 ));
DESCR("storage manager(internal)");
DATA(insert OID =3D 761 ( smgrout PGUID 12 f t f t 1 f 23 =
"0" 100 0 0 100 smgrout - 0 ));
DESCR("storage manager(internal)");
DATA(insert OID =3D 762 ( smgreq PGUID 12 f t f t 2 f 16 =
"210 210" 100 0 0 100 smgreq - 0 ));
DESCR("storage manager");
DATA(insert OID =3D 763 ( smgrne PGUID 12 f t f t 2 f 16 =
"210 210" 100 0 0 100 smgrne - 0 ));
DESCR("storage manager");
DATA(insert OID =3D 766 ( int8inc PGUID 12 f t t t 1 f 20 =
"20" 100 0 0 100 int8inc - 0 ));
DESCR("increment");
DATA(insert OID =3D 768 ( int4larger PGUID 12 f t t t 2 f 23 "23 =
23" 100 0 0 100 int4larger - 0 ));
DESCR("larger of two");
DATA(insert OID =3D 769 ( int4smaller PGUID 12 f t t t 2 f 23 "23 =
23" 100 0 0 100 int4smaller - 0 ));
DESCR("smaller of two");
DATA(insert OID =3D 770 ( int2larger PGUID 12 f t t t 2 f 21 "21 =
21" 100 0 0 100 int2larger - 0 ));
DESCR("larger of two");
DATA(insert OID =3D 771 ( int2smaller PGUID 12 f t t t 2 f 21 "21 =
21" 100 0 0 100 int2smaller - 0 ));
DESCR("smaller of two");
DATA(insert OID =3D 772 ( gistcostestimate PGUID 12 f t f t 7 f 0 "0 0 =
0 0 0 0 0" 100 0 0 100 gistcostestimate - 0 ));
DESCR("gist cost estimator");
DATA(insert OID =3D 774 ( gistgettuple PGUID 12 f t f t 2 f 23 "0 =
0" 100 0 0 100 gistgettuple - 0 ));
DESCR("gist(internal)");
DATA(insert OID =3D 775 ( gistinsert PGUID 12 f t f t 5 f 23 "0 =
0 0 0 0" 100 0 0 100 gistinsert - 0 ));
DESCR("gist(internal)");
DATA(insert OID =3D 776 ( gistdelete PGUID 12 f t f t 2 f 23 "0 =
0" 100 0 0 100 gistdelete - 0 ));
DESCR("gist(internal)");
DATA(insert OID =3D 777 ( gistbeginscan PGUID 12 f t f t 4 f 23 "0 =
0 0 0" 100 0 0 100 gistbeginscan - 0 ));
DESCR("gist(internal)");
DATA(insert OID =3D 778 ( gistrescan PGUID 12 f t f t 3 f 23 "0 =
0 0" 100 0 0 100 gistrescan - 0 ));
DESCR("gist(internal)");
DATA(insert OID =3D 779 ( gistendscan PGUID 12 f t f t 1 f 23 "0" =
100 0 0 100 gistendscan - 0 ));
DESCR("gist(internal)");
DATA(insert OID =3D 780 ( gistmarkpos PGUID 12 f t f t 1 f 23 "0" =
100 0 0 100 gistmarkpos - 0 ));
DESCR("gist(internal)");
DATA(insert OID =3D 781 ( gistrestrpos PGUID 12 f t f t 1 f 23 "0" =
100 0 0 100 gistrestrpos - 0 ));
DESCR("gist(internal)");
DATA(insert OID =3D 782 ( gistbuild PGUID 12 f t f t 5 f 23 "0 =
0 0 0 0" 100 0 0 100 gistbuild - 0 ));
DESCR("gist(internal)");
/* OIDS 800 - 899 */
DATA(insert OID =3D 817 ( oid PGUID 12 f t t t 1 f 26 =
"25" 100 0 0 100 text_oid - 0 ));
DESCR("convert text to oid");
DATA(insert OID =3D 818 ( int2 PGUID 12 f t t t 1 f 21 =
"1043" 100 0 0 100 varchar_int2 - 0 ));
DESCR("convert varchar to int2");
DATA(insert OID =3D 819 ( int4 PGUID 12 f t t t 1 f 23 =
"1043" 100 0 0 100 varchar_int4 - 0 ));
DESCR("convert varchar to int4");
DATA(insert OID =3D 838 ( float8 PGUID 12 f t t t 1 f 701 =
"1043" 100 0 0 100 varchar_float8 - 0 ));
DESCR("convert varchar to float8");
DATA(insert OID =3D 839 ( float4 PGUID 12 f t t t 1 f 700 =
"1043" 100 0 0 100 varchar_float4 - 0 ));
DESCR("convert varcar to float4");
DATA(insert OID =3D 849 ( position PGUID 12 f t t t 2 f 23 =
"1043 1043" 100 0 0 100 varcharpos - 0 ));
DESCR("return position of substring");
DATA(insert OID =3D 850 ( varcharlike PGUID 12 f t t t 2 f 16 =
"1043 1043" 100 0 0 100 varcharlike - 0 ));
DESCR("matches LIKE expression");
DATA(insert OID =3D 851 ( varcharnlike PGUID 12 f t t t 2 f 16 =
"1043 1043" 100 0 0 100 varcharnlike - 0 ));
DESCR("does not match LIKE expression");
DATA(insert OID =3D 852 ( int48eq PGUID 12 f t t t 2 f 16 "23 =
20" 100 0 0 100 int48eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 853 ( int48ne PGUID 12 f t t t 2 f 16 "23 =
20" 100 0 0 100 int48ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 854 ( int48lt PGUID 12 f t t t 2 f 16 "23 =
20" 100 0 0 100 int48lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 855 ( int48gt PGUID 12 f t t t 2 f 16 "23 =
20" 100 0 0 100 int48gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 856 ( int48le PGUID 12 f t t t 2 f 16 "23 =
20" 100 0 0 100 int48le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 857 ( int48ge PGUID 12 f t t t 2 f 16 "23 =
20" 100 0 0 100 int48ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 858 ( namelike PGUID 12 f t t t 2 f 16 "19 =
25" 100 0 0 100 namelike - 0 ));
DESCR("matches LIKE expression");
DATA(insert OID =3D 859 ( namenlike PGUID 12 f t t t 2 f 16 "19 =
25" 100 0 0 100 namenlike - 0 ));
DESCR("does not match LIKE expression");
DATA(insert OID =3D 860 ( bpchar PGUID 12 f t t t 1 f 1042 =
"18" 100 0 0 100 char_bpchar - 0 ));
DESCR("convert char to char()");
DATA(insert OID =3D 861 ( char PGUID 12 f t t t 1 f 18 =
"1042" 100 0 0 100 bpchar_char - 0 ));
DESCR("convert char() to char");
DATA(insert OID =3D 887 ( cash_out PGUID 12 f t t t 1 f 23 =
"0" 100 0 0 100 cash_out - 0 ));
DESCR("(internal)");
/* OIDS 900 - 999 */
DATA(insert OID =3D 940 ( mod PGUID 12 f t t t 2 f 21 "21 =
21" 100 0 0 100 int2mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 941 ( mod PGUID 12 f t t t 2 f 23 "23 =
23" 100 0 0 100 int4mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 942 ( mod PGUID 12 f t t t 2 f 23 "21 =
23" 100 0 0 100 int24mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 943 ( mod PGUID 12 f t t t 2 f 23 "23 =
21" 100 0 0 100 int42mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 945 ( int8mod PGUID 12 f t t t 2 f 20 "20 =
20" 100 0 0 100 int8mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 947 ( mod PGUID 12 f t t t 2 f 20 "20 =
20" 100 0 0 100 int8mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 944 ( char PGUID 12 f t t t 1 f 18 =
"25" 100 0 0 100 text_char - 0 ));
DESCR("convert text to char");
DATA(insert OID =3D 946 ( text PGUID 12 f t t t 1 f 25 =
"18" 100 0 0 100 char_text - char_sizer ));
DESCR("convert char to text");
DATA(insert OID =3D 950 ( istrue PGUID 12 f t t f 1 f 16 =
"16" 100 0 0 100 istrue - 0 ));
DESCR("bool is true (not false or unknown)");
DATA(insert OID =3D 951 ( isfalse PGUID 12 f t t f 1 f 16 =
"16" 100 0 0 100 isfalse - 0 ));
DESCR("bool is false (not true or unknown)");
DATA(insert OID =3D 972 ( regproctooid PGUID 12 f t t t 1 f 26 =
"24" 100 0 0 100 regproctooid - 0 ));
DESCR("get oid for regproc");
DATA(insert OID =3D 748 ( date PGUID 12 f t t t 1 f 1082 =
"1043" 100 0 0 100 varchar_date - 0 ));
DESCR("convert varchar to date");
DATA(insert OID =3D 749 ( varchar PGUID 12 f t t t 1 f 1043 =
"1082" 100 0 0 100 date_varchar - wag_sizer ));
DESCR("convert date to varchar");
DATA(insert OID =3D 837 ( time PGUID 12 f t t t 1 f 1083 =
"1043" 100 0 0 100 varchar_time - 0 ));
DESCR("convert varchar to time");
DATA(insert OID =3D 1763 ( time PGUID 12 f t t t 1 f 1083 =
"1042" 100 0 0 100 bpchar_time - 0 ));
DESCR("convert fixed char to time");
DATA(insert OID =3D 948 ( varchar PGUID 12 f t t t 1 f 1043 =
"1083" 100 0 0 100 time_varchar - wag_sizer ));
DESCR("convert time to varchar");
DATA(insert OID =3D 938 ( timetz PGUID 12 f t t t 1 f 1266 =
"1043" 100 0 0 100 varchar_timetz - 0 ));
DESCR("convert varchar to timetz");
DATA(insert OID =3D 939 ( varchar PGUID 12 f t t t 1 f 1043 =
"1266" 100 0 0 100 timetz_varchar - wag_sizer ));
DESCR("convert timetz to varchar");
/* OIDS 1000 - 1999 */
DATA(insert OID =3D 1026 ( timezone PGUID 12 f t t t 2 f 1043 =
"1186 1184" 100 0 0 100 timestamp_izone - wag_sizer ));
DESCR("time zone");
DATA(insert OID =3D 1029 ( nullvalue PGUID 12 f t t f 1 f 16 "0" =
100 0 0 100 nullvalue - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1030 ( nonnullvalue PGUID 12 f t t f 1 f 16 "0" =
100 0 0 100 nonnullvalue - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1031 ( aclitemin PGUID 12 f t f t 1 f 1033 =
"0" 100 0 0 100 aclitemin - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1032 ( aclitemout PGUID 12 f t f t 1 f 23 =
"1033" 100 0 0 100 aclitemout - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1035 ( aclinsert PGUID 12 f t f t 2 f 1034 =
"1034 1033" 100 0 0 100 aclinsert - 0 ));
DESCR("add/update ACL item");
DATA(insert OID =3D 1036 ( aclremove PGUID 12 f t f t 2 f 1034 =
"1034 1033" 100 0 0 100 aclremove - 0 ));
DESCR("remove ACL item");
DATA(insert OID =3D 1037 ( aclcontains PGUID 12 f t f t 2 f 16 =
"1034 1033" 100 0 0 100 aclcontains - 0 ));
DESCR("does ACL contain item?");
DATA(insert OID =3D 1038 ( seteval PGUID 12 f t f t 1 t 23 =
"26" 100 0 0 100 seteval - 0 ));
DESCR("internal function supporting PostQuel-style sets");
DATA(insert OID =3D 1044 ( bpcharin PGUID 12 f t t t 3 f 1042 =
"0 26 23" 100 0 0 100 bpcharin - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1045 ( bpcharout PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 bpcharout - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1046 ( varcharin PGUID 12 f t t t 3 f 1043 =
"0 26 23" 100 0 0 100 varcharin - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1047 ( varcharout PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 varcharout - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1048 ( bpchareq PGUID 12 f t t t 2 f 16 =
"1042 1042" 100 0 0 100 bpchareq - 0 ));
DESCR("equal");
DATA(insert OID =3D 1049 ( bpcharlt PGUID 12 f t t t 2 f 16 =
"1042 1042" 100 0 0 100 bpcharlt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 1050 ( bpcharle PGUID 12 f t t t 2 f 16 =
"1042 1042" 100 0 0 100 bpcharle - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 1051 ( bpchargt PGUID 12 f t t t 2 f 16 =
"1042 1042" 100 0 0 100 bpchargt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 1052 ( bpcharge PGUID 12 f t t t 2 f 16 =
"1042 1042" 100 0 0 100 bpcharge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 1053 ( bpcharne PGUID 12 f t t t 2 f 16 =
"1042 1042" 100 0 0 100 bpcharne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 1070 ( varchareq PGUID 12 f t t t 2 f 16 =
"1043 1043" 100 0 0 100 varchareq - 0 ));
DESCR("equal");
DATA(insert OID =3D 1071 ( varcharlt PGUID 12 f t t t 2 f 16 =
"1043 1043" 100 0 0 100 varcharlt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 1072 ( varcharle PGUID 12 f t t t 2 f 16 =
"1043 1043" 100 0 0 100 varcharle - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 1073 ( varchargt PGUID 12 f t t t 2 f 16 =
"1043 1043" 100 0 0 100 varchargt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 1074 ( varcharge PGUID 12 f t t t 2 f 16 =
"1043 1043" 100 0 0 100 varcharge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 1075 ( varcharne PGUID 12 f t t t 2 f 16 =
"1043 1043" 100 0 0 100 varcharne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 1078 ( bpcharcmp PGUID 12 f t t t 2 f 23 =
"1042 1042" 100 0 0 100 bpcharcmp - 0 ));
DESCR("less-equal-greater");
DATA(insert OID =3D 1079 ( varcharcmp PGUID 12 f t t t 2 f 23 =
"1043 1043" 100 0 0 100 varcharcmp - 0 ));
DESCR("less-equal-greater");
//DATA(insert OID =3D 1080 ( hashbpchar PGUID 12 f t t t 1 f 23 =
"1042" 100 0 0 100 hashbpchar - 0 ));
//DESCR("hash");
DATA(insert OID =3D 1081 ( format_type PGUID 12 f t t f 2 f 1043 =
"26 23" 100 0 0 100 format_type - wag_sizer ));
DESCR("format a type oid and atttypmod to canonical SQL");
DATA(insert OID =3D 6000 ( format_dspleng PGUID 12 f t t t 3 f 23 "26 =
23 23" 100 0 0 100 format_dspleng - 0 ));
DESCR("format a type oid and atttypmod and attlen to display length");
DATA(insert OID =3D 6001 ( format_prec PGUID 12 f t t f 3 f 23 "26 =
23 23" 100 0 0 100 format_prec - 0 ));
DESCR("format a type oid and atttypmod and attlen to column precision");
DATA(insert OID =3D 6002 ( format_scale PGUID 12 f t t t 2 f 23 "26 =
23" 100 0 0 100 format_scale - 0 ));
DESCR("format a type oid and atttypmod to column scale");
DATA(insert OID =3D 1084 ( date_in PGUID 12 f t t t 1 f 1082 =
"0" 100 0 0 100 date_in - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1085 ( date_out PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 date_out - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1086 ( date_eq PGUID 12 f t t t 2 f 16 =
"1082 1082" 100 0 0 100 date_eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 1087 ( date_lt PGUID 12 f t t t 2 f 16 =
"1082 1082" 100 0 0 100 date_lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 1088 ( date_le PGUID 12 f t t t 2 f 16 =
"1082 1082" 100 0 0 100 date_le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 1089 ( date_gt PGUID 12 f t t t 2 f 16 =
"1082 1082" 100 0 0 100 date_gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 1090 ( date_ge PGUID 12 f t t t 2 f 16 =
"1082 1082" 100 0 0 100 date_ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 1091 ( date_ne PGUID 12 f t t t 2 f 16 =
"1082 1082" 100 0 0 100 date_ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 1092 ( date_cmp PGUID 12 f t t t 2 f 23 =
"1082 1082" 100 0 0 100 date_cmp - 0 ));
DESCR("less-equal-greater");
/* OIDS 1100 - 1199 */
DATA(insert OID =3D 1102 ( time_lt PGUID 12 f t t t 2 f 16 =
"1083 1083" 100 0 0 100 time_lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 1103 ( time_le PGUID 12 f t t t 2 f 16 =
"1083 1083" 100 0 0 100 time_le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 1104 ( time_gt PGUID 12 f t t t 2 f 16 =
"1083 1083" 100 0 0 100 time_gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 1105 ( time_ge PGUID 12 f t t t 2 f 16 =
"1083 1083" 100 0 0 100 time_ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 1106 ( time_ne PGUID 12 f t t t 2 f 16 =
"1083 1083" 100 0 0 100 time_ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 1107 ( time_cmp PGUID 12 f t t t 2 f 23 =
"1083 1083" 100 0 0 100 time_cmp - 0 ));
DESCR("less-equal-greater");
DATA(insert OID =3D 1138 ( date_larger PGUID 12 f t t t 2 f 1082 =
"1082 1082" 100 0 0 100 date_larger - 0 ));
DESCR("larger of two");
DATA(insert OID =3D 1139 ( date_smaller PGUID 12 f t t t 2 f 1082 =
"1082 1082" 100 0 0 100 date_smaller - 0 ));
DESCR("smaller of two");
DATA(insert OID =3D 1140 ( date_mi PGUID 12 f t t t 2 f 23 =
"1082 1082" 100 0 0 100 date_mi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 1141 ( date_pli PGUID 12 f t t t 2 f 1082 =
"1082 23" 100 0 0 100 date_pli - 0 ));
DESCR("add");
DATA(insert OID =3D 1142 ( date_mii PGUID 12 f t t t 2 f 1082 =
"1082 23" 100 0 0 100 date_mii - 0 ));
DESCR("subtract");
DATA(insert OID =3D 1143 ( time_in PGUID 12 f t t t 1 f 1083 =
"0" 100 0 0 100 time_in - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1144 ( time_out PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 time_out - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1145 ( time_eq PGUID 12 f t t t 2 f 16 =
"1083 1083" 100 0 0 100 time_eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 1150 ( timestamp_in PGUID 12 f t t t 1 f 1184 =
"0" 100 0 0 100 timestamp_in - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1151 ( timestamp_out PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 timestamp_out - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1152 ( timestamp_eq PGUID 12 f t t t 2 f 16 =
"1184 1184" 100 0 0 100 timestamp_eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 1153 ( timestamp_ne PGUID 12 f t t t 2 f 16 =
"1184 1184" 100 0 0 100 timestamp_ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 1154 ( timestamp_lt PGUID 12 f t t t 2 f 16 =
"1184 1184" 100 0 0 100 timestamp_lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 1155 ( timestamp_le PGUID 12 f t t t 2 f 16 =
"1184 1184" 100 0 0 100 timestamp_le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 1156 ( timestamp_ge PGUID 12 f t t t 2 f 16 =
"1184 1184" 100 0 0 100 timestamp_ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 1157 ( timestamp_gt PGUID 12 f t t t 2 f 16 =
"1184 1184" 100 0 0 100 timestamp_gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 1159 ( timezone PGUID 12 f t t t 2 f 1043 =
"1043 1184" 100 0 0 100 timestamp_zone - wag_sizer ));
DESCR("time zone");
DATA(insert OID =3D 1160 ( interval_in PGUID 12 f t t t 1 f 1186 =
"0" 100 0 0 100 interval_in - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1161 ( interval_out PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 interval_out - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1162 ( interval_eq PGUID 12 f t t t 2 f 16 =
"1186 1186" 100 0 0 100 interval_eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 1163 ( interval_ne PGUID 12 f t t t 2 f 16 =
"1186 1186" 100 0 0 100 interval_ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 1164 ( interval_lt PGUID 12 f t t t 2 f 16 =
"1186 1186" 100 0 0 100 interval_lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 1165 ( interval_le PGUID 12 f t t t 2 f 16 =
"1186 1186" 100 0 0 100 interval_le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 1166 ( interval_ge PGUID 12 f t t t 2 f 16 =
"1186 1186" 100 0 0 100 interval_ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 1167 ( interval_gt PGUID 12 f t t t 2 f 16 =
"1186 1186" 100 0 0 100 interval_gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 1168 ( interval_um PGUID 12 f t t t 1 f 1186 =
"1186" 100 0 0 100 interval_um - 0 ));
DESCR("subtract");
DATA(insert OID =3D 1169 ( interval_pl PGUID 12 f t t t 2 f 1186 =
"1186 1186" 100 0 0 100 interval_pl - 0 ));
DESCR("add");
DATA(insert OID =3D 1170 ( interval_mi PGUID 12 f t t t 2 f 1186 =
"1186 1186" 100 0 0 100 interval_mi - 0 ));
DESCR("subtract");
/* NZ overloading for date_part (we add defines for oids so we can test =
in timestamp_part and interval_part) */
DATA(insert OID =3D 1171 ( date_part PGUID 12 f t t t 2 f 23 =
"1043 1184" 100 0 0 100 timestamp_part - 0 ));
DESCR("extract field from timestamp");
#define DATE_PART_TS 1171 /* (text and) timestamp */
DATA(insert OID =3D 1172 ( date_part PGUID 12 f t t t 2 f 23 =
"1043 1186" 100 0 0 100 interval_part - 0 ));
DESCR("extract field from interval");
#define DATE_PART_I 1172 /* (text and) interval */
DATA(insert OID =3D 1173 ( timestamp PGUID 12 f t f t 1 f 1184 =
"702" 100 0 0 100 abstime_timestamp - 0 ));
DESCR("convert abstime to timestamp");
DATA(insert OID =3D 1174 ( timestamp PGUID 12 f t t t 1 f 1184 =
"1082" 100 0 0 100 date_timestamp - 0 ));
DESCR("convert date to timestamp");
/* NZ overloading for timedate_pl (we add define for oid so we can test =
in datetime_timestamp) */
DATA(insert OID =3D 1176 ( timestamp PGUID 12 f t t t 2 f 1184 =
"1082 1083" 100 0 0 100 datetime_timestamp - 0 ));
DESCR("convert date and time to timestamp");
#define DATETIME_TIMESTAMP_D_T 1176 /* date, time */
DATA(insert OID =3D 1177 ( interval PGUID 12 f t f t 1 f 1186 =
"703" 100 0 0 100 reltime_interval - 0 ));
DESCR("convert reltime to interval");
DATA(insert OID =3D 1178 ( date PGUID 12 f t t t 1 f 1082 =
"1184" 100 0 0 100 timestamp_date - 0 ));
DESCR("convert timestamp to date");
DATA(insert OID =3D 1179 ( date PGUID 12 f t f t 1 f 1082 =
"702" 100 0 0 100 abstime_date - 0 ));
DESCR("convert abstime to date");
DATA(insert OID =3D 1185 ( age PGUID 12 f t t t 2 f 1186 =
"1082 1082" 100 0 0 100 date_age - 0 ));
DESCR("date difference preserving months and years");
DATA(insert OID =3D 1187 ( age PGUID 12 f t f t 1 f 1186 =
"1082" 100 0 0 100 date_age - 0 ));
DESCR("date difference from today preserving months and years");
DATA(insert OID =3D 1188 ( timestamp_mi PGUID 12 f t t t 2 f 1186 =
"1184 1184" 100 0 0 100 timestamp_mi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 1189 ( timestamp_pl_span PGUID 12 f t t t 2 f 1184 =
"1184 1186" 100 0 0 100 timestamp_pl_span - 0 ));
DESCR("plus");
DATA(insert OID =3D 1205 ( span_pl_timestamp PGUID 12 f t t t 2 f 1184 =
"1186 1184" 100 0 0 100 timestamp_pl_span - 0 ));
DESCR("plus");
DATA(insert OID =3D 1190 ( timestamp_mi_span PGUID 12 f t t t 2 f 1184 =
"1184 1186" 100 0 0 100 timestamp_mi_span - 0 ));
DESCR("minus");
DATA(insert OID =3D 1191 ( timestamp PGUID 12 f t t t 1 f 1184 =
"1043" 100 0 0 100 varchar_timestamp - 0 ));
DESCR("convert varchar to timestamp");
DATA(insert OID =3D 1192 ( varchar PGUID 12 f t t t 1 f 1043 =
"1184" 100 0 0 100 timestamp_varchar - wag_sizer ));
DESCR("convert timestamp to varchar");
DATA(insert OID =3D 1193 ( varchar PGUID 12 f t t t 1 f 1043 =
"1186" 100 0 0 100 interval_varchar - wag_sizer ));
DESCR("convert interval to varchar");
DATA(insert OID =3D 1195 ( timestamp_smaller PGUID 12 f t f t 2 f 1184 =
"1184 1184" 100 0 0 100 timestamp_smaller - 0 ));
DESCR("smaller of two");
DATA(insert OID =3D 1196 ( timestamp_larger PGUID 12 f t f t 2 f 1184 =
"1184 1184" 100 0 0 100 timestamp_larger - 0 ));
DESCR("larger of two");
DATA(insert OID =3D 1197 ( interval_smaller PGUID 12 f t f t 2 f 1186 =
"1186 1186" 100 0 0 100 interval_smaller - 0 ));
DESCR("smaller of two");
DATA(insert OID =3D 1198 ( interval_larger PGUID 12 f t f t 2 f 1186 =
"1186 1186" 100 0 0 100 interval_larger - 0 ));
DESCR("larger of two");
DATA(insert OID =3D 1199 ( age PGUID 12 f t t t 2 f 1186 =
"1184 1184" 100 0 0 100 timestamp_age - 0 ));
DESCR("date difference preserving months and years");
/* OIDS 1200 - 1299 */
DATA(insert OID =3D 1201 ( months_between PGUID 12 f t t t 2 f 1700 =
"1184 1184" 100 0 0 100 months_between - months_between_sizer ));
DESCR("fractional months between two timestamps");
DATA(insert OID =3D 1202 ( int_months_between PGUID 12 f t t t 2 f 23 =
"1082 1082" 100 0 0 100 int_months_between - 0 ));
DESCR("integral months between two dates");
DATA(insert OID =3D 1203 ( add_months PGUID 12 f t t t 2 f 1184 =
"1184 23" 100 0 0 100 add_months_timestamp - 0 ));
DESCR("add months to timestamp");
DATA(insert OID =3D 1204 ( add_months PGUID 12 f t t t 2 f 1082 =
"1082 23" 100 0 0 100 add_months_date - 0 ));
DESCR("add months to date");
DATA(insert OID =3D 1217 ( date_trunc PGUID 12 f t t t 2 f 1184 =
"1043 1184" 100 0 0 100 timestamp_trunc - 0 ));
DESCR("truncate timestamp to specified units");
DATA(insert OID =3D 1218 ( date_trunc PGUID 12 f t t t 2 f 1186 =
"1043 1186" 100 0 0 100 interval_trunc - 0 ));
DESCR("truncate interval to specified units");
DATA(insert OID =3D 1230 ( int8abs PGUID 12 f t t t 1 f 20 =
"20" 100 0 0 100 int8abs - 0 ));
DESCR("absolute value");
DATA(insert OID =3D 1236 ( int8larger PGUID 12 f t t t 2 f 20 "20 =
20" 100 0 0 100 int8larger - 0 ));
DESCR("larger of two");
DATA(insert OID =3D 1237 ( int8smaller PGUID 12 f t t t 2 f 20 "20 =
20" 100 0 0 100 int8smaller - 0 ));
DESCR("smaller of two");
DATA(insert OID =3D 1238 ( texticregexeq PGUID 12 f t t t 2 f 16 "25 =
25" 100 0 0 100 texticregexeq - 0 ));
DESCR("matches regex., case-insensitive");
DATA(insert OID =3D 1239 ( texticregexne PGUID 12 f t t t 2 f 16 "25 =
25" 100 0 0 100 texticregexne - 0 ));
DESCR("does not match regex., case-insensitive");
DATA(insert OID =3D 1240 ( nameicregexeq PGUID 12 f t t t 2 f 16 "19 =
25" 100 0 0 100 nameicregexeq - 0 ));
DESCR("matches regex., case-insensitive");
DATA(insert OID =3D 1241 ( nameicregexne PGUID 12 f t t t 2 f 16 "19 =
25" 100 0 0 100 nameicregexne - 0 ));
DESCR("does not match regex., case-insensitive");
DATA(insert OID =3D 1251 ( int4abs PGUID 12 f t t t 1 f 23 =
"23" 100 0 0 100 int4abs - 0 ));
DESCR("absolute value");
DATA(insert OID =3D 1253 ( int2abs PGUID 12 f t t t 1 f 21 =
"21" 100 0 0 100 int2abs - 0 ));
DESCR("absolute value");
DATA(insert OID =3D 1263 ( interval PGUID 12 f t t t 1 f 1186 =
"1043" 100 0 0 100 varchar_interval - 0 ));
DESCR("convert varchar to interval");
DATA(insert OID =3D 1271 ( overlaps PGUID 12 f t t f 4 f 16 =
"1266 1266 1266 1266" 100 0 0 100 overlaps_timetz - 0 ));
DESCR("SQL92 interval comparison");
DATA(insert OID =3D 1272 ( datetime_pl PGUID 12 f t t t 2 f 1184 =
"1082 1083" 100 0 0 100 datetime_timestamp - 0 ));
DESCR("convert date and time to timestamp");
/* conditional on JB_INTEGER_MATH_CHANGE =20
* DATA(insert OID =3D 1274 ( int84pl PGUID 12 f t t t 2 f 20 =
"20 23" 100 0 0 100 int84pl - intpl_sizer ));
* DESCR("add");
*/=20
DATA(insert OID =3D 1274 ( int84pl PGUID 12 f t t t 2 f 20 "20 =
23" 100 0 0 100 int84pl - 0 ));
DESCR("add");
DATA(insert OID =3D 1275 ( int84mi PGUID 12 f t t t 2 f 20 "20 =
23" 100 0 0 100 int84mi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 1276 ( int84mul PGUID 12 f t t t 2 f 20 "20 =
23" 100 0 0 100 int84mul - 0 ));
DESCR("multiply");
DATA(insert OID =3D 1277 ( int84div PGUID 12 f t t t 2 f 20 "20 =
23" 100 0 0 100 int84div - 0 ));
DESCR("divide");
/* conditional on JB_INTEGER_MATH_CHANGE =20
* DATA(insert OID =3D 1278 ( int48pl PGUID 12 f t t t 2 f 20 =
"23 20" 100 0 0 100 int48pl - intpl_sizer ));
* DESCR("add");
*/=20
DATA(insert OID =3D 1278 ( int48pl PGUID 12 f t t t 2 f 20 "23 =
20" 100 0 0 100 int48pl - 0 ));
DESCR("add");
DATA(insert OID =3D 1279 ( int48mi PGUID 12 f t t t 2 f 20 "23 =
20" 100 0 0 100 int48mi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 1280 ( int48mul PGUID 12 f t t t 2 f 20 "23 =
20" 100 0 0 100 int48mul - 0 ));
DESCR("multiply");
DATA(insert OID =3D 1281 ( int48div PGUID 12 f t t t 2 f 20 "23 =
20" 100 0 0 100 int48div - 0 ));
DESCR("divide");
DATA(insert OID =3D 1289 ( int8 PGUID 12 f t t t 1 f 20 =
"1043" 100 0 0 100 varchar_int8 - 0 ));
DESCR("convert varchar to int8");
DATA(insert OID =3D 1290 ( _bpchar PGUID 12 f t t t 2 f 1014 =
"1014 23" 100 0 0 100 _bpchar - 0 ));
DESCR("adjust char()[] to typmod length");
DATA(insert OID =3D 1291 ( _varchar PGUID 12 f t t t 2 f 1015 =
"1015 23" 100 0 0 100 _varchar - 0 ));
DESCR("adjust varchar()[] to typmod length");
DATA(insert OID =3D 1292 ( tideq PGUID 12 f t f t 2 f 16 "27 =
27" 100 0 0 100 tideq - 0 ));
DESCR("equal");
DATA(insert OID =3D 1293 ( currtid PGUID 12 f t f t 2 f 27 "26 =
27" 100 0 0 100 currtid_byreloid - 0 ));
DESCR("latest tid of a tuple");
DATA(insert OID =3D 1294 ( currtid2 PGUID 12 f t f t 2 f 27 "25 =
27" 100 0 0 100 currtid_byrelname - 0 ));
DESCR("latest tid of a tuple");
/* NZ next was done via select in pg original (we add define for oid so =
we can test in datetime_timestamp) */
DATA(insert OID =3D 1296 ( timedate_pl PGUID 12 f t t t 2 f 1184 =
"1083 1082" 100 0 0 100 datetime_timestamp - 0 ));
DESCR("convert time and date to timestamp");
#define DATETIME_TIMESTAMP_T_D 1296 /* time, date */
/* NZ overloading for timetzdate_pl (we add define for oid so we can =
test in datetimetz_timestamp) */
DATA(insert OID =3D 1297 ( datetimetz_pl PGUID 12 f t t t 2 f 1184 =
"1082 1266" 100 0 0 100 datetimetz_timestamp - 0 ));
DESCR("convert date and time with time zone to timestamp");
#define DATETIMETZ_TIMESTAMP_D_T_1 1297 /* date, timetz */
/* NZ next was done via select in pg original (we add define for oid so =
we can test in datetimetz_timestamp) */
DATA(insert OID =3D 1298 ( timetzdate_pl PGUID 12 f t t t 2 f 1184 =
"1266 1082" 100 0 0 100 datetimetz_timestamp - 0 ));
DESCR("convert time with time zone and date to timestamp");
#define DATETIMETZ_TIMESTAMP_T_D 1298 /* timetz, date */
DATA(insert OID =3D 1299 ( now PGUID 12 f t f t 0 f 1184 =
"0" 100 0 0 100 now - 0 ));
DESCR("current transaction time");
/* OIDS 1300 - 1399 */
DATA(insert OID =3D 1304 ( overlaps PGUID 12 f t t f 4 f 16 =
"1184 1184 1184 1184" 100 0 0 100 overlaps_timestamp - 0 ));
DESCR("SQL92 interval comparison");
/* NZ next three were done via selects in pg original (we add defines =
for oids so we can test in overlaps_timestamp) */
DATA(insert OID =3D 1305 ( overlaps PGUID 12 f t t f 4 f 16 =
"1184 1186 1184 1186" 100 0 0 100 overlaps_timestamp - 0 ));
DESCR("SQL92 interval comparison");
#define OVERLAPS_TS_I_TS_I 1305 /* (timestamp, interval) (timestamp, =
interval) */
DATA(insert OID =3D 1306 ( overlaps PGUID 12 f t t f 4 f 16 =
"1184 1184 1184 1186" 100 0 0 100 overlaps_timestamp - 0 ));
DESCR("SQL92 interval comparison");
#define OVERLAPS_TS_TS_TS_I 1306 /* (timestamp, timestamp) (timestamp, =
interval) */
DATA(insert OID =3D 1307 ( overlaps PGUID 12 f t t f 4 f 16 =
"1184 1186 1184 1184" 100 0 0 100 overlaps_timestamp - 0 ));
DESCR("SQL92 interval comparison");
#define OVERLAPS_TS_I_TS_TS 1307 /* (timestamp, interval) (timestamp, =
interval) */
DATA(insert OID =3D 1308 ( overlaps PGUID 12 f t t f 4 f 16 =
"1083 1083 1083 1083" 100 0 0 100 overlaps_time - 0 ));
DESCR("SQL92 interval comparison");
/* NZ next three were done via selects in pg original (we add defines =
for oids so we can test in overlaps_time) */
DATA(insert OID =3D 1309 ( overlaps PGUID 12 f t t f 4 f 16 =
"1083 1186 1083 1186" 100 0 0 100 overlaps_time - 0 ));
DESCR("SQL92 interval comparison");
#define OVERLAPS_T_I_T_I 1309 /* (time, interval) (time, interval) */
DATA(insert OID =3D 1310 ( overlaps PGUID 12 f t t f 4 f 16 =
"1083 1083 1083 1186" 100 0 0 100 overlaps_time - 0 ));
DESCR("SQL92 interval comparison");
#define OVERLAPS_T_T_T_I 1310 /* (time, time) (time, interval) */
DATA(insert OID =3D 1311 ( overlaps PGUID 12 f t t f 4 f 16 =
"1083 1186 1083 1083" 100 0 0 100 overlaps_time - 0 ));
DESCR("SQL92 interval comparison"); /* (time, interval) (time, time) */
#define OVERLAPS_T_I_T_T 1311
DATA(insert OID =3D 1314 ( timestamp_cmp PGUID 12 f t t t 2 f 23 =
"1184 1184" 100 0 0 100 timestamp_cmp - 0 ));
DESCR("less-equal-greater");
DATA(insert OID =3D 1315 ( interval_cmp PGUID 12 f t t t 2 f 23 =
"1186 1186" 100 0 0 100 interval_cmp - 0 ));
DESCR("less-equal-greater");
DATA(insert OID =3D 1316 ( time PGUID 12 f t t t 1 f 1083 =
"1184" 100 0 0 100 timestamp_time - 0 ));
DESCR("convert timestamp to time");
DATA(insert OID =3D 1317 ( length PGUID 12 f t t t 1 f 23 =
"25" 100 0 0 100 textlen - 0 ));
DESCR("length");
DATA(insert OID =3D 1318 ( length PGUID 12 f t t t 1 f 23 =
"1042" 100 0 0 100 bpcharlen - 0 ));
DESCR("character length");
DATA(insert OID =3D 1319 ( length PGUID 12 f t t t 1 f 23 =
"1043" 100 0 0 100 varcharlen - 0 ));
DESCR("character length");
DATA(insert OID =3D 389 ( length PGUID 12 f t t t 1 f 23 =
"2568" 100 0 0 100 bloblen - 0 ));
DESCR("length");
DATA(insert OID =3D 399 ( length PGUID 12 f t t t 1 f 23 =
"2569" 100 0 0 100 nucllen - 0 ));
DESCR("length");
DATA(insert OID =3D 437 ( length PGUID 12 f t t t 1 f 23 =
"2570" 100 0 0 100 protlen - 0 ));
DESCR("length");
DATA(insert OID =3D 1326 ( interval_div PGUID 12 f t t t 2 f 1186 =
"1186 701" 100 0 0 100 interval_div - 0 ));
DESCR("divide");
DATA(insert OID =3D 1339 ( dlog10 PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 dlog10 - 0 ));
DESCR("base 10 logarithm");
DATA(insert OID =3D 1340 ( log PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 dlog10 - 0 ));
DESCR("base 10 logarithm");
DATA(insert OID =3D 1341 ( ln PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 dlog1 - 0 ));
DESCR("natural logarithm");
DATA(insert OID =3D 1342 ( round PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 dround - 0 ));
DESCR("round to nearest integer");
DATA(insert OID =3D 1343 ( trunc PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 dtrunc - 0 ));
DESCR("truncate to integer");
DATA(insert OID =3D 1344 ( sqrt PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 dsqrt - 0 ));
DESCR("square root");
DATA(insert OID =3D 1346 ( pow PGUID 12 f t t t 2 f 701 =
"701 701" 100 0 0 100 dpow - 0 ));
DESCR("exponentiation");
DATA(insert OID =3D 1347 ( exp PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 dexp - 0 ));
DESCR("exponential");
DATA(insert OID =3D 1348 ( obj_description PGUID 14 f t f t 1 f =
1043 "26" 100 0 0 100 "select description from _t_description where =
objoid =3D $1" - wag_sizer ));
DESCR("get description for object id");
DATA(insert OID =3D 1349 ( oidvectortypes PGUID 12 f t f t 1 f =
1043 "30" 100 0 0 100 oidvectortypes - wag_sizer ));
DESCR("print type names of oidvector field");
DATA(insert OID =3D 1350 ( timetz_in PGUID 12 f t t t 1 f 1266 =
"0" 100 0 0 100 timetz_in - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1351 ( timetz_out PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 timetz_out - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1352 ( timetz_eq PGUID 12 f t t t 2 f 16 =
"1266 1266" 100 0 0 100 timetz_eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 1353 ( timetz_ne PGUID 12 f t t t 2 f 16 =
"1266 1266" 100 0 0 100 timetz_ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 1354 ( timetz_lt PGUID 12 f t t t 2 f 16 =
"1266 1266" 100 0 0 100 timetz_lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 1355 ( timetz_le PGUID 12 f t t t 2 f 16 =
"1266 1266" 100 0 0 100 timetz_le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 1356 ( timetz_ge PGUID 12 f t t t 2 f 16 =
"1266 1266" 100 0 0 100 timetz_ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 1357 ( timetz_gt PGUID 12 f t t t 2 f 16 =
"1266 1266" 100 0 0 100 timetz_gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 1358 ( timetz_cmp PGUID 12 f t t t 2 f 23 =
"1266 1266" 100 0 0 100 timetz_cmp - 0 ));
DESCR("less-equal-greater");
/* NZ overloading for timetzdate_pl (we add define for oid so we can =
test in datetimetz_timestamp) */
DATA(insert OID =3D 1359 ( timestamp PGUID 12 f t t t 2 f 1184 =
"1082 1266" 100 0 0 100 datetimetz_timestamp - 0 ));
DESCR("convert date and time with time zone to timestamp");
#define DATETIMETZ_TIMESTAMP_D_T_2 1359 /* date, timetz */
DATA(insert OID =3D 1362 ( time PGUID 12 f t t t 1 f 1083 =
"1083" 100 0 0 100 noop - 0 ));
DESCR("convert (noop)");
DATA(insert OID =3D 1364 ( time PGUID 14 f t f t 1 f 1083 =
"702" 100 0 0 100 "select time(timestamp($1))" - 0 ));
DESCR("convert abstime to time");
DATA(insert OID =3D 1365 ( abstime PGUID 12 f t f t 1 f 702 =
"702" 100 0 0 100 noop - 0 ));
DESCR("convert (noop)");
DATA(insert OID =3D 1368 ( timestamp PGUID 12 f t f t 1 f 1184 =
"1184" 100 0 0 100 noop - 0 ));
DESCR("convert (noop)");
DATA(insert OID =3D 1369 ( interval PGUID 12 f t t t 1 f 1186 =
"1186" 100 0 0 100 noop - 0 ));
DESCR("convert (noop)");
DATA(insert OID =3D 1370 ( interval PGUID 12 f t t t 1 f 1186 =
"1083" 100 0 0 100 time_interval - 0 ));
DESCR("convert time to interval");
DATA(insert OID =3D 1371 ( date PGUID 12 f t t t 1 f 1082 =
"1082" 100 0 0 100 noop - 0 ));
DESCR("convert (noop)");
DATA(insert OID =3D 1372 ( char_length PGUID 12 f t t t 1 f 23 =
"1042" 100 0 0 100 bpcharlen - 0 ));
DESCR("character length");
DATA(insert OID =3D 1373 ( char_length PGUID 12 f t t t 1 f 23 =
"1043" 100 0 0 100 varcharlen - 0 ));
DESCR("character length");
DATA(insert OID =3D 1374 ( octet_length PGUID 12 f t t t 1 f =
23 "25" 100 0 0 100 textoctetlen - 0 ));
DESCR("octet length");
DATA(insert OID =3D 1375 ( octet_length PGUID 12 f t t t 1 f =
23 "1042" 100 0 0 100 bpcharoctetlen - 0 ));
DESCR("octet length");
DATA(insert OID =3D 1376 ( octet_length PGUID 12 f t t t 1 f =
23 "1043" 100 0 0 100 varcharoctetlen - 0 ));
DESCR("octet length");
DATA(insert OID =3D 1377 ( time_larger PGUID 12 f t t t 2 f 1083 =
"1083 1083" 100 0 0 100 time_larger - 0 ));
DESCR("larger of two");
DATA(insert OID =3D 1378 ( time_smaller PGUID 12 f t t t 2 f 1083 =
"1083 1083" 100 0 0 100 time_smaller - 0 ));
DESCR("smaller of two");
DATA(insert OID =3D 1379 ( timetz_larger PGUID 12 f t t t 2 f 1266 =
"1266 1266" 100 0 0 100 timetz_larger - 0 ));
DESCR("larger of two");
DATA(insert OID =3D 1380 ( timetz_smaller PGUID 12 f t t t 2 f 1266 =
"1266 1266" 100 0 0 100 timetz_smaller - 0 ));
DESCR("smaller of two");
DATA(insert OID =3D 1381 ( char_length PGUID 12 f t t t 1 f 23 =
"25" 100 0 0 100 textlen - 0 ));
DESCR("length");
/* NZ don't bother overloading abstime, reltime date_parts - =
boolinunless NDE uses abstime/reltime types */
DATA(insert OID =3D 1382 ( date_part PGUID 14 f t f t 2 f 701 "25 =
702" 100 0 0 100 "select date_part($1, timestamp($2))" - 0 ));
DESCR("extract field from abstime");
/* NZ overloading for date_part (we add defines for oids so we can test =
in timestamp_part and interval_part) */
DATA(insert OID =3D 1384 ( date_part PGUID 12 f t t t 2 f 23 "1043 =
1082" 100 0 0 100 timestamp_part - 0 ));
DESCR("extract field from date");
#define DATE_PART_D 1384 /* (text and) date */
DATA(insert OID =3D 1385 ( date_part PGUID 12 f t t t 2 f 23 "1043 =
1083" 100 0 0 100 interval_part - 0 ));
DESCR("extract field from time");
#define DATE_PART_T 1385 /* (text and) time */
/* NZ timestamp_age now overloaded */
DATA(insert OID =3D 1386 ( age PGUID 12 f t f t 1 f 1186 =
"1184" 100 0 0 100 timestamp_age - 0 ));
DESCR("date difference from today preserving months and years");
DATA(insert OID =3D 1387 ( timetz PGUID 12 f t t t 1 f 1266 =
"1266" 100 0 0 100 noop - 0 ));
DESCR("noop conversion");
DATA(insert OID =3D 1388 ( timetz PGUID 12 f t t t 1 f 1266 =
"1184" 100 0 0 100 timestamp_timetz - 0 ));
DESCR("convert timestamp to timetz");
DATA(insert OID =3D 1389 ( isfinite PGUID 12 f t t t 1 f 16 "1184" =
100 0 0 100 timestamp_finite - 0 ));
DESCR("boolean test");
DATA(insert OID =3D 1390 ( isfinite PGUID 12 f t t t 1 f 16 "1186" =
100 0 0 100 interval_finite - 0 ));
DESCR("boolean test");
DATA(insert OID =3D 1391 ( factorial PGUID 12 f t t t 1 f 20 =
"21" 100 0 0 100 int2fac - 0 ));
DESCR("factorial");
DATA(insert OID =3D 1392 ( factorial PGUID 12 f t t t 1 f 20 =
"23" 100 0 0 100 int4fac - 0 ));
DESCR("factorial");
DATA(insert OID =3D 1393 ( factorial PGUID 12 f t t t 1 f 20 =
"20" 100 0 0 100 int8fac - 0 ));
DESCR("factorial");
DATA(insert OID =3D 1394 ( abs PGUID 12 f t t t 1 f 700 =
"700" 100 0 0 100 float4abs - 0 ));
DESCR("absolute value");
DATA(insert OID =3D 1395 ( abs PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 float8abs - 0 ));
DESCR("absolute value");
DATA(insert OID =3D 1396 ( abs PGUID 12 f t t t 1 f 20 =
"20" 100 0 0 100 int8abs - 0 ));
DESCR("absolute value");
DATA(insert OID =3D 1397 ( abs PGUID 12 f t t t 1 f 23 =
"23" 100 0 0 100 int4abs - 0 ));
DESCR("absolute value");
DATA(insert OID =3D 1398 ( abs PGUID 12 f t t t 1 f 21 =
"21" 100 0 0 100 int2abs - 0 ));
DESCR("absolute value");
/* OIDS 1400 - 1499 */
DATA(insert OID =3D 1400 ( name PGUID 12 f t t t 1 f 19 "1043" =
100 0 0 100 text_name - 0 ));
DESCR("convert varchar to name");
DATA(insert OID =3D 1401 ( varchar PGUID 12 f t t t 1 f 1043 "19" =
100 0 0 100 name_text - char_sizer ));
DESCR("convert name to varchar");
DATA(insert OID =3D 1402 ( float4 PGUID 12 f t t t 1 f 700 =
"700" 100 0 0 100 noop - 0 ));
DESCR("convert float4 to float4 (no-op)");
DATA(insert OID =3D 1403 ( int2 PGUID 12 f t t t 1 f 21 "21" =
100 0 0 100 noop - 0 ));
DESCR("convert (no-op)");
DATA(insert OID =3D 1404 ( float8 PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 noop - 0 ));
DESCR("convert (no-op)");
DATA(insert OID =3D 1405 ( int4 PGUID 12 f t t t 1 f 23 "23" =
100 0 0 100 noop - 0 ));
DESCR("convert (no-op)");
DATA(insert OID =3D 1417 ( isnottrue PGUID 12 f t t f 1 f 16 =
"16" 100 0 0 100 isnottrue - 0 ));
DESCR("bool is not true (ie, false or unknown)");
DATA(insert OID =3D 1418 ( isnotfalse PGUID 12 f t t f 1 f 16 =
"16" 100 0 0 100 isnotfalse - 0 ));
DESCR("bool is not false (ie, true or unknown)");
DATA(insert OID =3D 1419 ( time PGUID 12 f t t t 1 f 1083 =
"1186" 100 0 0 100 interval_time - 0 ));
DESCR("convert interval to time");
/* OIDS 1500 - 1599 */
DATA(insert OID =3D 1569 ( like PGUID 12 f t t t 2 f 16 =
"1043 1043" 100 0 0 100 varcharlike - 0 ));
DESCR("matches LIKE expression");
DATA(insert OID =3D 1570 ( notlike PGUID 12 f t t t 2 f 16 =
"1043 1043" 100 0 0 100 varcharnlike - 0 ));
DESCR("does not match LIKE expression");
DATA(insert OID =3D 1571 ( like PGUID 12 f t t t 2 f 16 =
"19 25" 100 0 0 100 namelike - 0 ));
DESCR("matches LIKE expression");
DATA(insert OID =3D 1572 ( notlike PGUID 12 f t t t 2 f 16 =
"19 25" 100 0 0 100 namenlike - 0 ));
DESCR("does not match LIKE expression");
DATA(insert OID =3D 1573 ( int8 PGUID 12 f t t t 1 f 20 =
"20" 100 0 0 100 noop - 0 ));
DESCR("convert int8 to int8 (no-op)");
/* SEQUENCEs nextval & currval functions */
DATA(insert OID =3D 1574 ( nextval PGUID 12 f t f t 1 f 23 =
"25" 100 0 0 100 nextval - 0 ));
DESCR("sequence next value");
DATA(insert OID =3D 1575 ( currval PGUID 12 f t f t 1 f 23 =
"25" 100 0 0 100 currval - 0 ));
DESCR("sequence current value");
DATA(insert OID =3D 1576 ( setval PGUID 12 f t f t 2 f 23 =
"25 23" 100 0 0 100 setval - 0 ));
DESCR("set sequence value");
DATA(insert OID =3D 1765 ( setval PGUID 12 f t f t 3 f 23 =
"25 23 16" 100 0 0 100 setval_and_iscalled - 0 ));
DESCR("set sequence value and iscalled status");
DATA(insert OID =3D 1598 ( random PGUID 12 f t f t 0 f 701 =
"0" 100 0 0 100 drandom - 0 ));
DESCR("random value");
DATA(insert OID =3D 1599 ( setseed PGUID 12 f t f t 1 f 23 =
"701" 100 0 0 100 setseed - 0 ));
DESCR("set random seed");
/* OIDS 1600 - 1699 */
DATA(insert OID =3D 1600 ( asin PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 dasin - 0 ));
DESCR("arcsine");
DATA(insert OID =3D 1601 ( acos PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 dacos - 0 ));
DESCR("arccosine");
DATA(insert OID =3D 1602 ( atan PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 datan - 0 ));
DESCR("arctangent");
DATA(insert OID =3D 1603 ( atan2 PGUID 12 f t t t 2 f 701 =
"701 701" 100 0 0 100 datan2 - 0 ));
DESCR("arctangent, two arguments");
DATA(insert OID =3D 1604 ( sin PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 dsin - 0 ));
DESCR("sine");
DATA(insert OID =3D 1605 ( cos PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 dcos - 0 ));
DESCR("cosine");
DATA(insert OID =3D 1606 ( tan PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 dtan - 0 ));
DESCR("tangent");
DATA(insert OID =3D 1607 ( cot PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 dcot - 0 ));
DESCR("cotangent");
DATA(insert OID =3D 1608 ( degrees PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 degrees - 0 ));
DESCR("radians to degrees");
DATA(insert OID =3D 1609 ( radians PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 radians - 0 ));
DESCR("degrees to radians");
DATA(insert OID =3D 1610 ( pi PGUID 12 f t t t 0 f 701 =
"0" 100 0 0 100 dpi - 0 ));
DESCR("PI");
DATA(insert OID =3D 1618 ( interval_mul PGUID 12 f t t t 2 f 1186 =
"1186 701" 100 0 0 100 interval_mul - 0 ));
DESCR("multiply interval");
DATA(insert OID =3D 1028 ( interval_int_mul PGUID 12 f t t t 2 f 1186 =
"1186 23" 100 0 0 100 interval_int_mul - 0 ));
DESCR("multiply interval");
DATA(insert OID =3D 1008 ( int_interval_mul PGUID 12 f t t t 2 f 1186 =
"23 1186" 100 0 0 100 int_interval_mul - 0 ));
DESCR("multiply interval");
DATA(insert OID =3D 1027 ( interval_int_div PGUID 12 f t t t 2 f 1186 =
"1186 23" 100 0 0 100 interval_int_div - 0 ));
DESCR("multiply interval");
DATA(insert OID =3D 1619 ( varchar PGUID 12 f t t t 1 f 1043 =
"23" 100 0 0 100 int4_varchar - int4_text_sizer ));
DESCR("convert int4 to varchar");
DATA(insert OID =3D 1620 ( ascii PGUID 12 f t t t 1 f 23 =
"1043" 100 0 0 100 ascii - 0 ));
DESCR("convert first char to int4");
DATA(insert OID =3D 1621 ( chr PGUID 12 f t t t 1 f 1042 =
"23" 100 0 0 100 chr - chr_sizer ));
DESCR("convert int4 to char");
DATA(insert OID =3D 1622 ( repeat PGUID 12 f t t t 2 f 1043 =
"1042 23" 100 0 0 100 repeat - repeat_sizer ));
DESCR("replicate string int4 times");
DATA(insert OID =3D 1623 ( varchar PGUID 12 f t t t 1 f 1043 =
"20" 100 0 0 100 int8_varchar - int8_text_sizer ));
DESCR("convert int8 to varchar");
DATA(insert OID =3D 1624 ( mul_d_interval PGUID 12 f t t t 2 f 1186 =
"701 1186" 100 0 0 100 mul_d_interval - 0 ));
DATA(insert OID =3D 1633 ( texticlike PGUID 12 f t t t 2 f 16 =
"25 25" 100 0 0 100 texticlike - 0 ));
DESCR("matches LIKE expression, case-insensitive");
DATA(insert OID =3D 1634 ( texticnlike PGUID 12 f t t t 2 f 16 =
"25 25" 100 0 0 100 texticnlike - 0 ));
DESCR("does not match LIKE expression, case-insensitive");
DATA(insert OID =3D 1635 ( nameiclike PGUID 12 f t t t 2 f 16 =
"19 25" 100 0 0 100 nameiclike - 0 ));
DESCR("matches LIKE expression, case-insensitive");
DATA(insert OID =3D 1636 ( nameicnlike PGUID 12 f t t t 2 f 16 =
"19 25" 100 0 0 100 nameicnlike - 0 ));
DESCR("does not match LIKE expression, case-insensitive");
DATA(insert OID =3D 1637 ( like_escape PGUID 12 f t t t 2 f 1043 =
"1043 1043" 100 0 0 100 like_escape - wag_sizer ));
DESCR("convert match pattern to use backslash escapes");
DATA(insert OID =3D 1689 ( update_pwd PGUID 12 f t f t 0 f 0 "" =
100 0 0 100 update_pwd - 0 ));
DESCR("update pwd file");
/* Oracle Compatibility Related Functions - boolinBy Edmund Mergl =
<E.Mergl@...> */
DATA(insert OID =3D 868 ( strpos PGUID 12 f t t t 2 f 23 "1043 =
1043" 100 0 0 100 varcharpos - 0 ));
DESCR("find position of substring");
DATA(insert OID =3D 870 ( lower PGUID 12 f t t t 1 f 1042 =
"1042" 100 0 0 100 lower - lower_sizer ));
DESCR("lowercase");
DATA(insert OID =3D 871 ( upper PGUID 12 f t t t 1 f 1042 =
"1042" 100 0 0 100 upper - upper_sizer ));
DESCR("uppercase");
DATA(insert OID =3D 872 ( initcap PGUID 12 f t t t 1 f 1042 =
"1042" 100 0 0 100 initcap - upper_sizer ));
DESCR("capitalize each word");
DATA(insert OID =3D 873 ( lpad PGUID 12 f t t t 3 f 1043 "1042 =
23 1042" 100 0 0 100 lpad - pad_sizer ));
DESCR("left-pad string to length");
DATA(insert OID =3D 874 ( rpad PGUID 12 f t t t 3 f 1043 "1042 =
23 1042" 100 0 0 100 rpad - pad_sizer ));
DESCR("right-pad string to length");
DATA(insert OID =3D 875 ( ltrim PGUID 12 f t t t 2 f 1043 "1042 =
1042" 100 0 0 100 ltrim - trim_sizer ));
DESCR("left-pad string to length");
DATA(insert OID =3D 876 ( rtrim PGUID 12 f t t t 2 f 1043 "1042 =
1042" 100 0 0 100 rtrim - trim_sizer ));
DESCR("right-pad string to length");
DATA(insert OID =3D 877 ( substr PGUID 12 f t t t 3 f 1043 "1042 =
23 23" 100 0 0 100 varchar_substr - substr_sizer ));
DESCR("return portion of string");
DATA(insert OID =3D 878 ( translate PGUID 12 f t t t 3 f 1043 "1042 =
1043 1043" 100 0 0 100 translate - upper_sizer ));
DESCR("modify string by substring replacement");
/* NZ lpad 2-arg version was done via select */
DATA(insert OID =3D 879 ( lpad PGUID 12 f t t t 2 f 1043 "1042 =
23" 100 0 0 100 lpad - pad_sizer ));
DESCR("left-pad string to length");
/* NZ rpad 2-arg version was done via select */
DATA(insert OID =3D 880 ( rpad PGUID 12 f t t t 2 f 1043 "1042 =
23" 100 0 0 100 rpad - pad_sizer ));
DESCR("right-pad string to length");
/* NZ ltrim 1-arg version was done via select */
DATA(insert OID =3D 881 ( ltrim PGUID 12 f t t t 1 f 1043 =
"1042" 100 0 0 100 ltrim - trim_sizer ));
DESCR("remove initial characters from string");
/* NZ rtrim 1-arg version was done via select */
DATA(insert OID =3D 882 ( rtrim PGUID 12 f t t t 1 f 1043 =
"1042" 100 0 0 100 rtrim - trim_sizer ));
DESCR("remove trailing characters from string");
/* NZ substr 2-arg version was done via select */
DATA(insert OID =3D 883 ( substr PGUID 12 f t t t 2 f 1043 "1042 =
23" 100 0 0 100 varchar_substr - substr_sizer ));
DESCR("return portion of string");
DATA(insert OID =3D 884 ( btrim PGUID 12 f t t t 2 f 1043 "1043 =
1043" 100 0 0 100 btrim - trim_sizer ));
DESCR("trim both ends of string");
/* NZ btrim 1-arg version was done via select */
DATA(insert OID =3D 885 ( btrim PGUID 12 f t t t 1 f 1043 =
"1043" 100 0 0 100 btrim - trim_sizer ));
DESCR("trim both ends of string");
/* NZ added these to avoid returning text type */
DATA(insert OID =3D 888 ( lower PGUID 12 f t t t 1 f 1043 =
"1043" 100 0 0 100 lower - lower_sizer ));
DESCR("lowercase");
DATA(insert OID =3D 889 ( upper PGUID 12 f t t t 1 f 1043 =
"1043" 100 0 0 100 upper - upper_sizer ));
DESCR("uppercase");
DATA(insert OID =3D 890 ( lpad PGUID 12 f t t t 3 f 1043 "1043 =
23 1043" 100 0 0 100 lpad - pad_sizer ));
DESCR("left-pad string to length");
DATA(insert OID =3D 891 ( rpad PGUID 12 f t t t 3 f 1043 "1043 =
23 1043" 100 0 0 100 rpad - pad_sizer ));
DESCR("right-pad string to length");
DATA(insert OID =3D 892 ( ltrim PGUID 12 f t t t 2 f 1043 "1043 =
1043" 100 0 0 100 ltrim - trim_sizer ));
DESCR("left-pad string to length");
DATA(insert OID =3D 893 ( rtrim PGUID 12 f t t t 2 f 1043 "1043 =
1043" 100 0 0 100 rtrim - trim_sizer ));
DESCR("remove trailing characters from string");
DATA(insert OID =3D 894 ( lpad PGUID 12 f t t t 2 f 1043 "1043 =
23" 100 0 0 100 lpad - pad_sizer ));
DESCR("left-pad string to length");
DATA(insert OID =3D 895 ( rpad PGUID 12 f t t t 2 f 1043 "1043 =
23" 100 0 0 100 rpad - pad_sizer ));
DESCR("right-pad string to length");
DATA(insert OID =3D 896 ( ltrim PGUID 12 f t t t 1 f 1043 =
"1043" 100 0 0 100 ltrim - trim_sizer ));
DESCR("remove initial characters from string");
DATA(insert OID =3D 897 ( rtrim PGUID 12 f t t t 1 f 1043 =
"1043" 100 0 0 100 rtrim - trim_sizer ));
DESCR("remove trailing characters from string");
DATA(insert OID =3D 898 ( initcap PGUID 12 f t t t 1 f 1043 =
"1043" 100 0 0 100 initcap - upper_sizer ));
DESCR("capitalize each word");
DATA(insert OID =3D 899 ( repeat PGUID 12 f t t t 2 f 1043 "1043 =
23" 100 0 0 100 repeat - repeat_sizer ));
DESCR("replicate string int4 times");
DATA(insert OID =3D 862 ( substr PGUID 12 f t t t 3 f 1043 "1043 =
23 23" 100 0 0 100 varchar_substr - substr_sizer ));
DESCR("return portion of string");
DATA(insert OID =3D 863 ( substr PGUID 12 f t t t 2 f 1043 "1043 =
23" 100 0 0 100 varchar_substr - substr_sizer ));
DESCR("return portion of string");
DATA(insert OID =3D 864 ( substring PGUID 12 f t t t 3 f 1043 "1043 =
23 23" 100 0 0 100 varchar_substr - substr_sizer ));
DESCR("return portion of string");
DATA(insert OID =3D 865 ( substring PGUID 12 f t t t 2 f 1043 "1043 =
23" 100 0 0 100 varchar_substr - substr_sizer ));
DESCR("return portion of string");
DATA(insert OID =3D 866 ( translate PGUID 12 f t t t 3 f 1043 "1043 =
1043 1043" 100 0 0 100 translate - upper_sizer ));
DESCR("modify string by substring replacement");
DATA(insert OID =3D 867 ( varchar PGUID 12 f t t t 1 f 1043 =
"701" 100 0 0 100 float8_varchar - wag_sizer ));
DESCR("convert float8 to varchar");
DATA(insert OID =3D 869 ( varchar PGUID 12 f t t t 1 f 1043 =
"700" 100 0 0 100 float4_varchar - wag_sizer ));
DESCR("convert float4 to varchar");
DATA(insert OID =3D 900 ( varchar PGUID 12 f t t t 1 f 1043 =
"1700" 100 0 0 100 numeric_varchar - wag_sizer ));
DESCR("convert numeric to varchar");
DATA(insert OID =3D 936 ( substring PGUID 12 f t t t 3 f 1043 "1042 =
23 23" 100 0 0 100 varchar_substr - substr_sizer ));
DESCR("return portion of string");
/* NZ substring 1-arg version was done via select */
DATA(insert OID =3D 937 ( substring PGUID 12 f t t t 2 f 1043 "1042 =
23" 100 0 0 100 varchar_substr - substr_sizer ));
DESCR("return portion of string");
/* for multi-byte support */
DATA(insert OID =3D 1039 ( getdatabaseencoding PGUID 12 f t f t 0 =
f 19 "0" 100 0 0 100 getdatabaseencoding - 0 ));
DESCR("encoding name of current database");
DATA(insert OID =3D 1295 ( char_to_encoding PGUID 12 f t f t 1 f 23 =
"19" 100 0 0 100 char_to_encoding - 0 ));
DESCR("convert encoding name to encoding id");
DATA(insert OID =3D 1597 ( encoding_to_char PGUID 12 f t f t 1 f 19 =
"23" 100 0 0 100 encoding_to_char - 0 ));
DESCR("convert encoding id to encoding name");
DATA(insert OID =3D 1638 ( oidgt PGUID 12 f t t t 2 f 16 =
"26 26" 100 0 0 100 oidgt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 1639 ( oidge PGUID 12 f t t t 2 f 16 =
"26 26" 100 0 0 100 oidge - 0 ));
DESCR("greater-than-or-equal");
/* System-view support functions */
DATA(insert OID =3D 1640 ( get_ruledef PGUID 12 f t f t 1 f 1043 =
"19" 100 0 0 100 get_ruledef - wag_sizer ));
DESCR("source text of a rule");
DATA(insert OID =3D 1641 ( get_viewdef PGUID 12 f t f t 1 f 1043 =
"19" 100 0 0 100 get_viewdef - wag_sizer ));
DESCR("select statement of a view");
DATA(insert OID =3D 1642 ( get_userbyid PGUID 12 f t f t 1 f 19 =
"23" 100 0 0 100 get_userbyid - 0 ));
DESCR("user name by UID (with fallback)");
DATA(insert OID =3D 1643 ( get_indexdef PGUID 12 f t f t 1 f 1043 =
"26" 100 0 0 100 get_indexdef - wag_sizer ));
DESCR("index description");
/* Generic referential integrity constraint triggers */
DATA(insert OID =3D 1644 ( RI_FKey_check_ins PGUID 12 f t f t 0 f 0 =
"" 100 0 0 100 RI_FKey_check_ins - 0 ));
DESCR("referential integrity FOREIGN KEY ... REFERENCES");
DATA(insert OID =3D 1645 ( RI_FKey_check_upd PGUID 12 f t f t 0 f 0 =
"" 100 0 0 100 RI_FKey_check_upd - 0 ));
DESCR("referential integrity FOREIGN KEY ... REFERENCES");
DATA(insert OID =3D 1646 ( RI_FKey_cascade_del PGUID 12 f t f t 0 f 0 =
"" 100 0 0 100 RI_FKey_cascade_del - 0 ));
DESCR("referential integrity ON DELETE CASCADE");
DATA(insert OID =3D 1647 ( RI_FKey_cascade_upd PGUID 12 f t f t 0 f 0 =
"" 100 0 0 100 RI_FKey_cascade_upd - 0 ));
DESCR("referential integrity ON UPDATE CASCADE");
DATA(insert OID =3D 1648 ( RI_FKey_restrict_del PGUID 12 f t f t 0 f 0 =
"" 100 0 0 100 RI_FKey_restrict_del - 0 ));
DESCR("referential integrity ON DELETE RESTRICT");
DATA(insert OID =3D 1649 ( RI_FKey_restrict_upd PGUID 12 f t f t 0 f 0 =
"" 100 0 0 100 RI_FKey_restrict_upd - 0 ));
DESCR("referential integrity ON UPDATE RESTRICT");
DATA(insert OID =3D 1650 ( RI_FKey_setnull_del PGUID 12 f t f t 0 f 0 =
"" 100 0 0 100 RI_FKey_setnull_del - 0 ));
DESCR("referential integrity ON DELETE SET NULL");
DATA(insert OID =3D 1651 ( RI_FKey_setnull_upd PGUID 12 f t f t 0 f 0 =
"" 100 0 0 100 RI_FKey_setnull_upd - 0 ));
DESCR("referential integrity ON UPDATE SET NULL");
DATA(insert OID =3D 1652 ( RI_FKey_setdefault_del PGUID 12 f t f t 0 f =
0 "" 100 0 0 100 RI_FKey_setdefault_del - 0 ));
DESCR("referential integrity ON DELETE SET DEFAULT");
DATA(insert OID =3D 1653 ( RI_FKey_setdefault_upd PGUID 12 f t f t 0 f =
0 "" 100 0 0 100 RI_FKey_setdefault_upd - 0 ));
DESCR("referential integrity ON UPDATE SET DEFAULT");
DATA(insert OID =3D 1654 ( RI_FKey_noaction_del PGUID 12 f t f t 0 f 0 =
"" 100 0 0 100 RI_FKey_noaction_del - 0 ));
DESCR("referential integrity ON DELETE NO ACTION");
DATA(insert OID =3D 1655 ( RI_FKey_noaction_upd PGUID 12 f t f t 0 f 0 =
"" 100 0 0 100 RI_FKey_noaction_upd - 0 ));
DESCR("referential integrity ON UPDATE NO ACTION");
DATA(insert OID =3D 1691 ( boolle PGUID 12 f t t t 2 f 16 =
"16 16" 100 0 0 100 boolle - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 1692 ( boolge PGUID 12 f t t t 2 f 16 =
"16 16" 100 0 0 100 boolge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 1693 ( btboolcmp PGUID 12 f t t t 2 f 23 =
"16 16" 100 0 0 100 btboolcmp - 0 ));
DESCR("btree less-equal-greater");
//DATA(insert OID =3D 1696 ( timetz_hash PGUID 12 f t t t 1 f 23 =
"1266" 100 0 0 100 timetz_hash - 0 ));
//DESCR("hash");
//DATA(insert OID =3D 1697 ( interval_hash PGUID 12 f t t t 1 f =
23 "1186" 100 0 0 100 interval_hash - 0 ));
//DESCR("hash");
/* OID's 1700 - boolin1799 NUMERIC data type */
DATA(insert OID =3D 1701 ( numeric_in PGUID 12 f t t t 3 f =
1700 "0 26 23" 100 0 0 100 numeric_in - numeric_default_sizer ));
DESCR("(internal)");
DATA(insert OID =3D 1702 ( numeric_out PGUID 12 f t t t 1 f =
23 "0" 100 0 0 100 numeric_out - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1703 ( numeric PGUID 12 f t t t 2 f =
1700 "1700 23" 100 0 0 100 numeric - numeric_typmod_sizer ));
DESCR("adjust numeric to typmod precision/scale");
DATA(insert OID =3D 1704 ( numeric_abs PGUID 12 f t t t 1 f =
1700 "1700" 100 0 0 100 numeric_abs - numeric_noop_sizer ));
DESCR("absolute value");
DATA(insert OID =3D 1705 ( abs PGUID 12 f t t t 1 f =
1700 "1700" 100 0 0 100 numeric_abs - numeric_noop_sizer ));
DESCR("absolute value");
DATA(insert OID =3D 1706 ( sign PGUID 12 f t t t 1 f =
1700 "1700" 100 0 0 100 numeric_sign - numeric_sign_sizer ));
DESCR("sign2 of value");
DATA(insert OID =3D 1707 ( round PGUID 12 f t t t 2 f =
1700 "1700 23" 100 0 0 100 numeric_round - numeric_round_sizer ));
DESCR("value rounded to 'scale'");
DATA(insert OID =3D 1708 ( round PGUID 12 f t t t 1 f =
1700 "1700" 100 0 0 100 numeric_round - numeric_round_sizer ));
DESCR("value rounded to 'scale' of zero");
DATA(insert OID =3D 1709 ( trunc PGUID 12 f t t t 2 f =
1700 "1700 23" 100 0 0 100 numeric_trunc - numeric_trunc_sizer ));
DESCR("value truncated to 'scale'");
DATA(insert OID =3D 1710 ( trunc PGUID 12 f t t t 1 f =
1700 "1700" 100 0 0 100 numeric_trunc - numeric_trunc_sizer ));
DESCR("value truncated to 'scale' of zero");
DATA(insert OID =3D 1711 ( ceil PGUID 12 f t t t 1 f =
1700 "1700" 100 0 0 100 numeric_ceil - numeric_ceil_floor_sizer ));
DESCR("smallest integer >=3D value");
DATA(insert OID =3D 1712 ( floor PGUID 12 f t t t 1 f =
1700 "1700" 100 0 0 100 numeric_floor - numeric_ceil_floor_sizer ));
DESCR("largest integer <=3D value");
DATA(insert OID =3D 1718 ( numeric_eq PGUID 12 f t t t 2 f =
16 "1700 1700" 100 0 0 100 numeric_eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 1719 ( numeric_ne PGUID 12 f t t t 2 f =
16 "1700 1700" 100 0 0 100 numeric_ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 1720 ( numeric_gt PGUID 12 f t t t 2 f =
16 "1700 1700" 100 0 0 100 numeric_gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 1721 ( numeric_ge PGUID 12 f t t t 2 f =
16 "1700 1700" 100 0 0 100 numeric_ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 1722 ( numeric_lt PGUID 12 f t t t 2 f =
16 "1700 1700" 100 0 0 100 numeric_lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 1723 ( numeric_le PGUID 12 f t t t 2 f =
16 "1700 1700" 100 0 0 100 numeric_le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 1724 ( numeric_add PGUID 12 f t t t 2 f =
1700 "1700 1700" 100 0 0 100 numeric_add - numeric_add_sizer ));
DESCR("add");
DATA(insert OID =3D 1725 ( numeric_sub PGUID 12 f t t t 2 f =
1700 "1700 1700" 100 0 0 100 numeric_sub - numeric_sub_sizer ));
DESCR("subtract");
DATA(insert OID =3D 1726 ( numeric_mul PGUID 12 f t t t 2 f =
1700 "1700 1700" 100 0 0 100 numeric_mul - numeric_mul_sizer ));
DESCR("multiply");
DATA(insert OID =3D 1727 ( numeric_div PGUID 12 f t t t 2 f =
1700 "1700 1700" 100 0 0 100 numeric_div - numeric_div_sizer ));
DESCR("divide");
DATA(insert OID =3D 1728 ( mod PGUID 12 f t t t 2 f =
1700 "1700 1700" 100 0 0 100 numeric_mod - numeric_mod_sizer ));
DESCR("modulus");
DATA(insert OID =3D 1729 ( numeric_mod PGUID 12 f t t t 2 f =
1700 "1700 1700" 100 0 0 100 numeric_mod - numeric_mod_sizer ));
DESCR("modulus");
DATA(insert OID =3D 1731 ( numeric_sqrt PGUID 12 f t t t 1 f =
1700 "1700" 100 0 0 100 numeric_sqrt - numeric_default_sizer ));
DESCR("square root");
DATA(insert OID =3D 1733 ( numeric_exp PGUID 12 f t t t 1 f =
1700 "1700" 100 0 0 100 numeric_exp - numeric_default_sizer ));
DESCR("e raised to the power of n");
DATA(insert OID =3D 1735 ( numeric_ln PGUID 12 f t t t 1 f =
1700 "1700" 100 0 0 100 numeric_ln - numeric_default_sizer ));
DESCR("natural logarithm of n");
DATA(insert OID =3D 1737 ( numeric_log PGUID 12 f t t t 2 f =
1700 "1700 1700" 100 0 0 100 numeric_log - numeric_default_sizer ));
DESCR("logarithm base m of n");
DATA(insert OID =3D 1739 ( numeric_power PGUID 12 f t t t 2 f =
1700 "1700 1700" 100 0 0 100 numeric_power - numeric_default_sizer ));
DESCR("m raised to the power of n");
DATA(insert OID =3D 1740 ( numeric PGUID 12 f t t t 1 f =
1700 "23" 100 0 0 100 int4_numeric - int4_numeric_sizer ));
DESCR("(internal)");
DATA(insert OID =3D 1742 ( numeric PGUID 12 f t t t 1 f =
1700 "700" 100 0 0 100 float4_numeric - float_numeric_sizer ));
DESCR("(internal)");
DATA(insert OID =3D 1743 ( numeric PGUID 12 f t t t 1 f =
1700 "701" 100 0 0 100 float8_numeric - float_numeric_sizer ));
DESCR("(internal)");
DATA(insert OID =3D 1744 ( int4 PGUID 12 f t t t 1 f =
23 "1700" 100 0 0 100 numeric_int4 - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1745 ( float4 PGUID 12 f t t t 1 f =
700 "1700" 100 0 0 100 numeric_float4 - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1746 ( float8 PGUID 12 f t t t 1 f =
701 "1700" 100 0 0 100 numeric_float8 - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1747 ( time_pl_interval PGUID 12 f t t t 2 f =
1083 "1083 1186" 100 0 0 100 time_pl_interval - 0 ));
DESCR("plus");
DATA(insert OID =3D 1748 ( time_mi_interval PGUID 12 f t t t 2 f =
1083 "1083 1186" 100 0 0 100 time_mi_interval - 0 ));
DESCR("minus");
DATA(insert OID =3D 1210 ( time_mi_time PGUID 12 f t t t 2 f =
1186 "1083 1083" 100 0 0 100 time_mi_time - 0 ));
DESCR("minus");
DATA(insert OID =3D 1749 ( timetz_pl_interval PGUID 12 f t t t 2 f =
1266 "1266 1186" 100 0 0 100 timetz_pl_interval - 0 ));
DESCR("plus");
DATA(insert OID =3D 1750 ( timetz_mi_interval PGUID 12 f t t t 2 f =
1266 "1266 1186" 100 0 0 100 timetz_mi_interval - 0 ));
DESCR("minus");
DATA(insert OID =3D 1764 ( numeric_inc PGUID 12 f t t t 1 f =
1700 "1700" 100 0 0 100 numeric_inc - numeric_inc_sizer ));
DESCR("increment by one");
DATA(insert OID =3D 1766 ( numeric_smaller PGUID 12 f t t t 2 f =
1700 "1700 1700" 100 0 0 100 numeric_smaller - =
numeric_larger_smaller_sizer ));
DESCR("smaller of two numbers");
DATA(insert OID =3D 1767 ( numeric_larger PGUID 12 f t t t 2 f =
1700 "1700 1700" 100 0 0 100 numeric_larger - =
numeric_larger_smaller_sizer ));
DESCR("larger of two numbers");
DATA(insert OID =3D 1769 ( numeric_cmp PGUID 12 f t t t 2 f =
23 "1700 1700" 100 0 0 100 numeric_cmp - 0 ));
DESCR("compare two numbers");
DATA(insert OID =3D 1771 ( numeric_uminus PGUID 12 f t t t 1 f =
1700 "1700" 100 0 0 100 numeric_uminus - numeric_noop_sizer ));
DESCR("negate");
DATA(insert OID =3D 1779 ( int8 PGUID 12 f t t t 1 f =
20 "1700" 100 0 0 100 numeric_int8 - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1781 ( numeric PGUID 12 f t t t 1 f =
1700 "20" 100 0 0 100 int8_numeric - int8_numeric_sizer ));
DESCR("(internal)");
DATA(insert OID =3D 1782 ( numeric PGUID 12 f t t t 1 f =
1700 "21" 100 0 0 100 int2_numeric - int2_numeric_sizer ));
DESCR("(internal)");
DATA(insert OID =3D 1783 ( int2 PGUID 12 f t t t 1 f =
21 "1700" 100 0 0 100 numeric_int2 - 0 ));
DESCR("(internal)");
/* formatting */
DATA(insert OID =3D 1770 ( to_char PGUID 12 f t t t 2 f =
1043 "1184 1043" 100 0 0 100 timestamp_to_char - wag_sizer ));
DESCR("format timestamp to char");
DATA(insert OID =3D 1772 ( to_char PGUID 12 f t t t 2 f =
1043 "1700 1043" 100 0 0 100 numeric_to_char - wag_sizer ));
DESCR("format numeric to char");
DATA(insert OID =3D 1773 ( to_char PGUID 12 f t t t 2 f =
1043 "23 1043" 100 0 0 100 int4_to_char - wag_sizer ));
DESCR("format int4 to char");
DATA(insert OID =3D 1774 ( to_char PGUID 12 f t t t 2 f =
1043 "20 1043" 100 0 0 100 int8_to_char - wag_sizer ));
DESCR("format int8 to char");
DATA(insert OID =3D 1775 ( to_char PGUID 12 f t t t 2 f =
1043 "700 1043" 100 0 0 100 float4_to_char - wag_sizer ));
DESCR("format float4 to char");
DATA(insert OID =3D 1776 ( to_char PGUID 12 f t t t 2 f =
1043 "701 1043" 100 0 0 100 float8_to_char - wag_sizer ));
DESCR("format float8 to char");
/* Aarti - Bug 1318 : sizer function for to_number needs to be specified =
*/
DATA(insert OID =3D 1777 ( to_number PGUID 12 f t t t 2 f =
1700 "1043 1043" 100 0 0 100 numeric_to_number - numeric_tonumber_sizer =
));
DESCR("convert varchar to numeric");
DATA(insert OID =3D 1778 ( to_timestamp PGUID 12 f t t t 2 f =
1184 "1043 1043" 100 0 0 100 to_timestamp - 0 ));
DESCR("convert 1043 to timestamp");
DATA(insert OID =3D 1780 ( to_date PGUID 12 f t t t 2 f =
1082 "1043 1043" 100 0 0 100 to_date - 0 ));
DESCR("convert varchar to date");
DATA(insert OID =3D 1282 ( quote_ident PGUID 12 f t t t 1 f 1043 =
"1043" 100 0 0 100 quote_ident - wag_sizer ));
DESCR("quote an identifier for usage in a querystring");
DATA(insert OID =3D 1283 ( quote_literal PGUID 12 f t t t 1 f 1043 =
"1043" 100 0 0 100 quote_literal - wag_sizer ));
DESCR("quote a literal for usage in a querystring");
DATA(insert OID =3D 1798 ( oidin PGUID 12 f t t t 1 f 26 "0" =
100 0 0 100 oidin - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1799 ( oidout PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 oidout - 0 ));
DESCR("(internal)");
/* Selectivity estimators for LIKE and related operators */
DATA(insert OID =3D 1814 ( iclikesel PGUID 12 f t f t 5 f 701 =
"26 26 21 0 23" 100 0 0 100 iclikesel - 0 ));
DESCR("restriction selectivity of ILIKE");
DATA(insert OID =3D 1815 ( icnlikesel PGUID 12 f t f t 5 f 701 =
"26 26 21 0 23" 100 0 0 100 icnlikesel - 0 ));
DESCR("restriction selectivity of NOT ILIKE");
DATA(insert OID =3D 1816 ( iclikejoinsel PGUID 12 f t f t 5 f 701 =
"26 26 21 26 21" 100 0 0 100 iclikejoinsel - 0 ));
DESCR("join selectivity of ILIKE");
DATA(insert OID =3D 1817 ( icnlikejoinsel PGUID 12 f t f t 5 f 701 =
"26 26 21 26 21" 100 0 0 100 icnlikejoinsel - 0 ));
DESCR("join selectivity of NOT ILIKE");
DATA(insert OID =3D 1818 ( regexeqsel PGUID 12 f t f t 5 f 701 =
"26 26 21 0 23" 100 0 0 100 regexeqsel - 0 ));
DESCR("restriction selectivity of regex match");
DATA(insert OID =3D 1819 ( likesel PGUID 12 f t f t 5 f 701 =
"26 26 21 0 23" 100 0 0 100 likesel - 0 ));
DESCR("restriction selectivity of LIKE");
DATA(insert OID =3D 1820 ( icregexeqsel PGUID 12 f t f t 5 f 701 =
"26 26 21 0 23" 100 0 0 100 icregexeqsel - 0 ));
DESCR("restriction selectivity of case-insensitive regex match");
DATA(insert OID =3D 1821 ( regexnesel PGUID 12 f t f t 5 f 701 =
"26 26 21 0 23" 100 0 0 100 regexnesel - 0 ));
DESCR("restriction selectivity of regex non-match");
DATA(insert OID =3D 1822 ( nlikesel PGUID 12 f t f t 5 f 701 =
"26 26 21 0 23" 100 0 0 100 nlikesel - 0 ));
DESCR("restriction selectivity of NOT LIKE");
DATA(insert OID =3D 1823 ( icregexnesel PGUID 12 f t f t 5 f 701 =
"26 26 21 0 23" 100 0 0 100 icregexnesel - 0 ));
DESCR("restriction selectivity of case-insensitive regex non-match");
DATA(insert OID =3D 1824 ( regexeqjoinsel PGUID 12 f t f t 5 f 701 =
"26 26 21 26 21" 100 0 0 100 regexeqjoinsel - 0 ));
DESCR("join selectivity of regex match");
DATA(insert OID =3D 1825 ( likejoinsel PGUID 12 f t f t 5 f 701 =
"26 26 21 26 21" 100 0 0 100 likejoinsel - 0 ));
DESCR("join selectivity of LIKE");
DATA(insert OID =3D 1826 ( icregexeqjoinsel PGUID 12 f t f t 5 f 701 =
"26 26 21 26 21" 100 0 0 100 icregexeqjoinsel - 0 ));
DESCR("join selectivity of case-insensitive regex match");
DATA(insert OID =3D 1827 ( regexnejoinsel PGUID 12 f t f t 5 f 701 =
"26 26 21 26 21" 100 0 0 100 regexnejoinsel - 0 ));
DESCR("join selectivity of regex non-match");
DATA(insert OID =3D 1828 ( nlikejoinsel PGUID 12 f t f t 5 f 701 =
"26 26 21 26 21" 100 0 0 100 nlikejoinsel - 0 ));
DESCR("join selectivity of NOT LIKE");
DATA(insert OID =3D 1829 ( icregexnejoinsel PGUID 12 f t f t 5 f 701 =
"26 26 21 26 21" 100 0 0 100 icregexnejoinsel - 0 ));
DESCR("join selectivity of case-insensitive regex non-match");
/* Aggregate-related functions */
DATA(insert OID =3D 1830 ( float8_avg PGUID 12 f t t t 1 f 701 =
"1022" 100 0 0 100 float8_avg - 0 ));
DESCR("AVG aggregate final function");
DATA(insert OID =3D 1831 ( float8_variance PGUID 12 f t t t 1 f 701 =
"1022" 100 0 0 100 float8_variance - 0 ));
DESCR("VARIANCE aggregate final function");
DATA(insert OID =3D 1832 ( float8_stddev PGUID 12 f t t t 1 f 701 =
"1022" 100 0 0 100 float8_stddev - 0 ));
DESCR("STDDEV aggregate final function");
DATA(insert OID =3D 1833 ( numeric_accum PGUID 12 f t t t 2 f 1231 =
"1231 1700" 100 0 0 100 numeric_accum - 0 ));
DESCR("aggregate transition function");
DATA(insert OID =3D 1834 ( int2_accum PGUID 12 f t t t 2 f 1231 =
"1231 21" 100 0 0 100 int2_accum - 0 ));
DESCR("aggregate transition function");
DATA(insert OID =3D 1835 ( int4_accum PGUID 12 f t t t 2 f 1231 =
"1231 23" 100 0 0 100 int4_accum - 0 ));
DESCR("aggregate transition function");
DATA(insert OID =3D 1836 ( int8_accum PGUID 12 f t t t 2 f 1231 =
"1231 20" 100 0 0 100 int8_accum - 0 ));
DESCR("aggregate transition function");
DATA(insert OID =3D 1837 ( numeric_avg PGUID 12 f t t t 1 f 1700 =
"1231" 100 0 0 100 numeric_avg - 0 ));
DESCR("AVG aggregate final function");
DATA(insert OID =3D 1838 ( numeric_variance PGUID 12 f t t t 1 f 1700 =
"1231" 100 0 0 100 numeric_variance - 0 ));
DESCR("VARIANCE aggregate final function");
DATA(insert OID =3D 1839 ( numeric_stddev PGUID 12 f t t t 1 f 1700 =
"1231" 100 0 0 100 numeric_stddev - 0 ));
DESCR("STDDEV aggregate final function");
DATA(insert OID =3D 1840 ( int2_sum PGUID 12 f t t f 2 f 1700 =
"1700 21" 100 0 0 100 int2_sum - 0 ));
DESCR("SUM(int2) transition function");
DATA(insert OID =3D 1841 ( int4_sum PGUID 12 f t t f 2 f 1700 =
"1700 23" 100 0 0 100 int4_sum - 0 ));
DESCR("SUM(int4) transition function");
DATA(insert OID =3D 1842 ( int8_sum PGUID 12 f t t f 2 f 1700 =
"1700 20" 100 0 0 100 int8_sum - 0 ));
DESCR("SUM(int8) transition function");
DATA(insert OID =3D 1843 ( interval_accum PGUID 12 f t t t 2 f 1187 =
"1187 1186" 100 0 0 100 interval_accum - 0 ));
DESCR("aggregate transition function");
DATA(insert OID =3D 1844 ( interval_avg PGUID 12 f t t t 1 f 1186 =
"1187" 100 0 0 100 interval_avg - 0 ));
DESCR("AVG aggregate final function");
/* To ASCII conversion */=20
DATA(insert OID =3D 1845 ( to_ascii PGUID 12 f t t t 1 f 1043 =
"1043" 100 0 0 100 to_ascii_default - wag_sizer ));
DESCR("encode text from DB encoding to ASCII text");
DATA(insert OID =3D 1846 ( to_ascii PGUID 12 f t t t 2 f 1043 "1043 =
23" 100 0 0 100 to_ascii_enc - wag_sizer ));
DESCR("encode text from encoding to ASCII text");
DATA(insert OID =3D 1847 ( to_ascii PGUID 12 f t t t 2 f 1043 "25 =
19" 100 0 0 100 to_ascii_encname - wag_sizer ));
DESCR("encode text from encoding to ASCII text");
DATA(insert OID =3D 1848 ( interval_pl_time PGUID 12 f t t t 2 f =
1083 "1186 1083" 100 0 0 100 interval_pl_time - 0 ));
DESCR("plus");
DATA(insert OID =3D 1850 ( int28eq PGUID 12 f t t t 2 f 16 "21 =
20" 100 0 0 100 int28eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 1851 ( int28ne PGUID 12 f t t t 2 f 16 "21 =
20" 100 0 0 100 int28ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 1852 ( int28lt PGUID 12 f t t t 2 f 16 "21 =
20" 100 0 0 100 int28lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 1853 ( int28gt PGUID 12 f t t t 2 f 16 "21 =
20" 100 0 0 100 int28gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 1854 ( int28le PGUID 12 f t t t 2 f 16 "21 =
20" 100 0 0 100 int28le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 1855 ( int28ge PGUID 12 f t t t 2 f 16 "21 =
20" 100 0 0 100 int28ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 1856 ( int82eq PGUID 12 f t t t 2 f 16 "20 =
21" 100 0 0 100 int82eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 1857 ( int82ne PGUID 12 f t t t 2 f 16 "20 =
21" 100 0 0 100 int82ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 1858 ( int82lt PGUID 12 f t t t 2 f 16 "20 =
21" 100 0 0 100 int82lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 1859 ( int82gt PGUID 12 f t t t 2 f 16 "20 =
21" 100 0 0 100 int82gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 1860 ( int82le PGUID 12 f t t t 2 f 16 "20 =
21" 100 0 0 100 int82le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 1861 ( int82ge PGUID 12 f t t t 2 f 16 "20 =
21" 100 0 0 100 int82ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 1892 ( int2and PGUID 12 f t t t 2 f 21 "21 =
21" 100 0 0 100 int2and - 0 ));
DESCR("binary and");
DATA(insert OID =3D 1893 ( int2or PGUID 12 f t t t 2 f 21 "21 =
21" 100 0 0 100 int2or - 0 ));
DESCR("binary or");
DATA(insert OID =3D 1894 ( int2xor PGUID 12 f t t t 2 f 21 "21 =
21" 100 0 0 100 int2xor - 0 ));
DESCR("binary xor");
DATA(insert OID =3D 1895 ( int2not PGUID 12 f t t t 1 f 21 =
"21" 100 0 0 100 int2not - 0 ));
DESCR("binary not");
DATA(insert OID =3D 1896 ( int2shl PGUID 12 f t t t 2 f 21 "21 =
23" 100 0 0 100 int2shl - 0 ));
DESCR("binary shift left");
DATA(insert OID =3D 1897 ( int2shr PGUID 12 f t t t 2 f 21 "21 =
23" 100 0 0 100 int2shr - 0 ));
DESCR("binary shift right");
DATA(insert OID =3D 1898 ( int4and PGUID 12 f t t t 2 f 23 "23 =
23" 100 0 0 100 int4and - 0 ));
DESCR("binary and");
DATA(insert OID =3D 1899 ( int4or PGUID 12 f t t t 2 f 23 "23 =
23" 100 0 0 100 int4or - 0 ));
DESCR("binary or");
DATA(insert OID =3D 1900 ( int4xor PGUID 12 f t t t 2 f 23 "23 =
23" 100 0 0 100 int4xor - 0 ));
DESCR("binary xor");
DATA(insert OID =3D 1901 ( int4not PGUID 12 f t t t 1 f 23 =
"23" 100 0 0 100 int4not - 0 ));
DESCR("binary not");
DATA(insert OID =3D 1902 ( int4shl PGUID 12 f t t t 2 f 23 "23 =
23" 100 0 0 100 int4shl - 0 ));
DESCR("binary shift left");
DATA(insert OID =3D 1903 ( int4shr PGUID 12 f t t t 2 f 23 "23 =
23" 100 0 0 100 int4shr - 0 ));
DESCR("binary shift right");
DATA(insert OID =3D 1904 ( int8and PGUID 12 f t t t 2 f 20 "20 =
20" 100 0 0 100 int8and - 0 ));
DESCR("binary and");
DATA(insert OID =3D 1905 ( int8or PGUID 12 f t t t 2 f 20 "20 =
20" 100 0 0 100 int8or - 0 ));
DESCR("binary or");
DATA(insert OID =3D 1906 ( int8xor PGUID 12 f t t t 2 f 20 "20 =
20" 100 0 0 100 int8xor - 0 ));
DESCR("binary xor");
DATA(insert OID =3D 1907 ( int8not PGUID 12 f t t t 1 f 20 =
"20" 100 0 0 100 int8not - 0 ));
DESCR("binary not");
DATA(insert OID =3D 1908 ( int8shl PGUID 12 f t t t 2 f 20 "20 =
23" 100 0 0 100 int8shl - 0 ));
DESCR("binary shift left");
DATA(insert OID =3D 1909 ( int8shr PGUID 12 f t t t 2 f 20 "20 =
23" 100 0 0 100 int8shr - 0 ));
DESCR("binary shift right");
DATA(insert OID =3D 2501 ( int1in PGUID 12 f t t t 1 f 2500 "0" =
100 0 0 100 int1in - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 2502 ( int1out PGUID 12 f t t t 1 f 23 "0" 100 =
0 0 100 int1out - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 2503 ( int4 PGUID 12 f t t t 1 f 23 =
"2500" 100 0 0 100 i1toi4 - 0 ));
DESCR("convert int1 to int4");
DATA(insert OID =3D 2504 ( int1 PGUID 12 f t t t 1 f 2500 =
"23" 100 0 0 100 i4toi1 - 0 ));
DESCR("convert int4 to int1");
DATA(insert OID =3D 2505 ( int8 PGUID 12 f t t t 1 f 20 =
"2500" 100 0 0 100 i1toi8 - 0 ));
DESCR("convert int1 to int8");
DATA(insert OID =3D 2506 ( int1 PGUID 12 f t t t 1 f 2500 =
"20" 100 0 0 100 i8toi1 - 0 ));
DESCR("convert int8 to int1");
DATA(insert OID =3D 2507 ( int1um PGUID 12 f t t t 1 f 2500 =
"2500" 100 0 0 100 int1um - 0 ));
DESCR("negate");
/* conditional on JB_INTEGER_MATH_CHANGE =20
* DATA(insert OID =3D 2508 ( int1pl PGUID 12 f t t t 2 f 20 =
"2500 2500" 100 0 0 100 int1pl - intpl_sizer ));
* DESCR("add");
*/=20
DATA(insert OID =3D 2508 ( int1pl PGUID 12 f t t t 2 f 2500 "2500 =
2500" 100 0 0 100 int1pl - 0 ));
DESCR("add");
DATA(insert OID =3D 2509 ( int1mi PGUID 12 f t t t 2 f 2500 "2500 =
2500" 100 0 0 100 int1mi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 2510 ( int1mul PGUID 12 f t t t 2 f 2500 "2500 =
2500" 100 0 0 100 int1mul - 0 ));
DESCR("multiply");
DATA(insert OID =3D 2511 ( int1div PGUID 12 f t t t 2 f 2500 "2500 =
2500" 100 0 0 100 int1div - 0 ));
DESCR("divide");
DATA(insert OID =3D 2512 ( int1eq PGUID 12 f t t t 2 f 16 "2500 =
2500" 100 0 0 100 int1eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 2513 ( int1ne PGUID 12 f t t t 2 f 16 "2500 =
2500" 100 0 0 100 int1ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 2514 ( int1lt PGUID 12 f t t t 2 f 16 "2500 =
2500" 100 0 0 100 int1lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 2515 ( int1gt PGUID 12 f t t t 2 f 16 "2500 =
2500" 100 0 0 100 int1gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 2516 ( int1le PGUID 12 f t t t 2 f 16 "2500 =
2500" 100 0 0 100 int1le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 2517 ( int1ge PGUID 12 f t t t 2 f 16 "2500 =
2500" 100 0 0 100 int1ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 2518 ( int1fac PGUID 12 f t t t 1 f 20 "2500" =
100 0 0 100 int1fac - 0 ));
DESCR("factorial");
DATA(insert OID =3D 2519 ( int1mod PGUID 12 f t t t 2 f 2500 "2500 =
2500" 100 0 0 100 int1mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 2520 ( int1abs PGUID 12 f t t t 1 f 2500 =
"2500" 100 0 0 100 int1abs - 0 ));
DESCR("absolute value");
DATA(insert OID =3D 2536 ( int1_accum PGUID 12 f t t t 2 f 1231 "1231 =
2500" 100 0 0 100 int1_accum - 0 ));
DESCR("aggregate transition function");
DATA(insert OID =3D 2537 ( int1_sum PGUID 12 f t t f 2 f 1700 "1700 =
2500" 100 0 0 100 int1_sum - 0 ));
DESCR("SUM(int2) transition function");
DATA(insert OID =3D 2538 ( int1and PGUID 12 f t t t 2 f 2500 "2500 =
2500" 100 0 0 100 int1and - 0 ));
DESCR("binary and");
DATA(insert OID =3D 2539 ( int1or PGUID 12 f t t t 2 f 2500 "2500 =
2500" 100 0 0 100 int1or - 0 ));
DESCR("binary or");
DATA(insert OID =3D 2540 ( int1xor PGUID 12 f t t t 2 f 2500 "2500 =
2500" 100 0 0 100 int1xor - 0 ));
DESCR("binary xor");
DATA(insert OID =3D 2541 ( int1not PGUID 12 f t t t 1 f 2500 =
"2500" 100 0 0 100 int1not - 0 ));
DESCR("binary not");
DATA(insert OID =3D 2542 ( int1shl PGUID 12 f t t t 2 f 2500 "2500 =
23" 100 0 0 100 int1shl - 0 ));
DESCR("binary shift left");
DATA(insert OID =3D 2543 ( int1shr PGUID 12 f t t t 2 f 2500 "2500 =
23" 100 0 0 100 int1shr - 0 ));
DESCR("binary shift right");
DATA(insert OID =3D 2544 ( int2shl PGUID 12 f t t t 3 f 21 "21 23 =
21" 100 0 0 100 int2shl - 0 ));
DESCR("binary shift left with mask");
DATA(insert OID =3D 2545 ( int2shr PGUID 12 f t t t 3 f 21 "21 23 =
21" 100 0 0 100 int2shr - 0 ));
DESCR("binary shift right with mask");
DATA(insert OID =3D 2546 ( int4shl PGUID 12 f t t t 3 f 23 "23 23 =
23" 100 0 0 100 int4shl - 0 ));
DESCR("binary shift left with mask");
DATA(insert OID =3D 2547 ( int4shr PGUID 12 f t t t 3 f 23 "23 23 =
23" 100 0 0 100 int4shr - 0 ));
DESCR("binary shift right with mask");
DATA(insert OID =3D 2548 ( int8shl PGUID 12 f t t t 3 f 20 "20 23 =
20" 100 0 0 100 int8shl - 0 ));
DESCR("binary shift left with mask");
DATA(insert OID =3D 2549 ( int8shr PGUID 12 f t t t 3 f 20 "20 23 =
20" 100 0 0 100 int8shr - 0 ));
DESCR("binary shift right with mask");
DATA(insert OID =3D 2550 ( int1shl PGUID 12 f t t t 3 f 2500 "2500 =
23 2500" 100 0 0 100 int1shl - 0 ));
DESCR("binary shift left with mask");
DATA(insert OID =3D 2551 ( int1shr PGUID 12 f t t t 3 f 2500 "2500 =
23 2500" 100 0 0 100 int1shr - 0 ));
DESCR("binary shift right with mask");
DATA(insert OID =3D 2552 ( vspu PGUID 12 f t t t 0 f 23 "0" 100 0 0 =
100 vspu - 0 ));
DESCR("internal");
DATA(insert OID =3D 2553 ( safedivide PGUID 12 f t t f 3 f 701 "701 =
701 701" 100 0 0 100 float8safediv - 0 ));
DESCR("safe divide");
/* bug 1323 */
DATA(insert OID =3D 2554 ( int1up PGUID 12 f t t t 1 f 2500 =
"2500" 100 0 0 100 int1up - 0 ));
DATA(insert OID =3D 2555 ( int2up PGUID 12 f t t t 1 f 21 "21" =
100 0 0 100 int2up - 0 ));
DATA(insert OID =3D 2556 ( int4up PGUID 12 f t t t 1 f 23 "23" =
100 0 0 100 int4up - 0 ));
DATA(insert OID =3D 2557 ( int8up PGUID 12 f t t t 1 f 20 "20" =
100 0 0 100 int8up - 0 ));
DATA(insert OID =3D 2558 ( float4up PGUID 12 f t t t 1 f 700 =
"700" 100 0 0 100 float4up - 0 ));
DATA(insert OID =3D 2559 ( float8up PGUID 12 f t t t 1 f 701 =
"701" 100 0 0 100 float8up - 0 ));
DATA(insert OID =3D 2560 ( numeric_uplus PGUID 12 f t t t 1 f 1700 =
"1700" 100 0 0 100 numeric_uplus - numeric_noop_sizer ));
DATA(insert OID =3D 1406 ( int12eq PGUID 12 f t t t 2 f 16 =
"2500 21" 100 0 0 100 int12eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 1407 ( int21eq PGUID 12 f t t t 2 f 16 "21 =
2500" 100 0 0 100 int21eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 1408 ( int12lt PGUID 12 f t t t 2 f 16 =
"2500 21" 100 0 0 100 int12lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 1409 ( int21lt PGUID 12 f t t t 2 f 16 "21 =
2500" 100 0 0 100 int21lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 1410 ( int12gt PGUID 12 f t t t 2 f 16 =
"2500 21" 100 0 0 100 int12gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 1411 ( int21gt PGUID 12 f t t t 2 f 16 "21 =
2500" 100 0 0 100 int21gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 1412 ( int12ne PGUID 12 f t t t 2 f 16 =
"2500 21" 100 0 0 100 int12ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 1413 ( int21ne PGUID 12 f t t t 2 f 16 "21 =
2500" 100 0 0 100 int21ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 1414 ( int12le PGUID 12 f t t t 2 f 16 =
"2500 21" 100 0 0 100 int12le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 1415 ( int21le PGUID 12 f t t t 2 f 16 "21 =
2500" 100 0 0 100 int21le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 1416 ( int12ge PGUID 12 f t t t 2 f 16 =
"2500 21" 100 0 0 100 int12ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 1498 ( int21ge PGUID 12 f t t t 2 f 16 "21 =
2500" 100 0 0 100 int21ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 1499 ( int12mul PGUID 12 f t t t 2 f 21 =
"2500 21" 100 0 0 100 int12mul - 0 ));
DESCR("multiply");
DATA(insert OID =3D 1500 ( int21mul PGUID 12 f t t t 2 f 21 "21 =
2500" 100 0 0 100 int21mul - 0 ));
DESCR("multiply");
DATA(insert OID =3D 1501 ( int12div PGUID 12 f t t t 2 f 21 =
"2500 21" 100 0 0 100 int12div - 0 ));
DESCR("divide");
DATA(insert OID =3D 1502 ( int21div PGUID 12 f t t t 2 f 21 "21 =
2500" 100 0 0 100 int21div - 0 ));
DESCR("divide");
DATA(insert OID =3D 1503 ( int12mod PGUID 12 f t t t 2 f 21 =
"2500 21" 100 0 0 100 int12mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 1504 ( int21mod PGUID 12 f t t t 2 f 21 "21 =
2500" 100 0 0 100 int21mod - 0 ));
DESCR("modulus");
/* conditional on JB_INTEGER_MATH_CHANGE =20
* DATA(insert OID =3D 1505 ( int12pl PGUID 12 f t t t 2 f 20 =
"2500 21" 100 0 0 100 int12pl - intpl_sizer ));
* DESCR("add");
* DATA(insert OID =3D 1506 ( int21pl PGUID 12 f t t t 2 f 20 =
"21 2500" 100 0 0 100 int21pl - intpl_sizer ));
* DESCR("add");
*/=20
DATA(insert OID =3D 1505 ( int12pl PGUID 12 f t t t 2 f 21 =
"2500 21" 100 0 0 100 int12pl - 0 ));
DESCR("add");
DATA(insert OID =3D 1506 ( int21pl PGUID 12 f t t t 2 f 21 "21 =
2500" 100 0 0 100 int21pl - 0 ));
DESCR("add");
DATA(insert OID =3D 1507 ( int12mi PGUID 12 f t t t 2 f 21 =
"2500 21" 100 0 0 100 int12mi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 1508 ( int21mi PGUID 12 f t t t 2 f 21 "21 =
2500" 100 0 0 100 int21mi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 1509 ( int14eq PGUID 12 f t t t 2 f 16 =
"2500 23" 100 0 0 100 int14eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 1510 ( int41eq PGUID 12 f t t t 2 f 16 "23 =
2500" 100 0 0 100 int41eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 1511 ( int14lt PGUID 12 f t t t 2 f 16 =
"2500 23" 100 0 0 100 int14lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 1512 ( int41lt PGUID 12 f t t t 2 f 16 "23 =
2500" 100 0 0 100 int41lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 1513 ( int14gt PGUID 12 f t t t 2 f 16 =
"2500 23" 100 0 0 100 int14gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 1514 ( int41gt PGUID 12 f t t t 2 f 16 "23 =
2500" 100 0 0 100 int41gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 1515 ( int14ne PGUID 12 f t t t 2 f 16 =
"2500 23" 100 0 0 100 int14ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 1516 ( int41ne PGUID 12 f t t t 2 f 16 "23 =
2500" 100 0 0 100 int41ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 1517 ( int14le PGUID 12 f t t t 2 f 16 =
"2500 23" 100 0 0 100 int14le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 1518 ( int41le PGUID 12 f t t t 2 f 16 "23 =
2500" 100 0 0 100 int41le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 1519 ( int14ge PGUID 12 f t t t 2 f 16 =
"2500 23" 100 0 0 100 int14ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 1520 ( int41ge PGUID 12 f t t t 2 f 16 "23 =
2500" 100 0 0 100 int41ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 1521 ( int14mul PGUID 12 f t t t 2 f 23 =
"2500 23" 100 0 0 100 int14mul - 0 ));
DESCR("multiply");
DATA(insert OID =3D 1522 ( int41mul PGUID 12 f t t t 2 f 23 "23 =
2500" 100 0 0 100 int41mul - 0 ));
DESCR("multiply");
DATA(insert OID =3D 1523 ( int14div PGUID 12 f t t t 2 f 23 =
"2500 23" 100 0 0 100 int14div - 0 ));
DESCR("divide");
DATA(insert OID =3D 1524 ( int41div PGUID 12 f t t t 2 f 23 "23 =
2500" 100 0 0 100 int41div - 0 ));
DESCR("divide");
DATA(insert OID =3D 1525 ( int14mod PGUID 12 f t t t 2 f 23 =
"2500 23" 100 0 0 100 int14mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 1526 ( int41mod PGUID 12 f t t t 2 f 23 "23 =
2500" 100 0 0 100 int41mod - 0 ));
DESCR("modulus");
/* conditional on JB_INTEGER_MATH_CHANGE =20
* DATA(insert OID =3D 1527 ( int14pl PGUID 12 f t t t 2 f 20 =
"2500 23" 100 0 0 100 int14pl - intpl_sizer ));
* DESCR("add");
* DATA(insert OID =3D 1528 ( int41pl PGUID 12 f t t t 2 f 20 =
"23 2500" 100 0 0 100 int41pl - intpl_sizer ));
* DESCR("add");
*/=20
DATA(insert OID =3D 1527 ( int14pl PGUID 12 f t t t 2 f 23 =
"2500 23" 100 0 0 100 int14pl - 0 ));
DESCR("add");
DATA(insert OID =3D 1528 ( int41pl PGUID 12 f t t t 2 f 23 "23 =
2500" 100 0 0 100 int41pl - 0 ));
DESCR("add");
DATA(insert OID =3D 1529 ( int14mi PGUID 12 f t t t 2 f 23 =
"2500 23" 100 0 0 100 int14mi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 1530 ( int41mi PGUID 12 f t t t 2 f 23 "23 =
2500" 100 0 0 100 int41mi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 1531 ( int18eq PGUID 12 f t t t 2 f 16 =
"2500 20" 100 0 0 100 int18eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 1532 ( int81eq PGUID 12 f t t t 2 f 16 "20 =
2500" 100 0 0 100 int81eq - 0 ));
DESCR("equal");
DATA(insert OID =3D 1533 ( int18lt PGUID 12 f t t t 2 f 16 =
"2500 20" 100 0 0 100 int18lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 1534 ( int81lt PGUID 12 f t t t 2 f 16 "20 =
2500" 100 0 0 100 int81lt - 0 ));
DESCR("less-than");
DATA(insert OID =3D 1535 ( int18gt PGUID 12 f t t t 2 f 16 =
"2500 20" 100 0 0 100 int18gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 1536 ( int81gt PGUID 12 f t t t 2 f 16 "20 =
2500" 100 0 0 100 int81gt - 0 ));
DESCR("greater-than");
DATA(insert OID =3D 1537 ( int18ne PGUID 12 f t t t 2 f 16 =
"2500 20" 100 0 0 100 int18ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 1538 ( int81ne PGUID 12 f t t t 2 f 16 "20 =
2500" 100 0 0 100 int81ne - 0 ));
DESCR("not equal");
DATA(insert OID =3D 1539 ( int18le PGUID 12 f t t t 2 f 16 =
"2500 20" 100 0 0 100 int18le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 1540 ( int81le PGUID 12 f t t t 2 f 16 "20 =
2500" 100 0 0 100 int81le - 0 ));
DESCR("less-than-or-equal");
DATA(insert OID =3D 1541 ( int18ge PGUID 12 f t t t 2 f 16 =
"2500 20" 100 0 0 100 int18ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 1542 ( int81ge PGUID 12 f t t t 2 f 16 "20 =
2500" 100 0 0 100 int81ge - 0 ));
DESCR("greater-than-or-equal");
DATA(insert OID =3D 1543 ( int18mul PGUID 12 f t t t 2 f 20 =
"2500 20" 100 0 0 100 int18mul - 0 ));
DESCR("multiply");
DATA(insert OID =3D 1544 ( int81mul PGUID 12 f t t t 2 f 20 "20 =
2500" 100 0 0 100 int81mul - 0 ));
DESCR("multiply");
DATA(insert OID =3D 1545 ( int18div PGUID 12 f t t t 2 f 20 =
"2500 20" 100 0 0 100 int18div - 0 ));
DESCR("divide");
DATA(insert OID =3D 1546 ( int81div PGUID 12 f t t t 2 f 20 "20 =
2500" 100 0 0 100 int81div - 0 ));
DESCR("divide");
DATA(insert OID =3D 1547 ( int18mod PGUID 12 f t t t 2 f 20 =
"2500 20" 100 0 0 100 int18mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 1548 ( int81mod PGUID 12 f t t t 2 f 20 "20 =
2500" 100 0 0 100 int81mod - 0 ));
DESCR("modulus");
/* conditional on JB_INTEGER_MATH_CHANGE =20
* DATA(insert OID =3D 1549 ( int18pl PGUID 12 f t t t 2 f 20 =
"2500 20" 100 0 0 100 int18pl - intpl_sizer ));
* DESCR("add");
* DATA(insert OID =3D 1556 ( int81pl PGUID 12 f t t t 2 f 20 =
"20 2500" 100 0 0 100 int81pl - intpl_sizer ));
* DESCR("add");
*/=20
DATA(insert OID =3D 1549 ( int18pl PGUID 12 f t t t 2 f 20 =
"2500 20" 100 0 0 100 int18pl - 0 ));
DESCR("add");
DATA(insert OID =3D 1556 ( int81pl PGUID 12 f t t t 2 f 20 "20 =
2500" 100 0 0 100 int81pl - 0 ));
DESCR("add");
DATA(insert OID =3D 1557 ( int18mi PGUID 12 f t t t 2 f 20 =
"2500 20" 100 0 0 100 int18mi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 1558 ( int81mi PGUID 12 f t t t 2 f 20 "20 =
2500" 100 0 0 100 int81mi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 1559 ( int48mod PGUID 12 f t t t 2 f 20 "23 =
20" 100 0 0 100 int48mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 1560 ( int84mod PGUID 12 f t t t 2 f 20 "20 =
23" 100 0 0 100 int84mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 1561 ( int28mul PGUID 12 f t t t 2 f 20 "21 =
20" 100 0 0 100 int28mul - 0 ));
DESCR("multiply");
DATA(insert OID =3D 1562 ( int82mul PGUID 12 f t t t 2 f 20 "20 =
21" 100 0 0 100 int82mul - 0 ));
DESCR("multiply");
DATA(insert OID =3D 1563 ( int28div PGUID 12 f t t t 2 f 20 "21 =
20" 100 0 0 100 int28div - 0 ));
DESCR("divide");
DATA(insert OID =3D 1564 ( int82div PGUID 12 f t t t 2 f 20 "20 =
21" 100 0 0 100 int82div - 0 ));
DESCR("divide");
DATA(insert OID =3D 1565 ( int28mod PGUID 12 f t t t 2 f 20 "21 =
20" 100 0 0 100 int28mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 1566 ( int82mod PGUID 12 f t t t 2 f 20 "20 =
21" 100 0 0 100 int82mod - 0 ));
DESCR("modulus");
/* conditional on JB_INTEGER_MATH_CHANGE =20
* DATA(insert OID =3D 1567 ( int28pl PGUID 12 f t t t 2 f 20 =
"21 20" 100 0 0 100 int28pl - intpl_sizer ));
* DESCR("add");
* DATA(insert OID =3D 1568 ( int82pl PGUID 12 f t t t 2 f 20 =
"20 21" 100 0 0 100 int82pl - intpl_sizer ));
* DESCR("add");
*/=20
DATA(insert OID =3D 1567 ( int28pl PGUID 12 f t t t 2 f 20 "21 =
20" 100 0 0 100 int28pl - 0 ));
DESCR("add");
DATA(insert OID =3D 1568 ( int82pl PGUID 12 f t t t 2 f 20 "20 =
21" 100 0 0 100 int82pl - 0 ));
DESCR("add");
DATA(insert OID =3D 1577 ( int28mi PGUID 12 f t t t 2 f 20 "21 =
20" 100 0 0 100 int28mi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 1578 ( int82mi PGUID 12 f t t t 2 f 20 "20 =
21" 100 0 0 100 int82mi - 0 ));
DESCR("subtract");
DATA(insert OID =3D 1579 ( numeric PGUID 12 f t t t 1 f 1700 =
"2500" 100 0 0 100 int1_numeric - int1_numeric_sizer ));
DESCR("(internal)");
DATA(insert OID =3D 1580 ( int1 PGUID 12 f t t t 1 f 2500 =
"1700" 100 0 0 100 numeric_int1 - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 1581 ( int1 PGUID 12 f t t t 1 f 2500 =
"2500" 100 0 0 100 noop - 0 ));
DESCR("convert (no-op)");
DATA(insert OID =3D 1582 ( mod PGUID 12 f t t t 2 f 2500 =
"2500 2500" 100 0 0 100 int1mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 1586 ( mod PGUID 12 f t t t 2 f 23 =
"2500 23" 100 0 0 100 int14mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 1587 ( mod PGUID 12 f t t t 2 f 23 "23 =
2500" 100 0 0 100 int41mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 1588 ( mod PGUID 12 f t t t 2 f 20 =
"2500 20" 100 0 0 100 int18mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 1589 ( mod PGUID 12 f t t t 2 f 20 "20 =
2500" 100 0 0 100 int81mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 1590 ( mod PGUID 12 f t t t 2 f 20 "21 =
20" 100 0 0 100 int28mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 1591 ( mod PGUID 12 f t t t 2 f 20 "20 =
21" 100 0 0 100 int82mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 1592 ( mod PGUID 12 f t t t 2 f 20 "23 =
20" 100 0 0 100 int48mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 1593 ( mod PGUID 12 f t t t 2 f 20 "20 =
23" 100 0 0 100 int84mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 1594 ( mod PGUID 12 f t t t 2 f 21 =
"2500 21" 100 0 0 100 int12mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 1595 ( mod PGUID 12 f t t t 2 f 21 "21 =
2500" 100 0 0 100 int21mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 1596 ( int1larger PGUID 12 f t t t 2 f 2500 =
"2500 2500" 100 0 0 100 int1larger - 0 ));
DESCR("larger of two");
DATA(insert OID =3D 1611 ( int1smaller PGUID 12 f t t t 2 f 2500 =
"2500 2500" 100 0 0 100 int1smaller - 0 ));
DESCR("smaller of two");
DATA(insert OID =3D 1146 ( mod PGUID 12 f t t t 2 f 700 =
"700 700" 100 0 0 100 float4mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 1147 ( mod PGUID 12 f t t t 2 f 701 =
"701 701" 100 0 0 100 float8mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 1148 ( float4mod PGUID 12 f t t t 2 f 700 =
"700 700" 100 0 0 100 float4mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 1149 ( float8mod PGUID 12 f t t t 2 f 701 =
"701 701" 100 0 0 100 float8mod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 567 ( int1 PGUID 12 f t t t 1 f 2500 =
"1043" 100 0 0 100 varchar_int1 - 0 ));
DESCR("convert varchar to int1");
DATA(insert OID =3D 568 ( varchar PGUID 12 f t t t 1 f 1043 =
"2500" 100 0 0 100 int1_varchar - int1_text_sizer ));
DESCR("convert int1 to varchar");
DATA(insert OID =3D 569 ( varchar PGUID 12 f t t t 1 f 1043 =
"21" 100 0 0 100 int2_varchar - int2_text_sizer ));
DESCR("convert int2 to varchar");
DATA(insert OID =3D 570 ( mod PGUID 12 f t t t 2 f 701 =
"1700 701" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 571 ( mod PGUID 12 f t t t 2 f 701 =
"701 1700" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 572 ( mod PGUID 12 f t t t 2 f 701 =
"1700 700" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 573 ( mod PGUID 12 f t t t 2 f 701 =
"700 1700" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 574 ( mod PGUID 12 f t t t 2 f 701 =
"701 700" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 575 ( mod PGUID 12 f t t t 2 f 701 =
"700 701" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 576 ( mixedmod PGUID 12 f t t t 2 f 701 =
"1700 701" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 577 ( mixedmod PGUID 12 f t t t 2 f 701 =
"701 1700" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 578 ( mixedmod PGUID 12 f t t t 2 f 701 =
"1700 700" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 579 ( mixedmod PGUID 12 f t t t 2 f 701 =
"700 1700" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 580 ( mod PGUID 12 f t t t 2 f 1700 =
"1700 2500" 100 0 0 100 nmixedmod - ni1mod_sizer ));
DESCR("modulus");
DATA(insert OID =3D 901 ( mod PGUID 12 f t t t 2 f 701 =
"701 2500" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 902 ( mod PGUID 12 f t t t 2 f 701 =
"700 2500" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 903 ( mod PGUID 12 f t t t 2 f 1700 =
"1700 21" 100 0 0 100 nmixedmod - ni2mod_sizer ));
DESCR("modulus");
DATA(insert OID =3D 904 ( mod PGUID 12 f t t t 2 f 701 =
"701 21" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 905 ( mod PGUID 12 f t t t 2 f 701 =
"700 21" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 906 ( mod PGUID 12 f t t t 2 f 1700 =
"1700 23" 100 0 0 100 nmixedmod - ni4mod_sizer ));
DESCR("modulus");
DATA(insert OID =3D 907 ( mod PGUID 12 f t t t 2 f 701 =
"701 23" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 908 ( mod PGUID 12 f t t t 2 f 701 =
"700 23" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 909 ( mod PGUID 12 f t t t 2 f 1700 =
"1700 20" 100 0 0 100 nmixedmod - ni8mod_sizer ));
DESCR("modulus");
DATA(insert OID =3D 910 ( mod PGUID 12 f t t t 2 f 701 =
"701 20" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 911 ( mod PGUID 12 f t t t 2 f 701 =
"700 20" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 912 ( mod PGUID 12 f t t t 2 f 1700 =
"2500 1700" 100 0 0 100 nmixedmod - i1nmod_sizer ));
DESCR("modulus");
DATA(insert OID =3D 913 ( mod PGUID 12 f t t t 2 f 701 =
"2500 701" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 914 ( mod PGUID 12 f t t t 2 f 701 =
"2500 700" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 915 ( mod PGUID 12 f t t t 2 f 1700 =
"21 1700" 100 0 0 100 nmixedmod - i2nmod_sizer ));
DESCR("modulus");
DATA(insert OID =3D 916 ( mod PGUID 12 f t t t 2 f 701 =
"21 701" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 917 ( mod PGUID 12 f t t t 2 f 701 =
"21 700" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 918 ( mod PGUID 12 f t t t 2 f 1700 =
"23 1700" 100 0 0 100 nmixedmod - i4nmod_sizer ));
DESCR("modulus");
DATA(insert OID =3D 919 ( mod PGUID 12 f t t t 2 f 701 =
"23 701" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 920 ( mod PGUID 12 f t t t 2 f 701 =
"23 700" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 921 ( mod PGUID 12 f t t t 2 f 1700 =
"20 1700" 100 0 0 100 nmixedmod - i8nmod_sizer ));
DESCR("modulus");
DATA(insert OID =3D 922 ( mod PGUID 12 f t t t 2 f 701 =
"20 701" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 923 ( mod PGUID 12 f t t t 2 f 701 =
"20 700" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 924 ( ni1mixedmod PGUID 12 f t t t 2 f 1700 =
"1700 2500" 100 0 0 100 nmixedmod - ni1mod_sizer ));
DESCR("modulus");
DATA(insert OID =3D 925 ( mixedmod PGUID 12 f t t t 2 f 701 =
"701 2500" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 926 ( mixedmod PGUID 12 f t t t 2 f 701 =
"700 2500" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 927 ( ni2mixedmod PGUID 12 f t t t 2 f 1700 =
"1700 21" 100 0 0 100 nmixedmod - ni2mod_sizer ));
DESCR("modulus");
DATA(insert OID =3D 928 ( mixedmod PGUID 12 f t t t 2 f 701 =
"701 21" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 929 ( mixedmod PGUID 12 f t t t 2 f 701 =
"700 21" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 930 ( ni4mixedmod PGUID 12 f t t t 2 f 1700 =
"1700 23" 100 0 0 100 nmixedmod - ni4mod_sizer ));
DESCR("modulus");
DATA(insert OID =3D 931 ( mixedmod PGUID 12 f t t t 2 f 701 =
"701 23" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 932 ( mixedmod PGUID 12 f t t t 2 f 701 =
"700 23" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 933 ( ni8mixedmod PGUID 12 f t t t 2 f 1700 =
"1700 20" 100 0 0 100 nmixedmod - ni8mod_sizer ));
DESCR("modulus");
DATA(insert OID =3D 934 ( mixedmod PGUID 12 f t t t 2 f 701 =
"701 20" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 511 ( mixedmod PGUID 12 f t t t 2 f 701 =
"700 20" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 512 ( i1nmixedmod PGUID 12 f t t t 2 f 1700 =
"2500 1700" 100 0 0 100 nmixedmod - i1nmod_sizer ));
DESCR("modulus");
DATA(insert OID =3D 513 ( mixedmod PGUID 12 f t t t 2 f 701 =
"2500 701" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 495 ( mixedmod PGUID 12 f t t t 2 f 701 =
"2500 700" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 496 ( i2nmixedmod PGUID 12 f t t t 2 f 1700 =
"21 1700" 100 0 0 100 nmixedmod - i2nmod_sizer ));
DESCR("modulus");
DATA(insert OID =3D 497 ( mixedmod PGUID 12 f t t t 2 f 701 =
"21 701" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 498 ( mixedmod PGUID 12 f t t t 2 f 701 =
"21 700" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 499 ( i4nmixedmod PGUID 12 f t t t 2 f 1700 =
"23 1700" 100 0 0 100 nmixedmod - i4nmod_sizer ));
DESCR("modulus");
DATA(insert OID =3D 500 ( mixedmod PGUID 12 f t t t 2 f 701 =
"23 701" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 501 ( mixedmod PGUID 12 f t t t 2 f 701 =
"23 700" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 502 ( i8nmixedmod PGUID 12 f t t t 2 f 1700 =
"20 1700" 100 0 0 100 nmixedmod - i8nmod_sizer ));
DESCR("modulus");
DATA(insert OID =3D 503 ( mixedmod PGUID 12 f t t t 2 f 701 =
"20 701" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
DATA(insert OID =3D 504 ( mixedmod PGUID 12 f t t t 2 f 701 =
"20 700" 100 0 0 100 mixedmod - 0 ));
DESCR("modulus");
#define BLAST_blast 505
DATA(insert OID =3D 505 ( blast PGUID 12 f t t t 3 f 16 "25 =
25 1043" 100 0 0 100 blastmatch - 0 ));
DESCR("blast match");
DATA(insert OID =3D 506 ( blobin PGUID 12 f t t t 1 f 25 "0" =
100 0 0 100 blobin - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 507 ( blobout PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 blobout - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 508 ( nuclin PGUID 12 f t t t 1 f 25 "0" =
100 0 0 100 nuclin - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 509 ( nuclout PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 nuclout - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 510 ( blastcol PGUID 12 f t f t 1 f 23 =
"23" 100 0 0 100 blastcol - 0 ));
DESCR("(internal)");
#define BLASTCOL_FUNCOID 510
DATA(insert OID =3D 516 ( protin PGUID 12 f t t t 1 f 25 "0" =
100 0 0 100 protin - 0 ));
DESCR("(internal)");
DATA(insert OID =3D 517 ( protout PGUID 12 f t t t 1 f 23 "0" =
100 0 0 100 protout - 0 ));
DESCR("(internal)");
#define BLAST_blastn 449
DATA(insert OID =3D 449 ( blastn PGUID 12 f t t t 3 f 16 =
"2569 2569 1043" 100 0 0 100 blastmatch - 0 ));
DESCR("blast match");
#define BLAST_blastp 450
DATA(insert OID =3D 450 ( blastp PGUID 12 f t t t 3 f 16 =
"2570 2570 1043" 100 0 0 100 blastmatch - 0 ));
DESCR("blast match");
#define BLAST_blastx 451
DATA(insert OID =3D 451 ( blastx PGUID 12 f t t t 3 f 16 =
"2570 2569 1043" 100 0 0 100 blastmatch - 0 ));
DESCR("blast match");
#define BLAST_tblastn 452
DATA(insert OID =3D 452 ( tblastn PGUID 12 f t t t 3 f 16 =
"2569 2570 1043" 100 0 0 100 blastmatch - 0 ));
DESCR("blast match");
#define BLAST_tblastx 453
DATA(insert OID =3D 453 ( tblastx PGUID 12 f t t t 3 f 16 =
"2569 2569 1043" 100 0 0 100 blastmatch - 0 ));
DESCR("blast match");
/*
* Special "/=3D/" operator functions for DECODE CASE variant
* Note - all are non-strict
*/
DATA(insert OID =3D 784 ( nint4eq PGUID 12 f t t f 2 f 16 "23 =
23" 100 0 0 100 nint4eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 785 ( nint8eq PGUID 12 f t t f 2 f 16 "20 =
20" 100 0 0 100 nint8eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 786 ( nint1eq PGUID 12 f t t f 2 f 16 =
"2500 2500" 100 0 0 100 nint1eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 787 ( nint2eq PGUID 12 f t t f 2 f 16 "21 =
21" 100 0 0 100 nint2eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 788 ( nint48eq PGUID 12 f t t f 2 f 16 "23 =
20" 100 0 0 100 nint48eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 789 ( nint84eq PGUID 12 f t t f 2 f 16 "20 =
23" 100 0 0 100 nint84eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 790 ( nint24eq PGUID 12 f t t f 2 f 16 "21 =
23" 100 0 0 100 nint24eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 791 ( nint42eq PGUID 12 f t t f 2 f 16 "23 =
21" 100 0 0 100 nint42eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 792 ( nint28eq PGUID 12 f t t f 2 f 16 "21 =
20" 100 0 0 100 nint28eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 793 ( nint82eq PGUID 12 f t t f 2 f 16 "20 =
21" 100 0 0 100 nint82eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 794 ( nint12eq PGUID 12 f t t f 2 f 16 =
"2500 21" 100 0 0 100 nint12eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 795 ( nint21eq PGUID 12 f t t f 2 f 16 "21 =
2500" 100 0 0 100 nint21eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 796 ( nint14eq PGUID 12 f t t f 2 f 16 =
"2500 23" 100 0 0 100 nint14eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 797 ( nint41eq PGUID 12 f t t f 2 f 16 "23 =
2500" 100 0 0 100 nint41eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 798 ( nint18eq PGUID 12 f t t f 2 f 16 =
"2500 20" 100 0 0 100 nint18eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 799 ( nint81eq PGUID 12 f t t f 2 f 16 "20 =
2500" 100 0 0 100 nint81eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 800 ( nbooleq PGUID 12 f t t f 2 f 16 "16 =
16" 100 0 0 100 nbooleq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 801 ( nfloat4eq PGUID 12 f t t f 2 f 16 =
"700 700" 100 0 0 100 nfloat4eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 802 ( nfloat8eq PGUID 12 f t t f 2 f 16 =
"701 701" 100 0 0 100 nfloat8eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 803 ( nbpchareq PGUID 12 f t t f 2 f 16 =
"1042 1042" 100 0 0 100 nbpchareq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 804 ( nvarchareq PGUID 12 f t t f 2 f 16 =
"1043 1043" 100 0 0 100 nvarchareq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 805 ( ndate_eq PGUID 12 f t t f 2 f 16 =
"1082 1082" 100 0 0 100 ndate_eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 806 ( ntime_eq PGUID 12 f t t f 2 f 16 =
"1083 1083" 100 0 0 100 ntime_eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 807 ( ntimetz_eq PGUID 12 f t t f 2 f 16 =
"1266 1266" 100 0 0 100 ntimetz_eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 808 ( nfloat48eq PGUID 12 f t t f 2 f 16 =
"700 701" 100 0 0 100 nfloat48eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 809 ( nfloat84eq PGUID 12 f t t f 2 f 16 =
"701 700" 100 0 0 100 nfloat84eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 811 ( ntimestamp_eq PGUID 12 f t t f 2 f 16 =
"1184 1184" 100 0 0 100 ntimestamp_eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 812 ( ninterval_eq PGUID 12 f t t f 2 f 16 =
"1186 1186" 100 0 0 100 ninterval_eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 816 ( nnumeric_eq PGUID 12 f t t f 2 f 16 =
"1700 1700" 100 0 0 100 nnumeric_eq - 0 ));
DESCR("decode equal");
DATA(insert OID =3D 1200 ( cleantmp PGUID 12 f t t t 0 f 23 "" =
100 0 0 100 cleanup_temp_tables - 0 ));
DESCR("clean up temp tables after crash");
/* blast string functions */
DATA(insert OID =3D 143 ( reverse PGUID 12 f t t t 1 f 2569 =
"2569" 100 0 0 100 nucl_reverse - to_text_sizer ));
DESCR("reverse nulceotide");
DATA(insert OID =3D 277 ( reverse PGUID 12 f t t t 1 f 2570 =
"2570" 100 0 0 100 prot_reverse - to_text_sizer ));
DESCR("reverse protein");
DATA(insert OID =3D 712 ( bioposition PGUID 12 f t t t 4 f 23 =
"2569 2569 23 23" 100 0 0 100 nucl_position - 0 ));
DESCR("nucleotide position");
DATA(insert OID =3D 767 ( bioposition PGUID 12 f t t t 4 f 23 =
"2570 2570 23 23" 100 0 0 100 prot_position - 0 ));
DESCR("protein position");
DATA(insert OID =3D 1194 ( forwardtranslate PGUID 12 f t t t 3 f 2570 =
"2569 23 23" 100 0 0 100 forwardtranslate - to_text_sizer ));
DESCR("forward translate nucleotide to protein");
DATA(insert OID =3D 1231 ( backwardtranslate PGUID 12 f t t t 2 f 2569 =
"2570 1043" 100 0 0 100 backwardtranslate - to_text_sizer ));
DESCR("backward translate protein to nucleotide");
DATA(insert OID =3D 1267 ( cksum PGUID 12 f t t t 1 f 23 =
"2569" 100 0 0 100 nucl_cksum - 0 ));
DESCR("nucleotide checksum");
DATA(insert OID =3D 1270 ( cksum PGUID 12 f t t t 1 f 23 =
"2570" 100 0 0 100 prot_cksum - 0 ));
DESCR("protein checksum");
DATA(insert OID =3D 1284 ( cksum PGUID 12 f t t t 1 f 23 "25" =
100 0 0 100 text_cksum - 0 ));
DESCR("text checksum");
DATA(insert OID =3D 1288 ( translate PGUID 12 f t t t 3 f 25 "25 =
1043 1043" 100 0 0 100 text_translate - to_text_sizer ));
DESCR("text translate");
DATA(insert OID =3D 1367 ( translate PGUID 12 f t t t 3 f 2569 =
"2569 1043 1043" 100 0 0 100 nucl_translate - to_text_sizer ));
DESCR("nucleotide translate");
DATA(insert OID =3D 1383 ( translate PGUID 12 f t t t 3 f 2570 =
"2570 1043 1043" 100 0 0 100 prot_translate - to_text_sizer ));
DESCR("protein translate");
/*
* SQL/OLAP window aggrs
*/
DATA(insert OID =3D 239 ( ndewindowaggr PGUID 12 f t t t 0 f 0 "" =
100 0 0 100 ndewindowaggr - 0 ));
DESCR("internal");
/*
* prototypes for functions pg_proc.c
*/
extern Oid ProcedureCreate(char *procedureName,
bool returnsSet,
char *returnTypeName,
char *languageName,
char *prosrc,
char *probin,
bool trusted,
bool canCache,
bool isStrict,
int32 byte_pct,
int32 perbyte_cpu,
int32 percall_cpu,
int32 outin_ratio,
List *argList,
CommandDest dest);
#endif /* PG_PROC_H */
|